Setting up automated reorganizations

To automate reorganizations based only on REORG candidate table recommendations

1. Ensure that the reorg.analyze_physical_organization configuration option in member IODPAREO (the REORG Advisor) is set to 1.By using this default setting, the REORG Advisor reviews both physical and performance criteria.

2. Create the object set PUBLIC.AFD_REORG_CAND by modifying the SQL in the INSOBJS member of the sample library as detailed in the instructions within the sample file. Following is a summary of the steps to edit this file.

   Warning

   Important

   Object sets specify Db2 objects to include or exclude from action generation. Object sets use name patterns, dynamic SQL, and other methods to identify Db2 objects for processing. This step creates an object set that DASD MANAGER PLUS uses to query the REORG candidate table by populating the DASD MANAGER PLUS control tables.

   1. Edit the member to execute it on your subsystem using DSNTEP2. As an alternative, you can use the SQL with any other software product that executes SQL.
   2. In the INSERT statements, change the creator name for the DASD MANAGER PLUS tables to match your site’s installation. Also, change the subsystem ID where those tables are located.
   3. In the INSERT statements, change the creator and table name for the REORG candidate table. Also, change the subsystem ID where that table is located.
   4. Submit the job.

   Warning

   Important

   For more information about maintaining object sets, see Using-object-sets.

3. Change and execute the default corrective action:

   1. (optional) Using the DASD MANAGER PLUS online interface, update the sample action named BMC_BMCREORG_DEFAULT (installed with DASD MANAGER PLUS) to select utility options for your site.

      Warning

      Important

      The sample files use the pound sign (#) to identify lines that require changes.

      Typically, you add a service syntax (a named set of syntax options that are stored in the DASD MANAGER PLUS control tables) for each action to select your syntax options and data set allocation information. If you do not set any options, DASD MANAGER PLUS uses internal defaults and the product options file (POF), which was created during installation, to provide default syntax and JCL generation defaults.

   2. (optional) Add other services such as utilities or job steps to the actions. For example, you could add a QUIESCE or a AMICOPY service before the BMCREORG in BMC_BMCREORG_DEFAULT action.

      Warning

      Important

      For more information about maintaining actions, see Maintaining-and-generating-Service-Actions.

4. Change the sample BMCTRIG JCL as detailed in the instructions within the sample file. Following is a summary of the steps to edit this file.

   Warning

   Important

   TRIGFORC contains a sample job that runs BMCTRIG against the object sets to generate reorganization actions based on the REORG candidate table. TRIGFORC uses PUBLIC.AFD_REORG_CAND to identify objects, and the default corrective action BMC_BMCREORG_DEFAULT to generate BMC REORG PLUS for DB2 jobs.

   1. Change the member to include the Db2 and DASD MANAGER PLUS data set names that are installed at your site.
   2. Change the job card to meet your installation standards.
   3. Change the parameters for ASUSTRIG to specify your DB2 subsystem and the DASD MANAGER PLUS installation options module.
   4. Change the BMCTRIG command syntax to identify the data sets that are used to generate the BMC REORG PLUS jobs.

   5. Change the job card specifications for the generated jobs.

      Warning

      Important

      For more information about setting up BMCTRIG jobs, see Setting-up-a-BMCTRIG-job.

5. Execute or schedule TRIGFORC based on your site’s requirements.BMCTRIG generates a reorganization job step for each object that the object set identifies. BMCTRIG balances the workload across the number of jobs that the NUMJOBS option specifies.

6. Schedule the BMCTRIG generated jobs based on your site’s requirements.Use a scheduler or the BMCTRIG AUTOSUBMIT option to submit the generated JCL automatically.

   Warning

   Important

   For more information about the additional options for executing the corrective actions that BMCTRIG identified, see Analyzing-objects-by-using-BMCTRIG.

To automate reorganizations based on REORG candidate table recommendations and BMCTRIG evaluations

1. Ensure that the reorg.analyze_physical_organization configuration option in member IODPAREO (the REORG Advisor) is set to 0.By default, the REORG Advisor reviews both physical and performance criteria. Setting the configuration option to 0 ensures that REORG Advisor reviews only performance criteria. This allows the DASD MANAGER PLUS BMCTRIG function to handle all real-time statistics (RTS) and other organization related evaluation.

2. Create the object set PUBLIC.AFD_REORG_CAND by using the SQL in the INSOBJS member as detailed in the instructions within the sample file. Following is a summary of the steps to edit this file.

   Warning

   Important

   Object sets specify Db2 objects to include or exclude from action generation. Object sets use name patterns, dynamic SQL, and other methods to identify Db2 objects for processing. This step creates an object set that DASD MANAGER PLUS uses to query the REORG candidate table by populating the DASD MANAGER PLUS control tables.

   1. Edit the INSOBJS member to execute it on your subsystem by using DSNTEP2. As an alternative, you can use the SQL with any other software product that executes SQL.
   2. In the INSERT statements, change the creator name for the DASD MANAGER PLUS tables to match your site’s installation. Also, change the subsystem ID where these tables are located.
   3. In the INSERT statements, change the creator and table name for the REORG candidate table. Also, change the subsystem ID where that table is located.

   4. Submit the job.

      Warning

      Important

      For more information about maintaining object sets, see Using-object-sets.

3. Change and execute the INSTHRSH member to insert thresholds that BMCTRIG uses to further evaluate the object set as detailed in the instructions within the sample file. Following is a summary of the steps to edit this file.

   1. Change the job card to meet your installation standards.
   2. Change #ASUSSID in SYSTSIN to the subsystem ID where your DASD MANAGER PLUS tables are located and where this job is executed.
   3. Change the creator name used with the DASD MANAGER PLUS tables to match your site’s installation.
   4. Submit the job.
   5. (optional) Using the DASD MANAGER PLUS interface, change the threshold values, if needed.

   The following table lists the thresholds and their values.

   Threshold name	Value
   APPNDINS	10
   DSEXTENT	50
   EXTENTS	50
   FARIND	15
   LEAFFOFF	10
   LEAFTOFF	30
   PSEUDODL	10
   REORMDEL	1
   REORMODS	10
   REORPEND	1
   REORSPAC	30
   SPACE	30
   TOTALIND	30
   UNCLUST	10

4. Change the default corrective action:

   1. (optional) Using the DASD MANAGER PLUS online interface, update the action named BMC_BMCREORG_DEFAULT (installed with DASD MANAGER PLUS) to select utility options for your site.

      Warning

      Important

      Typically, you add a service syntax (a named set of syntax options that are stored in the DASD MANAGER PLUS control tables) for each action to select your syntax options and data set allocation information. If you do not set any options, DASD MANAGER PLUS uses internal defaults and the product options file (POF), which was created during installation, to provide default syntax and JCL generation defaults.

   2. (optional) Add other services such as utilities or job steps to the actions. For example, you could add a QUIESCE or a AMICOPY service before the BMCREORG in BMC_BMCREORG_DEFAULT action.
5. Change and execute the INSCACT member as detailed in the instructions within the sample file.

6. Change the sample BMCTRIG JCL as detailed in the instructions within the sample file.Following is a summary of the steps to edit this file.

   Warning

   Important

   TRIGEXCP contains a sample job that

   • Runs BMCSTATS against the object set
   • Runs BMCTRIG to further evaluate the objects that are using the exceptions
   • Generates reorganization jobs for objects that meet both the Performance Advisor and the BMCTRIG criteria

   TRIGEXCP uses PUBLIC.AFD_REORG_CAND to identify objects, and the default corrective action BMC_BMCREORG_DEFAULT to generate BMC REORG PLUS for DB2 jobs.

   1. (optional) Using the DASD MANAGER PLUS online interface, update the action named BMC_BMCREORG_DEFAULT (installed with DASD MANAGER PLUS) to select utility options for your site.
   2. Change the member to include the Db2 and DASD MANAGER PLUS data set names that are installed at your site.
   3. Change the job card to meet your installation standards.
   4. Change the parameters for ASUSMAIN and ASUSTRIG to specify your Db2 subsystem and the DASD MANAGER PLUS installation options module.
   5. Change the BMCTRIG command syntax to identify the data sets that are used to generate the BMC REORG PLUS jobs.
   6. Change the job card specifications for the generated jobs.

   Warning

   Important

   For more information about setting up BMCTRIG jobs, see Setting-up-a-BMCTRIG-job.

7. Execute or schedule TRIGEXCP based on your site’s requirements.First, BMCTRIG checks for objects that meet or exceed the thresholds that you have defined in the object set. BMCTRIG then generates a reorganization job step for each identified object. BMCTRIG balances the workload across the number of jobs that the NUMJOBS option specifies.
8. Schedule the BMCTRIG generated jobs based on your site’s requirements.

9. Use a scheduler or the BMCTRIG AUTOSUBMIT option to submit the generated JCL automatically.

   Warning

   Important

   For more information about the additional options for executing the corrective actions that BMCTRIG identified, see Analyzing-objects-by-using-BMCTRIG.