DB2 unloack script??

[Neutrino]

Hi,

I have a query as to whether it is possible to find through script whether a DB2 table is locked by a user/process.
I want to do this programmatically. can this be done?

Amicalement,
Neutrino

 

[wyrd]

No idea what DB2 means, but if youre using SQL Server you can use the syslockinfo system table to retrieve locked info;

http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409

Theres also sp_lock (which is probably more appropriate)

http://msdn.microsoft.com/library/default.asp?url=/nhp/default.asp?contentid=28000409