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)".
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 |
---|---|---|---|---|---|---|
SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
DB6TOWNER | DB6: Schema Name | X | DB6SCHEMA | CHAR | 20 | |
DB6TNAME | DB6: Table Name | X | DB6TABNAM | CHAR | 18 | |
.INCLUDE | DB6TREORG_COMMON | 0 | ||||
DB6TSPACE | SYSCAT;Tablespace Name | CHAR | 18 | |||
DB6TSIZE | ADMIN_GET_TAB_INFO: Table Size at last runstats | INT4 | 4 | |||
DB6F1 | REORGCHK_TB_STATS: Formula 1 for REORGCHK Table | CHAR | 3 | |||
DB6F2 | REORGCHK_TB_STATS: Formula 2 of REORGCHK Analysis | CHAR | 3 | |||
DB6F3 | REORGCHK_TB_STATS: Formula 3 of REORGCHK Analysis | CHAR | 3 | |||
DB6REORG | REORGCHK_TB_STATS:REORGCHK - Recommendation | CHAR | 3 | |||
DB6DATETIM | DBA: ISO conform timestamp with ms precission | DB6DATETIM | CHAR | 26 | ||
DB6RUNTIME | SAP Reorg Jobs: Runtime of Last REORG | TIMS | 6 | |||
DB6REODATE | SAP Reorg Jobs:Date of Last REORG | DATS | 8 | |||
DB6REOSIZE | SAP Reorg Jobs:Table size at last reorg | INT4 | 4 | |||
TSPTYPE | SYSCAT:Tablespace Type | CHAR | 1 | |||
PCTPAGESAVED | SYSCAT: Percentage of pages saved by compression | INT4 | 4 | |||
COMPRESSION | SYSCAT: Type of compression | CHAR | 1 | |||
.INCLUDE | DB6TABINFO | 0 | ||||
DATA_OBJ_L_SIZE | Number of logically allocated data pages | DEC | 12 | |||
DATA_OBJ_P_SIZE | Number of physically allocated data pages | DEC | 12 | |||
INDEX_OBJ_L_SIZE | Number of logically allocated index pages | DEC | 12 | |||
INDEX_OBJ_P_SIZE | Number of physically allocated index pages | DEC | 12 | |||
LONG_OBJ_L_SIZE | Number of logically allocated long pages | DEC | 12 | |||
LONG_OBJ_P_SIZE | Number of physically allocated long pages | DEC | 12 | |||
LOB_OBJ_L_SIZE | Number of logically allocated LOB pages | DEC | 12 | |||
LOB_OBJ_P_SIZE | Number of physically allocated LOG pages | DEC | 12 | |||
XML_OBJ_L_SIZE | Number of logically allocated XML pages | DEC | 12 | |||
XML_OBJ_P_SIZE | Number of physically allocated XML pages | DEC | 12 | |||
LOAD_STATUS | LOAD Status (IN_PROGRESS/PENDING) | CHAR | 32 | |||
LARGE_RIDS | Large RIDs (YES/NO) | CHAR | 10 | |||
REORG_PENDING | REORG pending (YES/NO) | CHAR | 10 | |||
INDEX_TYPE | Index Type (Type-1/Type-2) | CHAR | 10 | |||
AVAILABLE | Availability (YES/NO) | CHAR | 10 |