DBSTATHDB2 - DB2/390 Statistics for Tables (History)
DB2/390 Statistics for Tables (History) information is stored in SAP table DBSTATHDB2.
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 DBSTATHDB2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| NAME | DB2 table name | X | DB2TABNAME | CHAR | 18 | |
| CREATOR | DB2 creator name | X | DB2CREATOR | CHAR | 8 | |
| TIMESTAMP | Date and time of last RUNSTATS | X | DB2STATSTM | CHAR | 26 | |
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | ||
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | ||
| SIGNI | Significance for Collection of Statistics | AM_SIGNI | INT1 | 1 | ||
| CARDF | Total number of rows in the table | DB2CARDF | FLTP | 8 | ||
| NPAGES | Number of pages on which rows of the table appear | DB2NPAGES | INT4 | 4 | ||
| PAGESIZE | DB2 for OS/390 page size in KBytes | DB2PGSIZE | INT2 | 2 | ||
| PCTROWCOMP | Percentage of rows compressed within total number of rows | DB2PCTCOMP | INT1 | 1 |