June 03 2014

Tracing Locks in Table level on informix

Tagged Under :

Tracing Locks in Table level on informix

# Find out the hex partnum number of the table

dbaccess sysmaster –
select hex(partnum),owner from systabnames where tabname=”table_name”;

example
=======

> select hex(partnum),owner,dbsname from systables where tabname=”country”;

(expression) owner dbsname

0x004004E5 grefdev gref420_cit3

1 row(s) retrieved.