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".

Fields for table DB2DB02SUMMARY

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
REFRDATEDate of last refresh of transaction DB02XDB2DB02DATDATS8
REFRTIMETime of the last refresh of transaction DB02XDB2DB02TIMTIMS6
DBSYSCentral Database SystemSYDBSYSCHAR10
SYSIDConcatenation of SAP system IDs in an DB2 subsystemDB2SYSIDSCHAR103
R3SIZETotal size allocated by the R/3 System (KB)DB2R3SIZTDEC8
R3FREETotal free space in the R/3 System (KB)DB2R3FREETDEC8
R3PCTUSEDPercentage of used size to allocated size of the R/3 SystemDB2R3PCTUDEC3
TSNUMNumber of tablespaces in the R/3 systemDB2TSNUMDEC5
TSSIZETotal size of all R/3 tablespaces (allocated storage in kB)DB2TSSIZTDEC7
TSFREETotal free size of all R/3 tablespaces in KBDB2TSFREETDEC7
TSPCTUSEDPercentage of used size to allocated size of all tablespacesDB2TSPCTUTDEC2
IXNUMNumber of indexes in the R/3 systemDB2IXNUMDEC5
IXSIZETotal size of all R/3 indexes (allocated storage in kB)DB2IXSIZTDEC7
IXFREETotal free size of all R/3 indexes in KBDB2IXFREETDEC7
IXPCTUSEDPercentage of used size to allocated size of all indexesDB2IXPCTUTDEC2
TBNUMNumber of tables in the R/3 systemDB2TBNUMDEC5
TBSIZETotal size of all R/3 tables (used storage in KB)DB2TBSIZTDEC7
TBMISSDBNumber of tables missing in the databaseDB2TBMISDBDEC5
IXMISSDBNumber of indexes missing in the databaseDB2IXMISDBDEC5
TBMISSDDICNumber of tables missing in the ABAP/4 dictionaryDB2TBMISDDDEC5
IXMISSDDICNumber of indexes missing in the ABAP dictionaryDB2IXMISDDDEC5
Privacy Policy