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.

Stored procedure - sa_internal_locks

2 posts in General Discussion Last posting was on 2007-02-20 20:25:44.0Z
M Sun Posted on 2007-02-20 19:05:22.0Z
Sender: 2270.45db4547.1804289383@sybase.com
From: M Sun
Newsgroups: ianywhere.public.general
Subject: Stored procedure - sa_internal_locks
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45db4672.22fc.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Feb 2007 11:05:22 -0800
X-Trace: forums-1-dub 1171998322 10.22.241.41 (20 Feb 2007 11:05:22 -0800)
X-Original-Trace: 20 Feb 2007 11:05:22 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5851
Article PK: 1838

Hi,

I just upgrade our database from ASA 8.0.2 to ASA 10. I got
an error when the stored procedure sa_internal_locks is
used. The error is "Name of the procedure that could not be
found". It seems that this procedure is not supported in ASA
10. Then, what should we use? Thanks.

Regards,
M Sun


Glenn Paulley Posted on 2007-02-20 20:25:44.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Stored procedure - sa_internal_locks
From: Glenn Paulley <paulley@ianywhere.com>
References: <45db4672.22fc.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns98DD9A3895C3Fpaulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: vpn-dub-064.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-064.sybase.com
Date: 20 Feb 2007 12:25:44 -0800
X-Trace: forums-1-dub 1172003144 10.22.120.64 (20 Feb 2007 12:25:44 -0800)
X-Original-Trace: 20 Feb 2007 12:25:44 -0800, vpn-dub-064.sybase.com
Lines: 27
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5852
Article PK: 1835


M Sun wrote in news:45db4672.22fc.1681692777@sybase.com:

> Hi,
>
> I just upgrade our database from ASA 8.0.2 to ASA 10. I got
> an error when the stored procedure sa_internal_locks is
> used. The error is "Name of the procedure that could not be
> found". It seems that this procedure is not supported in ASA
> 10. Then, what should we use? Thanks.
>
> Regards,
> M Sun

Use the sa_locks() procedure.

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288