18.18.4 Notes
- If RDAREA re-initialization or the PURGE TABLE statement is executed before re-execution of the database reorganization utility, the synchronization point information that was set may be lost. In such a case, the re-execution will not be treated as re-execution of reorganization with synchronization points set.
- If the utility terminates abnormally during reorganization with synchronization points set for a LOB column structure base table, specify CLR when the utility is re-executed. If CLR is not specified, retrieval efficiency for the LOB column may deteriorate even after reorganization.
- If names for the files listed below are not stated clearly, the database reorganization utility will create these files automatically:
- Index information file
- Error information file
If the database reorganization utility terminates abnormally, these files will remain on the disk. Because the database reorganization utility will create files under new names during re-execution, these files remaining from before the abnormal termination may cause a space shortage on the disk. Therefore, delete these files before re-execution.