Re: onstat -k

Harold, The sysmaster : syslocks table is full of useful info about locks, such as tablename, owner, etc. Drew. Harold Luse wrote in message <6i54kg$pv0$1@news.xmission.com>... > >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 >==================================================================== > >