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