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