| SYSID |
✔ |
Name of SAP System |
SYSYSID |
CHAR |
8 |
|
| DB6TOWNER |
✔ |
DB6: Schema Name |
DB6SCHEMA |
CHAR |
20 |
|
| DB6TNAME |
✔ |
DB6: Table Name |
DB6TABNAM |
CHAR |
18 |
|
| DB6TSPACE |
|
SYSCAT;Tablespace Name |
|
CHAR |
18 |
|
| DB6TSIZE |
|
ADMIN_GET_TAB_INFO: Table Size at last runstats |
|
INT4 |
10 |
|
| 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 |
10 |
|
| TSPTYPE |
|
SYSCAT:Tablespace Type |
|
CHAR |
1 |
|
| PCTPAGESAVED |
|
SYSCAT: Percentage of pages saved by compression |
|
INT4 |
10 |
|
| COMPRESSION |
|
SYSCAT: Type of compression |
|
CHAR |
1 |
|
| DATA_OBJ_L_SIZE |
|
Number of logically allocated data pages |
|
DEC |
22 |
|
| DATA_OBJ_P_SIZE |
|
Number of physically allocated data pages |
|
DEC |
22 |
|
| INDEX_OBJ_L_SIZE |
|
Number of logically allocated index pages |
|
DEC |
22 |
|
| INDEX_OBJ_P_SIZE |
|
Number of physically allocated index pages |
|
DEC |
22 |
|
| LONG_OBJ_L_SIZE |
|
Number of logically allocated long pages |
|
DEC |
22 |
|
| LONG_OBJ_P_SIZE |
|
Number of physically allocated long pages |
|
DEC |
22 |
|
| LOB_OBJ_L_SIZE |
|
Number of logically allocated LOB pages |
|
DEC |
22 |
|
| LOB_OBJ_P_SIZE |
|
Number of physically allocated LOG pages |
|
DEC |
22 |
|
| XML_OBJ_L_SIZE |
|
Number of logically allocated XML pages |
|
DEC |
22 |
|
| XML_OBJ_P_SIZE |
|
Number of physically allocated XML pages |
|
DEC |
22 |
|
| 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 |
|