SAP Table DBSTATTDB2

DB2/390 Statistics for Tables

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

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