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).
>
Try:
database sysmaster;
Select dbsname,tabname from sysptprof
where hex(partnum) = "0x0090000B"
^^^^^^^^
The tblsnum that you want
Hope This helps
Tino
> ====================================================================
> 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
> ====================================================================