DBSTATHINF - INFORMIX update statistical information
INFORMIX update statistical information information is stored in SAP table DBSTATHINF.
It is part of development package STUN_INF in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "Informix: STUN".
It is part of development package STUN_INF in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "Informix: STUN".
Fields for table DBSTATHINF
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TABID | Table ID | X | INF_TABID | INT4 | 4 | |
| TABNAME | Informix table name (according to systables) | X | INF_TABNAM | CHAR | 18 | |
| LUPDSTAT | Analysis date (yyyymmddhhmm) | X | AM_DATE | CHAR | 12 | |
| CUPDSTAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR | 12 | ||
| LASTROWS | Number of rows at last statistics update | INF_LROWS | INT4 | 4 | ||
| CHECKROWS | Number of rows at last check | INF_CROWS | INT4 | 4 | ||
| THRESHOLD | Threshold for update statistics | INF_THRESH | INT2 | 2 | ||
| SIGNI | Significance for Collection of Statistics | AM_SIGNI | INT1 | 1 | ||
| VALUE | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 4 | ||
| DURATION | Duration of update statistics | INF_DURAT | INT4 | 4 | ||
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | ||
| TABNPUSED | Number of data pages used | INF_DPAGES | INT4 | 4 | ||
| IDXNPUSED | Number of index pages used | INF_IPAGES | INT4 | 4 | ||
| TABFILL | Table fill level | INF_TFILL | INT2 | 2 |