DB2REOTS - REORG of Tablespaces
REORG of Tablespaces information is stored in SAP table DB2REOTS.
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 DB2REOTS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DBNAME | Database name | X | DB2DBNAME | CHAR | 8 | |
| TSNAME | Name of the tablespace | X | DB2TSNAME | CHAR | 8 | |
| TSPARTS | Number of partition | X | DB2PARTNRI | INT4 | 4 | |
| NOREORG | A reorg should never work on this tablespace or index | DB2NOREORG | CHAR | 1 | ||
| NEEDREORG | State if a reorg is needed (Y/N) | DB2REONEED | CHAR | 1 |