DB2TREORG - Information for Database reorgcheck: Tables
Information for Database reorgcheck: Tables information is stored in SAP table DB2TREORG.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2TREORG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DB2TOWNER | table owner (same as table schema) | X | CHAR | 8 | ||
| DB2TNAME | Table name | X | CHAR | 18 | ||
| DB2TSPACE | name of the tablespace | CHAR | 18 | |||
| DB2TSIZE | table size | INT4 | 4 | |||
| DB2F1 | formula 1 for reorgchk table | CHAR | 3 | |||
| DB2F2 | formula 2 of reorgchk analysis | CHAR | 3 | |||
| DB2F3 | formula 3 of reorgchk analysis | CHAR | 3 | |||
| DB2REORG | reorgchk - recommendation | CHAR | 3 | |||
| DB2DATETIM | date time of last reorgchk | CHAR | 26 | |||
| DB2RUNTIME | runtime of last reorg | TIMS | 6 | |||
| DB2REODATE | date of last reorg | DATS | 8 | |||
| QUALNUM | DB2 OS/390: Number to generate unique qual. for DB2 object | DB2QUALNUM | NUMC | 6 |