SAP ABAP Table DB2TBIXSUM (DB2/390: Initial Screen for Table and Index Monitor (DB02))
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
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 | DB2TBIXSUM |
Table Relationship Diagram 
|
| Short Description | DB2/390: Initial Screen for Table and Index Monitor (DB02) |
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 |  DBSYS |
SYDBSYS | SYCHAR10 | CHAR | 10 | 0 | Central Database System | ||
| 2 | SYSID |
SYSYSID | SYCHAR08 | CHAR | 8 | 0 | Name of SAP System | ||
| 3 | REFRDATE |
DB2DB02DAT | DATUM | DATS | 8 | 0 | Date of last refresh of transaction DB02 | ||
| 4 | REFRTIME |
DB2DB02TIM | TIME | TIMS | 6 | 0 | Time of the last refresh of transaction DB02 | ||
| 5 | TSNUM |
DB2TSNUM | DEC08 | DEC | 8 | 0 | Number of tablespaces in the R/3 system | ||
| 6 | TSSIZE |
DB2TSSIZT | DEC13 | DEC | 13 | 0 | Total size of all R/3 tablespaces (allocated storage in kB) | ||
| 7 | TSFREE |
DB2TSFREET | DEC13 | DEC | 13 | 0 | Total free size of all R/3 tablespaces in KB | ||
| 8 | TSPCTUSED |
DB2TSPCTUT | DEC3 | DEC | 3 | 0 | Percentage of used size to allocated size of all tablespaces | ||
| 9 | IXNUM |
DB2IXNUM | DEC08 | DEC | 8 | 0 | Number of indexes in the R/3 system | ||
| 10 | IXSIZE |
DB2IXSIZT | DEC13 | DEC | 13 | 0 | Total size of all R/3 indexes (allocated storage in kB) | ||
| 11 | IXFREE |
DB2IXFREET | DEC13 | DEC | 13 | 0 | Total free size of all R/3 indexes in KB | ||
| 12 | IXPCTUSED |
DB2IXPCTUT | DEC3 | DEC | 3 | 0 | Percentage of used size to allocated size of all indexes | ||
| 13 | TBNUM |
DB2TBNUM | DEC08 | DEC | 8 | 0 | Number of tables in the R/3 system | ||
| 14 | TBSIZE |
DB2TBSIZT | DEC13 | DEC | 13 | 0 | Total size of all R/3 tables (used storage in KB) | ||
| 15 | TBMISSDB |
DB2TBMISDB | DEC08 | DEC | 8 | 0 | Number of tables missing in the database | ||
| 16 | IXMISSDB |
DB2IXMISDB | DEC08 | DEC | 8 | 0 | Number of indexes missing in the database | ||
| 17 | TBMISSDDIC |
DB2TBMISDD | DEC08 | DEC | 8 | 0 | Number of tables missing in the ABAP/4 dictionary | ||
| 18 | IXMISSDDIC |
DB2IXMISDD | DEC08 | DEC | 8 | 0 | Number of indexes missing in the ABAP dictionary | ||
| 19 | MONI_VER |
DB2MONIVER | CHAR1 | CHAR | 1 | 0 | Version marker for DB02's data stored in table MONI |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
