SAP ABAP Table DB2DB02TBSIZE (Transaction DB02: List of tables and tablespace (Details))
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Table Category TRANSP    Transparent table 
Transparent table DB2DB02TBSIZE   Table Relationship Diagram
Short Description Transaction DB02: List of tables and tablespace (Details)    
Delivery and Maintenance
Pool/cluster      
Delivery Class S   System table, maint. only by SAP, change = modification 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 TBCREATOR DB2CREATOR CHAR8 CHAR 8   0   DB2 creator name  
2 TBNAME DB2TBNAME CHAR18 CHAR 18   0   Name of the table on which the index is defined  
3 STORDATE DB2STODATE DATUM DATS 8   0   Date when the storage information has been collected  
4 STORTIME DB2STOTIME TIME TIMS 6   0   Time when the storage information has been collected  
5 TSNAME DB2TSNAME CHAR8 CHAR 8   0   Name of the tablespace  
6 DBNAME DB2DBNAME D2DBNAME CHAR 8   0   Database name  
7 PARTITIONS DB2NUMPART DB2SINT INT2 5   0   Number of partitions of a tablespace or index  
8 TBSIZE DB2RTSTBSIZE FLTP FLTP 16   16   Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB  
9 SPACEF DB2TBSPACEF FLTP FLTP 16   16   Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table  
10 STATSTIME DB2STATSTM DB2TMSTMP CHAR 26   0   Date and time of last RUNSTATS  
11 TS_ALLOCSIZE DB2TSSIZ DEC11 DEC 11   0   Total size of a tablespace (allocated storage in KB)  
12 TS_FREESIZE DB2TSFREE DEC11 DEC 11   0   Free size of a tablespace in KB (allocated minus used stor.)  
13 PCTUSED DB2TSPCTU DEC3 DEC 3   0   Percentage of used size to allocated size of a tablespace  
14 RTS_TOTALROWS DB2TBTOTALROWS FLTP FLTP 16   16   Real Time Statistics: Number of rows in Table  
15 AVGROWLENGTH DB2TBAVGROWLEN   INT4 10   0   Average row length of table  
16 RTS_ST_CHANGES DB2CCCHGA FLTP FLTP 16   16   RUN.:Changed rows (insert, delete or update) absolute number  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700