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.

Somehow my DB is sometimes locked for inserts, updates and deletes

2 posts in Performance and Tuning Last posting was on 2012-11-29 19:26:49.0Z
rsm Posted on 2012-11-27 21:13:25.0Z
Sender: 2ed2.50b52ae6.1804289383@sybase.com
From: rsm
Newsgroups: sybase.public.ase.performance+tuning
Subject: Somehow my DB is sometimes locked for inserts, updates and deletes
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50b52cf5.2fa8.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 27 Nov 2012 13:13:25 -0800
X-Trace: forums-1-dub 1354050805 172.20.134.41 (27 Nov 2012 13:13:25 -0800)
X-Original-Trace: 27 Nov 2012 13:13:25 -0800, 172.20.134.41
Lines: 21
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:13301
Article PK: 155146

Hi

I have a Sybase 12.5.4 with all data row locking tables and
have a very big problem.

Sometimes my tables are locked for inserts, updates and
deletes, mostly it is inserts that are bloked and I get no
new inserts in some seconds ( 3 - 90 ), but al of a sudden
everything is back to normal and everything works fine
again. I is different tables so I can't pinpoint if one
table is off, for example if it has some strange constraint
to another table with no index.

I am not sure where to look, perhaps you have some things I
can take a look at?

- Can an index on another table be locked, sometimes it is a
number of different tables that has the insert problem, and
the only thing they have in common is that they has a
constraint to a very big table which referes to its primary
index.


rick_806 Posted on 2012-11-29 19:26:49.0Z
Sender: 6ad2.50b7b4fe.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.ase.performance+tuning
Subject: Re: Somehow my DB is sometimes locked for inserts, updates and deletes
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50b7b6f9.6b36.1681692777@sybase.com>
References: <50b52cf5.2fa8.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 29 Nov 2012 11:26:49 -0800
X-Trace: forums-1-dub 1354217209 172.20.134.41 (29 Nov 2012 11:26:49 -0800)
X-Original-Trace: 29 Nov 2012 11:26:49 -0800, 172.20.134.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:13307
Article PK: 91792

Check syslogshold for long running transactions. Are you
using chained mode? Chained transactions often get left
uncommitted and can hang many tables. Run sysmon during
issue to see if you are hitting some limitation in
configuration. Does the error log have nothing in it for
these times? Do you have threshold alerts on the DB
transaction log? You might also put one on tempdb in case
everyone is getting held up by full tempdb.

good luck,
rick_806

> Hi
>
> I have a Sybase 12.5.4 with all data row locking tables
> and have a very big problem.
>
> Sometimes my tables are locked for inserts, updates and
> deletes, mostly it is inserts that are bloked and I get no
> new inserts in some seconds ( 3 - 90 ), but al of a sudden
> everything is back to normal and everything works fine
> again. I is different tables so I can't pinpoint if one
> table is off, for example if it has some strange
> constraint to another table with no index.
>
> I am not sure where to look, perhaps you have some things
> I can take a look at?
>
> - Can an index on another table be locked, sometimes it is
> a number of different tables that has the insert problem,
> and the only thing they have in common is that they has a
> constraint to a very big table which referes to its
> primary index.