DB2DB02TBSIZE - Transaction DB02: List of tables and tablespace (Details)

Transaction DB02: List of tables and tablespace (Details) information is stored in SAP table DB2DB02TBSIZE.
 It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".

Fields for table DB2DB02TBSIZE

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
TBCREATORDB2 creator nameXDB2CREATORCHAR8
TBNAMEName of the table on which the index is definedXDB2TBNAMECHAR18
STORDATEDate when the storage information has been collectedXDB2STODATEDATS8
STORTIMETime when the storage information has been collectedXDB2STOTIMETIMS6
TSNAMEName of the tablespaceDB2TSNAMECHAR8
DBNAMEDatabase nameDB2DBNAMECHAR8
PARTITIONSNumber of partitions of a tablespace or indexDB2NUMPARTINT22
TBSIZEReal Time Statistics: Table size = TOTALENTRIES*AvgRowLen KBDB2RTSTBSIZEFLTP8
SPACEFColumn SYSIBM.SYSTABLES(SPACEF): DASD space used for tableDB2TBSPACEFFLTP8
STATSTIMEDate and time of last RUNSTATSDB2STATSTMCHAR26
TS_ALLOCSIZETotal size of a tablespace (allocated storage in KB)DB2TSSIZDEC6
TS_FREESIZEFree size of a tablespace in KB (allocated minus used stor.)DB2TSFREEDEC6
PCTUSEDPercentage of used size to allocated size of a tablespaceDB2TSPCTUDEC2
RTS_TOTALROWSReal Time Statistics: Number of rows in TableDB2TBTOTALROWSFLTP8
AVGROWLENGTHAverage row length of tableDB2TBAVGROWLENINT44
RTS_ST_CHANGESRUN.:Changed rows (insert, delete or update) absolute numberDB2CCCHGAFLTP8
Privacy Policy