SQL Anywhere database

Author

Locks...

Alex Castillo

2005-07-11, 11:23 am

Hi..!

I have a question... using Sybase SQL Anywhere Server v 5.5.04 build 1867
how can I know, at any given time, which records/tables/objects are locked
and by who?

Thank you!

Reg Domaratzki $iAnywhere Solutions$

2005-07-11, 11:23 am

At v5504, you can't. The sa_locks stored procedure was introduce in at some
point during v7, but I can't remember exactly when.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Alex Castillo" < klmAlexCast_SlwMx@Ho
tMail.Com> wrote in message
news:42d29c66$1@foru
ms-1-dub...
> Hi..!
>
> I have a question... using Sybase SQL Anywhere Server v 5.5.04 build 1867
> how can I know, at any given time, which records/tables/objects are locked
> and by who?
>
> Thank you!
>
>
>

Breck Carter [TeamSybase]

2005-07-11, 1:23 pm

A partial answer to the "who": The sa_conn_info BlockedOn column tells
you what *other* connection number is blocking *this* one.

Not a direct answer to your question, but it *does* tell you which
connection to drop :)

Breck

On 11 Jul 2005 09:20:54 -0700, "Alex Castillo"
< klmAlexCast_SlwMx@Ho
tMail.Com> wrote:

>Hi..!
>
>I have a question... using Sybase SQL Anywhere Server v 5.5.04 build 1867
>how can I know, at any given time, which records/tables/objects are locked
>and by who?
>
>Thank you!
>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links