Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Helmut Leininger — — source: Informix-list mailing list archive (1991-1998)
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.