DB2DB02IXDYN - Tx DB02: Dynamics of the size of indexes
Tx DB02: Dynamics of the size of indexes information is stored in SAP table DB2DB02IXDYN.
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".
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 DB2DB02IXDYN
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| IXCREATOR | DB2 creator name | X | DB2CREATOR | CHAR | 8 | |
| IXNAME | Name of a DB2 for OS/390 index | X | DB2IDXNAME | CHAR | 18 | |
| PART_EXTENSION | Extension or Partition (non-partitioned TS) number | X | DB2PARTEXT | INT4 | 4 | |
| DBNAME | Database name | DB2DBNAME | CHAR | 8 | ||
| IXSPACE | Name of the indexspace that contains the index | DB2IXSPACE | CHAR | 8 | ||
| PARTITIONS | Number of partitions of a tablespace or index | DB2NUMPART | INT2 | 2 | ||
| EXTENTS | Number of extents | DB2NUMEXTI | INT4 | 4 | ||
| EXTENTS_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| EXTENTS_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| EXTENTS_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_EXTENTS | Number of extents: change per day | DB2CHGEXDI | INT4 | 4 | ||
| W_EXTENTS | Number of extents: change per week | DB2CHGEXWI | INT4 | 4 | ||
| M_EXTENTS | Number of extents: change per month | DB2CHGEXMI | INT4 | 4 | ||
| ALLOCSIZE | Total size of an index (allocated storage in KB) | DB2IXSIZ | DEC | 6 | ||
| ALLOCSIZ_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| ALLOCSIZ_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| ALLOCSIZ_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_ALLOCSIZ | Allocated storage in KB: change per day | DB2CHGSIZD | DEC | 6 | ||
| W_ALLOCSIZ | Allocated storage in KB: change per week | DB2CHGSIZW | DEC | 6 | ||
| M_ALLOCSIZ | Allocated storage in KB: change per month | DB2CHGSIZM | DEC | 6 | ||
| FREESIZE | Free size of an index in KB (allocated minus used storage) | DB2IXFREE | DEC | 6 | ||
| FREESIZE_LAST | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| FREESIZE_PERC | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| FREESIZE_FIRST | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_FREESIZ | Free storage (allocated minus used) in KB: change per day | DB2CHGFRED | DEC | 6 | ||
| W_FREESIZ | Free storage (allocated minus used) in KB: change per week | DB2CHGFREW | DEC | 6 | ||
| M_FREESIZ | Free storage (allocated minus used) in KB: change per month | DB2CHGFREM | DEC | 6 | ||
| RTS_TOTALENTRIES | DB2/zOS: Real-Time Statistics index TOTALENTRIES | DB2RTSTOTALENTRY | FLTP | 8 | ||
| TOTALENTRIES_LAS | Tx DB02: Absolute difference in comparison to previous run | DB2CHGTBSL | FLTP | 8 | ||
| TOTALENTRIES_PER | Tx DB02: Difference (percent) in comparison to previous run | DB2CHGTBSP | INT4 | 4 | ||
| TOTALENTRIES_FIR | Tx DB02: Absolute difference in comparison to first run | DB2CHGTBSF | FLTP | 8 | ||
| D_TOTALENTRIES | Number of Rows: changes per day | DB2CHGROWD | FLTP | 8 | ||
| W_TOTALENTRIES | Number of Rows: changes per week | DB2CHGROWW | FLTP | 8 | ||
| M_TOTALENTRIES | Number of Rows: changes per month | DB2CHGROWM | FLTP | 8 |