onstat -k
How would one link the tblsnum field of an onstat -k with a table name?
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
3008c64c 0 4004a354 0 HDR+S 100002 230 0
3008c680 0 40042814 0 S 100002 22f 0
3008c6b4 0 40047494 0 HDR+S 100002 22f 0
3008c6e8 0 40045294 0 S 100002 22e 0
3008c71c 0 40043094 0 S 100002 22f 0
3008c750 0 4003bdd4 0 S 100002 22e 0
3008c784 0 4003e854 0 S 100002 22f 0
3008c7b8 0 400456d4 3008c958 HDR+IX 90000b 0 0
3008c7ec 0 40041714 3008dd40 S 100002 22f 0
3008c820 0 400456d4 3008c7b8 HDR+X 90000b 6d6116 0
3008c854 0 40041f94 0 S 100002 22f 0
I would like to find out the table name of the table with the exclusive
lock on it (tblsnum 90000b).
====================================================================
Harold Luse Phone: (970) 491-4120
Veterinary Teaching Hospital Fax: (970) 491-1275
Colorado State University Pager: (970) 229-8173
Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu
====================================================================