| NAME |
✔ |
Name of a DB2 for OS/390 index |
DB2IDXNAME |
CHAR |
18 |
|
| CREATOR |
✔ |
DB2 creator name |
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 |
3 |
|
| FIRSTKCARD |
|
Number of distinct values in key (first column or full key) |
DB2KEYCARD |
FLTP |
16 |
|
| FULLKCARD |
|
Number of distinct values in key (first column or full key) |
DB2KEYCARD |
FLTP |
16 |
|
| NLEAF |
|
Number of active leaf pages in the index |
DB2NLEAF |
INT4 |
10 |
|
| NLEVELS |
|
DB2 for OS/390 number of levels in the index tree |
DB2NLEVELS |
INT2 |
5 |
|
| NEAROFFPOS |
|
Number of referred to rows near/far from optimal position |
DB2OFFPOSF |
FLTP |
16 |
|
| FAROFFPOS |
|
Number of referred to rows near/far from optimal position |
DB2OFFPOSF |
FLTP |
16 |
|
| LEAFDIST |
|
100 * avg number of leaf pages between successive leaf pages |
DB2LEAFDIS |
INT4 |
10 |
|
| DSSIZE |
|
DB2 for OS/390 size of a dataset in KBytes |
DB2SIZEK |
DEC |
15 |
|