Data Element list used by SAP ABAP Table DB2DB02IXDYN (Tx DB02: Dynamics of the size of indexes)
SAP ABAP Table
DB2DB02IXDYN (Tx DB02: Dynamics of the size of indexes) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CHGEXDI | Number of extents: change per day | ||
| 2 | DB2CHGEXMI | Number of extents: change per month | ||
| 3 | DB2CHGEXWI | Number of extents: change per week | ||
| 4 | DB2CHGFRED | Free storage (allocated minus used) in KB: change per day | ||
| 5 | DB2CHGFREM | Free storage (allocated minus used) in KB: change per month | ||
| 6 | DB2CHGFREW | Free storage (allocated minus used) in KB: change per week | ||
| 7 | DB2CHGROWD | Number of Rows: changes per day | ||
| 8 | DB2CHGROWM | Number of Rows: changes per month | ||
| 9 | DB2CHGROWW | Number of Rows: changes per week | ||
| 10 | DB2CHGSIZD | Allocated storage in KB: change per day | ||
| 11 | DB2CHGSIZM | Allocated storage in KB: change per month | ||
| 12 | DB2CHGSIZW | Allocated storage in KB: change per week | ||
| 13 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 14 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 15 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 16 | DB2CHGTBSF | Tx DB02: Absolute difference in comparison to first run | ||
| 17 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 18 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 19 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 20 | DB2CHGTBSL | Tx DB02: Absolute difference in comparison to previous run | ||
| 21 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 22 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 23 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 24 | DB2CHGTBSP | Tx DB02: Difference (percent) in comparison to previous run | ||
| 25 | DB2CREATOR | DB2 creator name | ||
| 26 | DB2DBNAME | Database name | ||
| 27 | DB2IDXNAME | Name of a DB2 for OS/390 index | ||
| 28 | DB2IXFREE | Free size of an index in KB (allocated minus used storage) | ||
| 29 | DB2IXSIZ | Total size of an index (allocated storage in KB) | ||
| 30 | DB2IXSPACE | Name of the indexspace that contains the index | ||
| 31 | DB2NUMEXTI | Number of extents | ||
| 32 | DB2NUMPART | Number of partitions of a tablespace or index | ||
| 33 | DB2PARTEXT | Extension or Partition (non-partitioned TS) number | ||
| 34 | DB2RTSTOTALENTRY | DB2/zOS: Real-Time Statistics index TOTALENTRIES |