Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

locks

2 posts in Windows NT Last posting was on 2000-03-21 11:46:15.0Z
David Ma Posted on 2000-03-17 03:16:02.0Z
From: "David Ma" <changqing.ma@usa.net>
Subject: locks
Date: Fri, 17 Mar 2000 16:16:02 +1300
Lines: 9
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <WD1U087j$GA.261@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ou075211.otago.ac.nz 139.80.75.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2404
Article PK: 1089856

I have large amount of data that should be bcped to a table. I alse did
lots of update in this table. I have only one user for the database. I
always meet run out of locks problem. Can I do not use any lock in the
table? If I can, How?

Thanks


Ahmad AbdelHady Posted on 2000-03-21 11:46:15.0Z
Reply-To: "Ahmad AbdelHady" <ahady@generation.ca>
From: "Ahmad AbdelHady" <ahady@generation.ca>
References: <WD1U087j$GA.261@forums.sybase.com>
Subject: Re: locks
Date: Tue, 21 Mar 2000 13:46:15 +0200
Lines: 20
Organization: Generation Systems Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <vx5ONuyk$GA.201@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 60-15.idsc.gov.eg 163.121.15.60
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2395
Article PK: 1089848

here are a few tips:
- increase "number of locks" configuratrion parameter
- drop clustered index and use NonClustered indexes
- try table partionting (two partitions over two segments'd suit you)
- if you have a huge size of data BCPed try dropping all indexes and
recreate them afterwards (but take care of uniquness)

David Ma <changqing.ma@usa.net> wrote in message
news:WD1U087j$GA.261@forums.sybase.com...
> I have large amount of data that should be bcped to a table. I alse did
> lots of update in this table. I have only one user for the database. I
> always meet run out of locks problem. Can I do not use any lock in the
> table? If I can, How?
>
> Thanks
>
>
>