Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Administrator's GuideThe Informix® Administrator's Guide provides the information required to administer HCL Informix®.
Disk, memory, and process management
Shared memoryThese topics describe the content of database server shared memory, the factors that determine the sizes of shared-memory areas, and how data moves into and out of shared memory.
Virtual portion of shared memoryThe virtual portion of shared memory is expandable by the database server and can be paged out to disk by the operating system.
Components of the virtual portion of shared memoryThe virtual portion of shared memory stores a variety of data.
Shared-memory internal tablesThe database server shared memory contains seven internal tables that track shared-memory resources.
Transaction tableThe transaction table tracks all transactions in the database server.

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 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 Informix Guide to SQL: Tutorial, the Informix Guide to SQL: Reference, and the 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.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.