SAP ABAP Table DB2DB02IXSIZE (Tx DB02: List of indexspace datasets)
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 DB2DB02IXSIZE   Table Relationship Diagram
Short Description Tx DB02: List of indexspace datasets    
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 PART_EXTENSION DB2PARTEXT   INT4 10   0   Extension or Partition (non-partitioned TS) number  
4 STORDATE DB2STODATE DATUM DATS 8   0   Date when the storage information has been collected  
5 STORTIME DB2STOTIME TIME TIMS 6   0   Time when the storage information has been collected  
6 DBNAME DB2DBNAME D2DBNAME CHAR 8   0   Database name  
7 IXSPACE DB2IXSPACE CHAR8 CHAR 8   0   Name of the indexspace that contains the index  
8 PARTITIONS DB2NUMPART DB2SINT INT2 5   0   Number of partitions of a tablespace or index  
9 DSNAME DB2DSNAME DB2CHAR44 CHAR 44   0   Dataset name  
10 EXTENTS DB2NUMEXTI   INT4 10   0   Number of extents  
11 DASD_USAGE DB2DASD_USAGE   INT4 10   0   Actual DASD usage (in KB) of dataset  
12 ALLOCSIZE DB2IXSIZP DEC11 DEC 11   0   Allocated storage of a partition of an index in KB  
13 FREESIZE DB2IXFREEP DEC11 DEC 11   0   Free size of an index partition in KB  
14 PCTUSED DB2IXPCTUP DEC3 DEC 3   0   Percentage of used to alloc. size of a partition of an IX  
15 PQTY DB2PQTY   INT4 10   0   Primary space allocation  
16 SQTY DB2SQTY   INT4 10   0   Secondary space allocation  
17 QTYUNIT DB2QTYUNIT DB2QTYUNIT CHAR 8   0   Unit in which primary and secondary allocation are given  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700