SAP ABAP Table DBSTATTDB2 (DB2/390 Statistics for Tables)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | DBSTATTDB2 |
Table Relationship Diagram 
|
| Short Description | DB2/390 Statistics for Tables |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  NAME |
DB2TABNAME | CHAR18 | CHAR | 18 | 0 | DB2 table name | ||
| 2 | CREATOR |
DB2CREATOR | CHAR8 | CHAR | 8 | 0 | DB2 creator name | ||
| 3 | TIMESTAMP |
DB2STATSTM | DB2TMSTMP | CHAR | 26 | 0 | Date and time of last RUNSTATS | ||
| 4 | VWTYP |
AM_VWTYP | AM_VWTYPE | CHAR | 2 | 0 | Type of Usage of Table Entry | ||
| 5 | OPTIO |
AM_OPTIO | CHAR5 | CHAR | 5 | 0 | Sample Size for Collection of Statistics | ||
| 6 | SIGNI |
AM_SIGNI | AM_SIGNI | INT1 | 3 | 0 | Significance for Collection of Statistics | ||
| 7 | CARDF |
DB2CARDF | FLOATING | FLTP | 16 | 16 | Total number of rows in the table | ||
| 8 | NPAGES |
DB2NPAGES | INT4 | 10 | 0 | Number of pages on which rows of the table appear | |||
| 9 | PAGESIZE |
DB2PGSIZE | DB2PGSIZE | INT2 | 5 | 0 | DB2 for OS/390 page size in KBytes | ||
| 10 | PCTROWCOMP |
DB2PCTCOMP | INT1 | INT1 | 3 | 0 | Percentage of rows compressed within total number of rows |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
