SAP ABAP Table DBSTATHINF (INFORMIX update statistical information)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN_INF (Package) Informix: STUN

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DBSTATHINF	Table Relationship Diagram
Short Description	INFORMIX update statistical information

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	TABID	☑	INF_TABID	INT4	INT4	10	0	Table ID
2	TABNAME	☑	INF_TABNAM	INF_TABNAM	CHAR	18	0	Informix table name (according to systables)
3	LUPDSTAT	☑	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
4	CUPDSTAT	☐	AM_DATE	CHAR12	CHAR	12	0	Analysis date (yyyymmddhhmm)
5	LASTROWS	☐	INF_LROWS	INT4	INT4	10	0	Number of rows at last statistics update
6	CHECKROWS	☐	INF_CROWS	INT4	INT4	10	0	Number of rows at last check
7	THRESHOLD	☐	INF_THRESH	INT2	INT2	5	0	Threshold for update statistics
8	SIGNI	☐	AM_SIGNI	AM_SIGNI	INT1	3	0	Significance for Collection of Statistics
9	VALUE	☐	AM_AMETH	AM_AMETH	CHAR	4	0	Analysis Method for Collecting Statistics
10	DURATION	☐	INF_DURAT	INT4	INT4	10	0	Duration of update statistics
11	VWTYP	☐	AM_VWTYP	AM_VWTYPE	CHAR	2	0	Type of Usage of Table Entry
12	TABNPUSED	☐	INF_DPAGES	INT4	INT4	10	0	Number of data pages used
13	IDXNPUSED	☐	INF_IPAGES	INT4	INT4	10	0	Number of index pages used
14	TABFILL	☐	INF_TFILL	INT2	INT2	5	0	Table fill level

History

Last changed by/on	SAP	20130604
SAP Release Created in