Data Element list used by SAP ABAP Table DB2IXDETL (Detailed Information on a DB2 Index)
SAP ABAP Table 
DB2IXDETL (Detailed Information on a DB2 Index) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2ALTEDTS | Time of most recent ALTER statement on the object | |
| 2 | Data Element |
DB2BUFPOOL | DB2/390: Buffer pool | |
| 3 | Data Element |
DB2CLURAT2 | Clusterratio: Percentage of rows in clustering order | |
| 4 | Data Element |
DB2CLUSTER | Whether CLUSTER was specified when the index was created | |
| 5 | Data Element |
DB2CLUSTRD | Whether the table is actually clustered by the index | |
| 6 | Data Element |
DB2CREADTS | Time when the CREATE statement was executed | |
| 7 | Data Element |
DB2CREATOR | DB2 creator name | |
| 8 | Data Element |
DB2DBNAME | Database name | |
| 9 | Data Element |
DB2FRSTKEY | Number of distinct values in the first key column | |
| 10 | Data Element |
DB2FULLKEY | Number of distinct values of the key | |
| 11 | Data Element |
DB2IDXNAME | Name of a DB2 for OS/390 index | |
| 12 | Data Element |
DB2IXSPACE | Name of the indexspace that contains the index | |
| 13 | Data Element |
DB2IXTYPE | Index type | |
| 14 | Data Element |
DB2KCOLCNT | Number of columns in the key | |
| 15 | Data Element |
DB2NLEAF | Number of active leaf pages in the index | |
| 16 | Data Element |
DB2NLEVELS | DB2 for OS/390 number of levels in the index tree | |
| 17 | Data Element |
DB2NUMPART | Number of partitions of a tablespace or index | |
| 18 | Data Element |
DB2PGSIZE | DB2 for OS/390 page size in KBytes | |
| 19 | Data Element |
DB2STATSTM | Date and time of last RUNSTATS | |
| 20 | Data Element |
DB2TBCREA | Authorization ID of the owner of the table | |
| 21 | Data Element |
DB2TBNAME | Name of the table on which the index is defined | |
| 22 | Data Element |
DB2UNIQUE | Whether the index is unique |
