DB2DB02SUMMARY - Tx DB02: Summary information on first screenincl. size histo
Tx DB02: Summary information on first screenincl. size histo information is stored in SAP table DB2DB02SUMMARY.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2DB02SUMMARY
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| REFRDATE | Date of last refresh of transaction DB02 | X | DB2DB02DAT | DATS | 8 | |
| REFRTIME | Time of the last refresh of transaction DB02 | X | DB2DB02TIM | TIMS | 6 | |
| DBSYS | Central Database System | SYDBSYS | CHAR | 10 | ||
| SYSID | Concatenation of SAP system IDs in an DB2 subsystem | DB2SYSIDS | CHAR | 103 | ||
| R3SIZE | Total size allocated by the R/3 System (KB) | DB2R3SIZT | DEC | 8 | ||
| R3FREE | Total free space in the R/3 System (KB) | DB2R3FREET | DEC | 8 | ||
| R3PCTUSED | Percentage of used size to allocated size of the R/3 System | DB2R3PCTU | DEC | 3 | ||
| TSNUM | Number of tablespaces in the R/3 system | DB2TSNUM | DEC | 5 | ||
| TSSIZE | Total size of all R/3 tablespaces (allocated storage in kB) | DB2TSSIZT | DEC | 7 | ||
| TSFREE | Total free size of all R/3 tablespaces in KB | DB2TSFREET | DEC | 7 | ||
| TSPCTUSED | Percentage of used size to allocated size of all tablespaces | DB2TSPCTUT | DEC | 2 | ||
| IXNUM | Number of indexes in the R/3 system | DB2IXNUM | DEC | 5 | ||
| IXSIZE | Total size of all R/3 indexes (allocated storage in kB) | DB2IXSIZT | DEC | 7 | ||
| IXFREE | Total free size of all R/3 indexes in KB | DB2IXFREET | DEC | 7 | ||
| IXPCTUSED | Percentage of used size to allocated size of all indexes | DB2IXPCTUT | DEC | 2 | ||
| TBNUM | Number of tables in the R/3 system | DB2TBNUM | DEC | 5 | ||
| TBSIZE | Total size of all R/3 tables (used storage in KB) | DB2TBSIZT | DEC | 7 | ||
| TBMISSDB | Number of tables missing in the database | DB2TBMISDB | DEC | 5 | ||
| IXMISSDB | Number of indexes missing in the database | DB2IXMISDB | DEC | 5 | ||
| TBMISSDDIC | Number of tables missing in the ABAP/4 dictionary | DB2TBMISDD | DEC | 5 | ||
| IXMISSDDIC | Number of indexes missing in the ABAP dictionary | DB2IXMISDD | DEC | 5 |