sp_lock status

[ku]

Hi all,

Please go through the below pasted text and explan me what
is this senario. This is a modified output of "sp_who"

I cannot be able to see the spid 162 it looks like a hidden
lock. How to clear this.

srvr id status loginame hostname blk dbname
cmd
------ --- ------------ ---------- ---------- ---
---------- ----------------
xxxxx 2 sleeping NULL 0 master
NETWORK HANDLER
xxxxx 3 sleeping NULL 0 master
NETWORK HANDLER
xxxxx 4 sleeping NULL 0 master
DEADLOCK TUNE
xxxxx 5 sleeping NULL 0 master
MIRROR HANDLER
xxxxx 6 sleeping NULL 0 master
SHUTDOWN HANDLER
xxxxx 7 sleeping NULL 0 master
ASTC HANDLER
xxxxx 9 sleeping NULL 0 master
HOUSEKEEPER
xxxxx 10 sleeping NULL 0 master
DTC COMMIT SVC
xxxxx 253 running rambo WinNT 0 master
SELECT
xxxxx 310 sleeping test 0 newbook
SELECT
xxxxx 392 lock sleep test 162 G_Book
TRUNCATE TABLE

(12 rows affected)
(return status = 0)
1> dbcc sqltext(392)
2>
SQL Text: truncate table temp

DBCC execution completed. If DBCC printed error messages,
contact a user with
System Administrator (SA) role.
1> sp_lock 162
2>
The class column will display the cursor name for locks
associated with a cursor

for the current user and the cursor id for other users.
fid spid loid locktype
table_id page
row dbname class
context
------ ------ ----------- ----------------------------
----------- -----------
------ ---------------
------------------------------
----------------------------
0 162 324 Sh_intent
1760009301 0
0 G_Book Non Cursor Lock

0 162 324 Sh_intent
1692533063 0
0 G_Book Non Cursor Lock

0 162 324 Sh_intent
1820533519 0
0 G_Book Non Cursor Lock

0 162 324 Sh_intent
1920009871 0
0 G_Book Non Cursor Lock

0 162 324 Sh_intent
857106144 0
0 G_Book Non Cursor Lock

0 162 324 Sh_intent-blk
1001822681 0
0 G_Book Non Cursor Lock

TIA
ku

[Rob Verschoor]

Well, it the first query is a modified version of sp_who, then oerhaps there
some kind of error in it?
What you would really need to do here is check the contents of sysprocesses
and syslocks for the particular spid and post that output.

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (new edition!)
"The Complete Sybase ASE Quick Reference Guide" (new edition!)
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:r...@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<ku> wrote in message news:45667e2c.201...@sybase.com...