SAP ABAP Table DB2TABSTAT (DB2/390: Screen for Statistical Space Info on a Table (DB15))
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 | INTTAB | Structure |
| Structure | DB2TABSTAT |
Table Relationship Diagram 
|
| Short Description | DB2/390: Screen for Statistical Space Info on a Table (DB15) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  TNAME |
TABNAME | AS4TAB | CHAR | 30 | 0 | Table Name | * | |
| 2 | ANDAT |
DB2AMDATE | CHAR12 | CHAR | 12 | 0 | Analysis date (YYYYMMDDhhmm) | ||
| 3 | NROWS |
DB2TROWS | DEC15 | DEC | 15 | 0 | Number of records in a table | ||
| 4 | OCCTB |
DB2OBLKB | DEC11 | DEC | 11 | 0 | Used storage space of a table (in KB) | ||
| 5 | OCCIX |
DB2OCIKB | DEC15 | DEC | 15 | 0 | Used storage space for the indexes of a table (in KB) | ||
| 6 | SIGNI |
DB2AMSIGNI | AM_SIGNI | INT1 | 3 | 0 | Accuracy of the analysis significance value | ||
| 7 | AMETH |
DB2AMAMETH | AM_AMETH | CHAR | 4 | 0 | Analysis method for determining DB storage requirements | ||
| 8 | OPTIO |
DB2AMOPTIO | CHAR5 | CHAR | 5 | 0 | Specification for analysis method |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in |
