Data Element list used by SAP ABAP Table DBSTATIDB2 (DB2/390 Statistics for Indexes)
SAP ABAP Table
DBSTATIDB2 (DB2/390 Statistics for Indexes) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | AM_VWTYP | Type of Usage of Table Entry | ||
| 2 | DB2CLURAT | DB2 for OS/390 cluster ratio | ||
| 3 | DB2CREATOR | DB2 creator name | ||
| 4 | DB2IDXNAME | Name of a DB2 for OS/390 index | ||
| 5 | DB2KEYCARD | Number of distinct values in key (first column or full key) | ||
| 6 | DB2KEYCARD | Number of distinct values in key (first column or full key) | ||
| 7 | DB2LEAFDIS | 100 * avg number of leaf pages between successive leaf pages | ||
| 8 | DB2NLEAF | Number of active leaf pages in the index | ||
| 9 | DB2NLEVELS | DB2 for OS/390 number of levels in the index tree | ||
| 10 | DB2OFFPOSF | Number of referred to rows near/far from optimal position | ||
| 11 | DB2OFFPOSF | Number of referred to rows near/far from optimal position | ||
| 12 | DB2SIZEK | DB2 for OS/390 size of a dataset in KBytes | ||
| 13 | DB2STATSTM | Date and time of last RUNSTATS | ||
| 14 | DB2TABNAME | DB2 table name |