DBSTATIDB2 - DB2/390 Statistics for Indexes
DB2/390 Statistics for Indexes information is stored in SAP table DBSTATIDB2.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DBSTATIDB2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| NAME | Name of a DB2 for OS/390 index | X | DB2IDXNAME | CHAR | 18 | |
| CREATOR | DB2 creator name | X | DB2CREATOR | CHAR | 8 | |
| TIMESTAMP | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | ||
| TBNAME | DB2 table name | DB2TABNAME | CHAR | 18 | ||
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | ||
| CLURATIO | DB2 for OS/390 cluster ratio | DB2CLURAT | INT1 | 1 | ||
| FIRSTKCARD | Number of distinct values in key (first column or full key) | DB2KEYCARD | FLTP | 8 | ||
| FULLKCARD | Number of distinct values in key (first column or full key) | DB2KEYCARD | FLTP | 8 | ||
| NLEAF | Number of active leaf pages in the index | DB2NLEAF | INT4 | 4 | ||
| NLEVELS | DB2 for OS/390 number of levels in the index tree | DB2NLEVELS | INT2 | 2 | ||
| NEAROFFPOS | Number of referred to rows near/far from optimal position | DB2OFFPOSF | FLTP | 8 | ||
| FAROFFPOS | Number of referred to rows near/far from optimal position | DB2OFFPOSF | FLTP | 8 | ||
| LEAFDIST | 100 * avg number of leaf pages between successive leaf pages | DB2LEAFDIS | INT4 | 4 | ||
| DSSIZE | DB2 for OS/390 size of a dataset in KBytes | DB2SIZEK | DEC | 8 |