Perform reorganization once a week on all data and PI tablespaces. Perform reorganization as needed, once a week is suggested, for the indexes for these tables:
Perform a quiesce for each tablespace being reorganized before you start the reorganization. The quiesce provides a point to which you can recover, if necessary. You may also need to reorganize the indexes in between the scheduled table reorganizations if numerous rows are being inserted into the encyclopedia.
The job CEUREOR (or the alternative job CAUREOR) runs the Reorg utility for Host Encyclopedia tablespaces. For more information about running the Reorg utility, refer to DB2 documentation.
|
Copyright © 2013 CA.
All rights reserved.
|
|