Sybase:getLockInfo

Gets information about user locks.

Type

SYNC, IMPACT_ACTION_INFO

Arguments

None.

Returns

Name	Type	Description
(Table is indexed on the spid, table_id, and page.)
fid	Integer	The file ID.
spid	Integer	The user process ID in the database server.
loid	Integer	The lock owner ID.
locktype	String	The lock type.
table_id	Integer	The table ID in the database server.
page	Integer	The page ID in the database server.
row	Integer	The row number.
dbname	String	The database name
class	String	The lock class
context	String	The lock context.

Usage Notes

This method reports the locks currently being held on the server. Invoking this method allows one to see the current state of the locks on the databases. The locktype column indicates not only whether the lock is a shared lock ("Sh" prefix), an exclusive lock ("Ex" prefix), or an "update" lock, but also whether it is held on a table ("table" or "intent") or on a "page."

Refer to the system stored procedure sp_lock for details.