Re: onstat -k

Harold Luse wrote: > 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 > ==================================================================== Harold, First, you have to convert the value of tblsnum to decimal (0x90000b --> 9437195). Then you may launch the following SQL-statement: select tabname, partnum from systables where partnum = 9437195; This gives you the name of the involved table. Regards -- Helmut Leininger Bull AG / Vienna Unix Support Email: Helmut.Leininger@bull.net This opinion is mine and not necesserily that of my employer. No guarantees whatsoever.