SAP ABAP Table DBSTAIDB2N (Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform)

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	INTTAB	Structure
Structure	DBSTAIDB2N	Table Relationship Diagram
Short Description	Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform

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	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	☐	DB2CLURAT2	DB2SINT	INT2	5	0	Clusterratio: Percentage of rows in clustering order
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	710