Transaction table

The transaction table tracks all transactions in the database server.

Tracking information derived from the transaction table is shown in the onstat -x display. For an example of the output that onstat -x displays, see monitoring transactions in your IBM® Informix® Performance Guide.

The database server automatically increases the number of entries in the transaction table, up to a maximum of 32,767, based on the number of current transactions.

For more information about transactions and the SQL statements that you use with transactions, see the IBM Informix Guide to SQL: Tutorial, the IBM Informix Guide to SQL: Reference, and the IBM Informix Guide to SQL: Syntax.

UNIX only: The transaction table also specifically supports the X/Open environment. Support for the X/Open environment requires TP/XA.