SAP ABAP Table DB2DB02IX_SUM (Tx DB02: Summary of Index info. Partitions are summed up)
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 DB2DB02IX_SUM   Table Relationship Diagram
Short Description Tx DB02: Summary of Index info. Partitions are summed up    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
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 IXCREATOR DB2CREATOR CHAR8 CHAR 8   0   DB2 creator name  
2 IXNAME DB2IDXNAME CHAR18 CHAR 18   0   Name of a DB2 for OS/390 index  
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 DBNAME DB2DBNAME D2DBNAME CHAR 8   0   Database name  
6 IXSPACE DB2IXSPACE CHAR8 CHAR 8   0   Name of the indexspace that contains the index  
7 PARTITIONS DB2NUMPART DB2SINT INT2 5   0   Number of partitions of a tablespace or index  
8 MAX_EXTENTS DB2MAXEXTS   INT4 10   0   Maximum number of extents of a partition of the TS or IX  
9 SUM_EXTENTS DB2SUMEXTS   INT4 10   0   Total number of extents of a TS or index (parts summed up)  
10 SUM_DASD_USAGE DB2DASD_USE_SUM FLTP FLTP 16   16   Actual DASD usage (in KB) of TS (sum of partitions)  
11 SUM_ALLOCSIZE DB2IXSIZ DEC11 DEC 11   0   Total size of an index (allocated storage in KB)  
12 SUM_FREESIZE DB2IXFREE DEC11 DEC 11   0   Free size of an index in KB (allocated minus used storage)  
13 PCTUSED DB2IXPCTUS DEC3 DEC 3   0   Percentage of used size to allocated size of an index  
14 RTS_LAST_REORG DB2CCOTIME DB2TMSTMP CHAR 26   0   Timestamp of last REORG  
15 RTS_TOTALENTRIES DB2RTSTOTALENTRY FLTP FLTP 16   16   DB2/zOS: Real-Time Statistics index TOTALENTRIES  
16 RTS_CHANGES DB2CCRCHGA   INT4 10   0   REO.:Changed rows (insert, delete or update) absolute number  
17 RTS_REORG_RECS DB2CCREORGRECS   INT4 10   0   DB2/zOS: Number of REORG recommendations by DSNACCOR  
18 TBCREATOR DB2TBCREA CHAR8 CHAR 8   0   Authorization ID of the owner of the table  
19 TBNAME DB2TBNAME CHAR18 CHAR 18   0   Name of the table on which the index is defined  
20 TSNAME DB2TSNAME CHAR8 CHAR 8   0   Name of the tablespace  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700