TMP$ATTACHMENTS

Go Up to System Temporary Tables

The TMP$ATTACHMENTS table contains one row for each connection to a database.

TMP$ATTACHMENTS

Column name	Data type for <=ODS 15	Datatype for >=ODS 16, dialect 1	Datatype for >=ODS 16, dialect 3	Description
TMP$ATTACHMENT_ID	INTEGER			Connection identifier
TMP$DATABASE_ID	INTEGER			Database identifier
TMP$POOL_ID	INTEGER			Reserved
TMP$POOL_MEMORY	INTEGER	DOUBLE PRECISION	NUMERIC (18, 0)	Reserved
TMP$STATEMENTS	SMALLINT			Number of compiled statements
TMP$TRANSACTIONS	SMALLINT			Number of active transactions
TMP$TIMESTAMP	TIMESTAMP			Connection create timestamp
TMP$QUANTUM	INTEGER	DOUBLE PRECISION	NUMERIC (18, 0)	Units of execution
TMP$USER	CHAR[67]			User name
TMP$USER_IP_ADDR	CHAR [31]			User IP address
TMP$USER_HOST	CHAR [31]			User host name
TMP$USER_PROCESS	CHAR [31]			User process ID
TMP$STATE	CHAR [31]			CONNECTED,ACTIVE
TMP$PRIORITY	CHAR [31]			Reserved
TMP$DBKEY_ID	INTEGER	DOUBLE PRECISION	NUMERIC (18, 0)	Transaction ID of dbkey
TMP$ACTIVE_SORTS	SMALLINT			Number of active sorts
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 connection
TMP$RECORD_INSERTS	INTEGER	DOUBLE PRECISION	NUMERIC (18, 0)	Records inserted by connection
TMP$RECORD_UPDATES	INTEGER	DOUBLE PRECISION	NUMERIC (18, 0)	Records updated by connection
TMP$RECORD_DELETES	INTEGER	DOUBLE PRECISION	NUMERIC (18, 0)	Records deleted by connection
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