Re: onstat -k

Try this: select tabname, hex(partnum) from systables The tblsnum column is the partnum. The first (leftmost) digit in the partnum is the number of the dbspace that the table is located in. The second part is the offset in the tablespace-tablespace. Most of the entries you see are 100002. This number is the database-tablespace which is a special table in the root dbspace that has info on all the databases that you create. Consequently you will not see this number when you run the sql statement above in any particular database. These locks are database level locks. George 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 > ====================================================================