Data Element list used by SAP ABAP Table DB2IXDYN (Dynamics of the Size of Indexes)
SAP ABAP Table
DB2IXDYN (Dynamics of the Size of Indexes) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CHGEXTD | Number of extents: change per day | ||
| 2 | DB2CHGEXTM | Number of extents: change per month | ||
| 3 | DB2CHGEXTW | 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 | DB2CHGSIZD | Allocated storage in KB: change per day | ||
| 8 | DB2CHGSIZM | Allocated storage in KB: change per month | ||
| 9 | DB2CHGSIZW | Allocated storage in KB: change per week | ||
| 10 | DB2CREATOR | DB2 creator name | ||
| 11 | DB2DBNAME | Database name | ||
| 12 | DB2IDXNAME | Name of a DB2 for OS/390 index | ||
| 13 | DB2IXSPACE | Name of the indexspace that contains the index | ||
| 14 | DB2NUMEXTS | Total number of extents of a tablespace or index | ||
| 15 | DB2NUMPART | Number of partitions of a tablespace or index | ||
| 16 | DB2PARTNRS | Partition number | ||
| 17 | DB2TSFREE | Free size of a tablespace in KB (allocated minus used stor.) | ||
| 18 | DB2TSSIZ | Total size of a tablespace (allocated storage in KB) |