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.

Table Locks

2 posts in General Discussion Last posting was on 2003-09-29 14:56:35.0Z
Marion Rotolo Posted on 2003-09-29 14:50:14.0Z
Sender: 1c6.3f78461b.1804289383@sybase.com
From: Marion Rotolo
Newsgroups: ianywhere.public.general
Subject: Table Locks
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f7846a6.1ca.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Sep 2003 07:50:14 -0700
X-Trace: forums-1-dub 1064847014 10.22.241.41 (29 Sep 2003 07:50:14 -0700)
X-Original-Trace: 29 Sep 2003 07:50:14 -0700, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1814
Article PK: 4094

Using ASA 7.0.3 I think I am having a problem with table
locks. How can I tell which table is locked and who has it
locked?


Breck Carter [TeamSybase] Posted on 2003-09-29 14:56:35.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Table Locks
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <4khgnvofhp97irh0qolnotfpavg4ten6bb@4ax.com>
References: <3f7846a6.1ca.846930886@sybase.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 29 Sep 2003 07:59:22 -0700, bcarter.sentex.ca
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Sep 2003 07:51:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Sep 2003 07:56:35 -0700
X-Trace: forums-1-dub 1064847395 10.22.108.75 (29 Sep 2003 07:56:35 -0700)
X-Original-Trace: 29 Sep 2003 07:56:35 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1815
Article PK: 17345

The sa_conn_info procedure will show you the connection number for
each connection in the "Number" column. If the "BlockedOn" column is
not zero then it contains the connection number of the connection that
is blocking this one.

If you have a blocked connection you can find out more information
with sa_locks procedure.

Please read about both of these in the Help.

Breck

On 29 Sep 2003 07:50:14 -0700, Marion Rotolo wrote:

>Using ASA 7.0.3 I think I am having a problem with table
>locks. How can I tell which table is locked and who has it
>locked?

--
bcarter@risingroad.com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com