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 |