DB6TREORG - DB6: Database REORG Check Information: Tables

DB6: Database REORG Check Information: Tables information is stored in SAP table DB6TREORG.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".

Fields for table DB6TREORG

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SYSIDName of SAP SystemXSYSYSIDCHAR8
DB6TOWNERDB6: Schema NameXDB6SCHEMACHAR20
DB6TNAMEDB6: Table NameXDB6TABNAMCHAR18
.INCLUDEDB6TREORG_COMMON0
DB6TSPACESYSCAT;Tablespace NameCHAR18
DB6TSIZEADMIN_GET_TAB_INFO: Table Size at last runstatsINT44
DB6F1REORGCHK_TB_STATS: Formula 1 for REORGCHK TableCHAR3
DB6F2REORGCHK_TB_STATS: Formula 2 of REORGCHK AnalysisCHAR3
DB6F3REORGCHK_TB_STATS: Formula 3 of REORGCHK AnalysisCHAR3
DB6REORGREORGCHK_TB_STATS:REORGCHK - RecommendationCHAR3
DB6DATETIMDBA: ISO conform timestamp with ms precissionDB6DATETIMCHAR26
DB6RUNTIMESAP Reorg Jobs: Runtime of Last REORGTIMS6
DB6REODATESAP Reorg Jobs:Date of Last REORGDATS8
DB6REOSIZESAP Reorg Jobs:Table size at last reorgINT44
TSPTYPESYSCAT:Tablespace TypeCHAR1
PCTPAGESAVEDSYSCAT: Percentage of pages saved by compressionINT44
COMPRESSIONSYSCAT: Type of compressionCHAR1
.INCLUDEDB6TABINFO0
DATA_OBJ_L_SIZENumber of logically allocated data pagesDEC12
DATA_OBJ_P_SIZENumber of physically allocated data pagesDEC12
INDEX_OBJ_L_SIZENumber of logically allocated index pagesDEC12
INDEX_OBJ_P_SIZENumber of physically allocated index pagesDEC12
LONG_OBJ_L_SIZENumber of logically allocated long pagesDEC12
LONG_OBJ_P_SIZENumber of physically allocated long pagesDEC12
LOB_OBJ_L_SIZENumber of logically allocated LOB pagesDEC12
LOB_OBJ_P_SIZENumber of physically allocated LOG pagesDEC12
XML_OBJ_L_SIZENumber of logically allocated XML pagesDEC12
XML_OBJ_P_SIZENumber of physically allocated XML pagesDEC12
LOAD_STATUSLOAD Status (IN_PROGRESS/PENDING)CHAR32
LARGE_RIDSLarge RIDs (YES/NO)CHAR10
REORG_PENDINGREORG pending (YES/NO)CHAR10
INDEX_TYPEIndex Type (Type-1/Type-2)CHAR10
AVAILABLEAvailability (YES/NO)CHAR10
Privacy Policy