DB6INSPECT - DB6: DB2INSPECT Results
DB6: DB2INSPECT Results information is stored in SAP table DB6INSPECT.
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 DB6INSPECT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
| TABSCHEMA | DB6: Schema Name | X | DB6SCHEMA | CHAR | 20 | |
| TABNAME | DB6: long table name | X | DB6TABNAML | CHAR | 128 | |
| SAVED_PAGES_PCT | output inspect | INT4 | 4 | |||
| SAVED_BYTES_PCT | output inspect | INT4 | 4 | |||
| ROWS_SMALL_PCT | output inspect | INT4 | 4 | |||
| COMPR_DICT_SIZE | output inspect | DEC | 12 | |||
| EXPAN_DICT_SIZE | output inspect | DEC | 12 | |||
| CHECK_DATE | date of last compress check | DATS | 8 | |||
| CHECK_TIME | time of last compress check | TIMS | 6 |