DBSTATTDB2 SAP (DB2/390 Statistics for Tables) Table details
Dictionary Type: Table
Description: DB2/390 Statistics for Tables
Description: DB2/390 Statistics for Tables
Table field list including key, data, relationships and ABAP select examples
DBSTATTDB2 is a standard SAP Table which is used to store DB2/390 Statistics for Tables data and is available within R/3 SAP systems depending on the version and release level.
The DBSTATTDB2 table consists of various fields, each holding specific information or linking keys about DB2/390 Statistics for Tables data available in SAP. These include CREATOR (DB2 creator name), TIMESTAMP (Date and time of last RUNSTATS), VWTYP (Type of Usage of Table Entry), OPTIO (Sample Size for Collection of Statistics).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP DBSTATTDB2 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
NAME | DB2 table name | DB2TABNAME | CHAR | 18 | CHAR18 | ||||
CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | CHAR8 | ||||
TIMESTAMP | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | DB2TMSTMP | ||||
VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | AM_VWTYPE | ||||
OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | CHAR5 | ||||
SIGNI | Significance for Collection of Statistics | AM_SIGNI | INT1 | 3 | AM_SIGNI | ||||
CARDF | Total number of rows in the table | DB2CARDF | FLTP | 16(16) | FLOATING | ||||
NPAGES | Number of pages on which rows of the table appear | DB2NPAGES | INT4 | 10 | |||||
PAGESIZE | DB2 for OS/390 page size in KBytes | DB2PGSIZE | INT2 | 5 | DB2PGSIZE | ||||
PCTROWCOMP | Percentage of rows compressed within total number of rows | DB2PCTCOMP | INT1 | 3 | INT1 |
Key field | Non-key field |
How do I retrieve data from SAP table DBSTATTDB2 using ABAP code
The following ABAP code Example will allow you to do a basic selection on DBSTATTDB2 to SELECT all data from the tableDATA: WA_DBSTATTDB2 TYPE DBSTATTDB2.
SELECT SINGLE *
FROM DBSTATTDB2
INTO CORRESPONDING FIELDS OF WA_DBSTATTDB2
WHERE...
How to access SAP table DBSTATTDB2
Within an ECC or HANA version of SAP you can also view further information about DBSTATTDB2 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects