Data Element list used by SAP ABAP Table DB2IXSIZED (DB2/390: Storage Information on Datasets of Indexes)
SAP ABAP Table
DB2IXSIZED (DB2/390: Storage Information on Datasets of Indexes) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CREATOR | DB2 creator name | ||
| 2 | DB2DBNAME | Database name | ||
| 3 | DB2DSNAME | Dataset name | ||
| 4 | DB2IDXNAME | Name of a DB2 for OS/390 index | ||
| 5 | DB2IXFREE | Free size of an index in KB (allocated minus used storage) | ||
| 6 | DB2IXPCTUS | Percentage of used size to allocated size of an index | ||
| 7 | DB2IXSIZ | Total size of an index (allocated storage in KB) | ||
| 8 | DB2IXSPACE | Name of the indexspace that contains the index | ||
| 9 | DB2NUMEXTS | Total number of extents of a tablespace or index | ||
| 10 | DB2PQTY | Primary space allocation | ||
| 11 | DB2QTYUNIT | Unit in which primary and secondary allocation are given | ||
| 12 | DB2SQTY | Secondary space allocation | ||
| 13 | DB2STODATE | Date when the storage information has been collected | ||
| 14 | DB2STOTIME | Time when the storage information has been collected |