Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

Populating the REORG candidate table

Generally, you need to perform the following steps to populate the REORG candidate table.

For more information about a particular step, see the SQL Performance for DB2 User Guide.

To populate the REORG candidate table

  1. Create the required tables at your centralized database location, or on each localized database location.
  2. Ensure that all Data Collectors are configured properly.
  3. Set up automation to capture an archive based on the previous day’s data.
  4. Submit a daily job to maintain the object statistics table.
  5. Configure REORG Advisor thresholds and options.
  6. Submit a daily job to execute REORG Advisor, which populates the REORG candidate table.

Related topics

Overview of using Performance Advisor with DASD MANAGER PLUS

Setting-up-automated-reorganizations

Preparing-to-use-REORG-Advisor

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

DASD MANAGER PLUS for DB2 12.1