SAP Table DBSTATDB2N
Copy of DBSTATTDB2 with all components DB2 SMALLINT-conform
DBSTATDB2N (Copy of DBSTATTDB2 with all components DB2 SMALLINT-conform) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DBSTATDB2N to other SAP tables.
DBSTATDB2N table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NAME | DB2 table name | DB2TABNAME | CHAR | 18 | 0 | |||||||
| CREATOR | DB2 creator name | DB2CREATOR | CHAR | 8 | 0 | |||||||
| TIMESTAMP | Date and time of last RUNSTATS | DB2STATSTM | CHAR | 26 | 0 | |||||||
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | 0 |
Possible values
|
||||||
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | 0 | |||||||
| SIGNI | Copy of AM_SIGNI as INT2 to be DB2 SMALLINT-conform | AM_SIGNI2 | INT2 | 5 | 0 | |||||||
| CARDF | Total number of rows in the table | DB2CARDF | FLTP | 16 | 16 | |||||||
| NPAGES | Number of pages on which rows of the table appear | DB2NPAGES | INT4 | 10 | 0 | |||||||
| PAGESIZE | DB2 for OS/390 page size in KBytes | DB2PGSIZE | INT2 | 5 | 0 |
Possible values
|
||||||
| PCTROWCOMP | Copy of DB2PCTCOMP as INT2 to be DB2 SMALLINT-conform | DB2PCTCOM2 | INT2 | 5 | 0 | |||||||
