TMP$TRANSACTIONS

Go Up to System Temporary Tables

The TMP$TRANSACTIONS table contains one row for each transaction that is active or in limbo.

TMP$TRANSACTIONS

Column name	Datatype for <=ODS 15	Datatype for >=ODS 16, dialect 1	Datatype for >=ODS 16, dialect 3	Description
TMP$TRANSACTION_ID	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Transaction number
TMP$ATTACHMENT_ID	INTEGER			Connection identifier
TMP$POOL_ID	INTEGER
TMP$POOL_MEMORY	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)
TMP$TIMESTAMP	TIMESTAMP			Start time of connection
TMP$SNAPSHOT	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Snapshot transaction number
TMP$QUANTUM	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Units of execution
TMP$SAVEPOINTS	INTEGER			savepoint number of records
TMP$READONLY	CHAR[1]			Transaction is read only
TMP$WRITE	CHAR[1]			Transaction has written data
TMP$NOWAIT	CHAR[1]			Transaction is no wait
TMP$COMMIT_RETAINING	CHAR[1]			Commit retaining performed
TMP$STATE	CHAR[31]			ACTIVE,LIMBO,COMMITTING,PRECOMMITTED
TMP$PRIORITY	CHAR			Reserved
TMP$TYPE	CHAR[31]			SNAPSHOT,READ_COMMITTED
TMP$PAGE_READS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Page reads all database files
TMP$PAGE_WRITES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Page writes all database files
TMP$PAGE_FETCHES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Page fetches all database files
TMP$PAGE_MARKS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Page marks all database files
TMP$RECORD_SELECTS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records selected by transaction
TMP$RECORD_INSERTS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records inserted by transaction
TMP$RECORD_UPDATES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records updated by transaction
TMP$RECORD_DELETES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Records deleted by transaction
TMP$RECORD_PURGES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Garbage collect record purges
TMP$RECORD_EXPUNGES	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Garbage collect record expunges
TMP$RECORD_BACKOUTS	INTEGER	DOUBLE PRECISION	NUMERIC (18,0)	Garbage collect record backouts