The following procedures, tables, and views support OFS table reorganization.
Procedures
| Procedure Name |
Description |
|---|
| AddReorgObjectsToList |
Add tables to be reorganized or excluded from the reorganizing to a list. |
| CreateReorgList |
Create a reorganize list. |
| DropReorgList |
Drop a reorganize list. |
| RemoveReorgObjectsFromList |
Remove tables from a list. |
Tables
| Table Name |
Description |
|---|
| ReorgHistoryTbl |
Contains history rows for reorganized tables using OFS scheduler |
| ReorgListTbl |
Contains user defined list to prioritize reorganize task |
| ReorgLogTbl |
Logs activities of scheduled reorganize task |
| ReorgLogTblOFS |
Archives log activities of scheduled reorganize to OFS table |
| ReorgObjectsTbl |
Contains objects in user defined list to prioritize reorganize task |
| SettingsTbl |
Stores various settings related to purge task |
Views
| View Name |
Description |
|---|
| ReorgHistoryV |
Contains history rows for reorganized tables using OFS scheduler |
| ReorgHistoryVX |
Contains history rows for reorganized tables using OFS scheduler |
| ReorgLogTblV |
Logs activities of scheduled reorganize |
| ReorgObjectsV |
Contains objects in user-defined list to prioritize reorganize task |