dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table DBSTATTDB2

DB2/390 Statistics for Tables

The table DBSTATTDB2 (DB2/390 Statistics for Tables) is a standard table in SAP ERP. It belongs to the package STU2.

Technical Information

Table DBSTATTDB2
Short Text DB2/390 Statistics for Tables
Package STU2
Table Type Transparent Table

Fields for Table DBSTATTDB2

Field Name Key Description Data Element Type Length Check Table
NAME ✔ DB2 table name DB2TABNAME CHAR 18
CREATOR ✔ DB2 creator name DB2CREATOR CHAR 8
TIMESTAMP Date and time of last RUNSTATS 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 3
CARDF Total number of rows in the table DB2CARDF FLTP 16
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
PCTROWCOMP Percentage of rows compressed within total number of rows DB2PCTCOMP INT1 3