Data Element list used by SAP ABAP Table DB2IXDETLP (Detailed Information on a Partition of a DB2 Index)
SAP ABAP Table
DB2IXDETLP (Detailed Information on a Partition of a DB2 Index) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | DB2CREATOR | DB2 creator name | ||
| 2 | DB2FAROFFP | Number of referred to rows far from optimal position | ||
| 3 | DB2FREEPG | Number of pages loaded before a page is left as free space | ||
| 4 | DB2GBPCACH | Group buffer pool cache option | ||
| 5 | DB2IDXNAME | Name of a DB2 for OS/390 index | ||
| 6 | DB2IXCARDF | Number of keys in the index that refer to data rows or LOBs | ||
| 7 | DB2LEAFDIS | 100 * avg number of leaf pages between successive leaf pages | ||
| 8 | DB2NEAROFF | Number of referred to rows near the optimal position | ||
| 9 | DB2PARTNRS | Partition number | ||
| 10 | DB2PCTFRES | Percentage of each page left as free space | ||
| 11 | DB2SPACE | Number of KB of DASD Storage Allocated to Tablespace | ||
| 12 | DB2STATSTM | Date and time of last RUNSTATS | ||
| 13 | DB2STOGRP | Name of the storage group used for space allocation | ||
| 14 | DB2VCAT | Name of the integrated catalog facility catalog |