Some Unsupported Extras

Several of the SMI tables are not documented and not officially supported. These could change in future releases. Two additional unsupported tables I have found helpful are systrans and syssqexplain.

User transactions: systrans

Three of the fields in systrans are very helpful to determine what logical log number a transaction began in, and the current logical log number in use by a transaction.

Key systrans fields:

       Column          Data Type      Description
       tx_id           integer        pointer to transaction table
       tx logbeg       integer        transaction starting logical log
       tx_loguniq      integer        transaction current logical log number

This can be used to create a script to determine what logical logfiles have active transactions. The output of this will tell ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial