SAP ABAP Table DBSTATIDB2 (DB2/390 Statistics for Indexes)
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
Basic Data
Table Category TRANSP    Transparent table 
Transparent table DBSTATIDB2   Table Relationship Diagram
Short Description DB2/390 Statistics for Indexes    
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 DB2IDXNAME CHAR18 CHAR 18   0   Name of a DB2 for OS/390 index  
2 CREATOR DB2CREATOR CHAR8 CHAR 8   0   DB2 creator name  
3 TIMESTAMP DB2STATSTM DB2TMSTMP CHAR 26   0   Date and time of last RUNSTATS  
4 TBNAME DB2TABNAME CHAR18 CHAR 18   0   DB2 table name  
5 VWTYP AM_VWTYP AM_VWTYPE CHAR 2   0   Type of Usage of Table Entry  
6 CLURATIO DB2CLURAT INT1 INT1 3   0   DB2 for OS/390 cluster ratio  
7 FIRSTKCARD DB2KEYCARD FLOATING FLTP 16   16   Number of distinct values in key (first column or full key)  
8 FULLKCARD DB2KEYCARD FLOATING FLTP 16   16   Number of distinct values in key (first column or full key)  
9 NLEAF DB2NLEAF   INT4 10   0   Number of active leaf pages in the index  
10 NLEVELS DB2NLEVELS DB2SINT INT2 5   0   DB2 for OS/390 number of levels in the index tree  
11 NEAROFFPOS DB2OFFPOSF FLOATING FLTP 16   16   Number of referred to rows near/far from optimal position  
12 FAROFFPOS DB2OFFPOSF FLOATING FLTP 16   16   Number of referred to rows near/far from optimal position  
13 LEAFDIST DB2LEAFDIS   INT4 10   0   100 * avg number of leaf pages between successive leaf pages  
14 DSSIZE DB2SIZEK DB2SIZEK DEC 15   0   DB2 for OS/390 size of a dataset in KBytes  
History
Last changed by/on SAP  20130604 
SAP Release Created in