TMP$POOL BLOCKS

Go Up to System Temporary Tables

The TMP$POOL_BLOCKS table contains one row for each block of memory in each pool.

TMP$POOL_BLOCKS

Column name	Datatype for >=ODS 16, dialect 1	Datatype for >=ODS 16, dialect 1	Datatype for >=ODS 16, dialect 3	Description
TMP$POOL_ID	INTEGER
TMP$ACC	INTEGER
TMP$ARR	INTEGER
TMP$ATT	INTEGER
TMP$BCB	INTEGER			Buffer control block
TMP$BDB	INTEGER			Buffer descriptor block
TMP$BLB	INTEGER			Blob block
TMP$BLF	INTEGER
TMP$BMS	INTEGER
TMP$BTB	INTEGER
TMP$BTC	INTEGER
TMP$CHARSET	INTEGER
TMP$CSB	INTEGER			Compiler scratch block
TMP$CSCONVERT	INTEGER
TMP$DBB	INTEGER			Database block
TMP$DCC	INTEGER			Data compression control block
TMP$DFW	INTEGER			Deferred work block
TMP$DLS	INTEGER
TMP$EXT	INTEGER
TMP$FIL	INTEGER			File block
TMP$FLD	INTEGER
TMP$FMT	INTEGER			Format block
TMP$FRB	INTEGER			Free block
TMP$FUN	INTEGER
TMP$HNK	INTEGER			Hunk block
TMP$IDB	INTEGER
TMP$IDL	INTEGER
TMP$IRB	INTEGER
TMP$IRL	INTEGER
TMP$LCK	INTEGER			Lock block
TMP$LWT	INTEGER
TMP$MAP	INTEGER
TMP$MFB	INTEGER
TMP$NOD	INTEGER			Node block
TMP$OPT	INTEGER
TMP$PRC	INTEGER
TMP$PRE	INTEGER			Precedence block
TMP$PRM	INTEGER
TMP$REC	INTEGER			Record block
TMP$REL	INTEGER			Relation block
TMP$REQ	INTEGER			Request block
TMP$RIV	INTEGER
TMP$RSB	INTEGER			Record source block
TMP$RSC	INTEGER
TMP$SAV	INTEGER
TMP$SBM	INTEGER			Sparse bitmap block
TMP$SCL	INTEGER
TMP$SDW	INTEGER
TMP$SMB	INTEGER			Sort map block
TMP$SRPB	INTEGER
TMP$STR	INTEGER			String block
TMP$SVC	INTEGER
TMP$SYM	INTEGER
TMP$TEXTTYPE	INTEGER
TMP$TFB	INTEGER			Temporary field block
TMP$TPC	INTEGER
TMP$TRA	INTEGER			Transaction block
TMP$USR	INTEGER
TMP$VCL	INTEGER			Vector long block
TMP$VCT	INTEGER
TMP$VCX	INTEGER
TMP$XCP	INTEGER