SAP Table DB2TBIXSUM
DB2/390: Initial Screen for Table and Index Monitor (DB02)
DB2TBIXSUM (DB2/390: Initial Screen for Table and Index Monitor (DB02)) 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 DB2TBIXSUM to other SAP tables.
Source: DB2TBIXSUM (DB2/390: Initial Screen for Table and Index Monitor (DB02))
DB2TBIXSUM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| DBSYS | Central Database System | SYDBSYS | CHAR | 10 | 0 | |||
| SYSID | Name of SAP System | SYSYSID | CHAR | 8 | 0 | |||
| REFRDATE | Date of last refresh of transaction DB02 | DB2DB02DAT | DATS | 8 | 0 | |||
| REFRTIME | Time of the last refresh of transaction DB02 | DB2DB02TIM | TIMS | 6 | 0 | |||
| TSNUM | Number of tablespaces in the R/3 system | DB2TSNUM | DEC | 8 | 0 | |||
| TSSIZE | Total size of all R/3 tablespaces (allocated storage in kB) | DB2TSSIZT | DEC | 13 | 0 | |||
| TSFREE | Total free size of all R/3 tablespaces in KB | DB2TSFREET | DEC | 13 | 0 | |||
| TSPCTUSED | Percentage of used size to allocated size of all tablespaces | DB2TSPCTUT | DEC | 3 | 0 | |||
| IXNUM | Number of indexes in the R/3 system | DB2IXNUM | DEC | 8 | 0 | |||
| IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | DB2IXSIZT | DEC | 13 | 0 | |||
| IXFREE | Total free size of all R/3 indexes in KB | DB2IXFREET | DEC | 13 | 0 | |||
| IXPCTUSED | Percentage of used size to allocated size of all indexes | DB2IXPCTUT | DEC | 3 | 0 | |||
| TBNUM | Number of tables in the R/3 system | DB2TBNUM | DEC | 8 | 0 | |||
| TBSIZE | Total size of all R/3 tables (used storage in KB) | DB2TBSIZT | DEC | 13 | 0 | |||
| TBMISSDB | Number of tables missing in the database | DB2TBMISDB | DEC | 8 | 0 | |||
| IXMISSDB | Number of indexes missing in the database | DB2IXMISDB | DEC | 8 | 0 | |||
| TBMISSDDIC | Number of tables missing in the ABAP/4 dictionary | DB2TBMISDD | DEC | 8 | 0 | |||
| IXMISSDDIC | Number of indexes missing in the ABAP dictionary | DB2IXMISDD | DEC | 8 | 0 | |||
| MONI_VER | Version marker for DB02's data stored in table MONI | DB2MONIVER | CHAR | 1 | 0 | |||
