Display all Locks using Base Sysmaster Tables (1 of 2)
-- locks.sql
select dbsname,
b.tabname,
rowidr,
keynum,
e.txt type,
d.sid owner,
g.username ownername,
f.sid waiter,
h.username waitname
from syslcktab a,
systabnames b,
systxptab c,
sysrstcb d,
sysscblst g,
flags_text e,
outer ( sysrstcb f , sysscblst h ) Continued on next slide …..
Previous slide
Next slide
Back to first slide
View graphic version