18.18.4 Notes

  1. 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.
  2. 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.
  3. 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.