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