Deploying schema rule sets

(BMC.DB2.SPE2201)

You can deploy rule sets from a Schema Standards Manage Schema Rules view to one or more Db2 subsystems. The deploy process copies the selected rule sets to the target subsystems.

To deploy schema rule sets

1. In the Product Tools perspective, select a Schema Standards Manage Schema Rules view from the navigation pane.
2. In the Manage Schema Rules grid, select one or more rule sets that you want to deploy.
3. Click Deploy rule sets . 
4. In the Deploy Schema Standards Rule Sets dialog box, perform the following steps:
   1. In the Name field, accept the default name, or provide a name for the deployment.
      The name can contain up to 50 characters, including all printable ASCII characters.

   2. Select one or more Db2 subsystem connections to which you want to deploy the rule sets.

      Tip

      You can select to show only your favorites.

   3. Select whether to continue if an error occurs for a selected Db2 subsystem:
      • Clearing the check box stops the deployment immediately.
      • Selecting the check box continues the deployment with the next Db2 subsystem.
   4. Click Next.

5. From the Deploy Schema Standards Rule Sets Rule Set List, clear any rule sets that you do not want to deploy.

   To filter the Rule Set List based on Action, use the Add, Overwrite, and Error buttons. If all rows in the list are for a single action, the buttons are not displayed.

   If BMC AMI Command Center detects a connection problem in the target Db2 subsystem, the application performs the following actions:

   • Removes the check box from all the affected rows in the list. For more information about the connection problem, hover over any row without a check box.
   • Displays an error message in the lower left-hand corner of the wizard, which identifies the Db2 subsystem that has a connection problem.
6. Click Next.

7. Review the summary of the rule set deployment, and click Finish:

   • The deployment view is displayed under Deployment in the navigation pane.
   • The Rule Set List and Results tabs are displayed in the results pane.

   Important

   Details of the deployment processing are displayed on the Results tab. 

   The Deployment view persists in the workspace during your current (BMC.DB2.SPE2201) session . The Deployment view is removed from the workspace when you log out. 

8. (Optional) To save the deployment report, perform the following tasks:
   1. Click View report .
   2. Click Save output text .

To deploy schema rule sets by using an existing deployment view

Use this procedure to redeploy Schema Standards rule sets that have already been defined in a deployment view. For example, you might have corrected a Db2 issue that previously prevented the rules from being deployed.

1. In the Product Tools navigation pane, select a Schema Standards rule sets deployment view.
   The results pane is populated with the Rule Set List and Results tabs.
2. Click Deploy  .
3. In the Deploy SQL Schema Standards Rule Sets dialog box, select one or more Db2 subsystem connections to which you want to deploy the rule sets.
4. Specify whether to continue if an error occurs for a selected Db2 subsystem:
   • Clear the check box to stop the deployment immediately.
   • Select the check box to continue the deployment with the next Db2 subsystem.
5. Click Next.

6. From the Rule Set List, select the rule sets that you want to deploy.
   By default all rule sets are selected.
   Use the check box at the top of the first column to clear or select all rule sets from the list.

   To filter the Rule Set List based on Action, use the Add, Overwrite, and Error buttons. If all rows in the list are for a single action, the buttons are not displayed.

7. Click Next.
   A summary of the deployment is displayed.
8. Review the summary of the rule set deployment, and click Finish.
9. (Optional) To save the deployment report, perform the following tasks:
   1. Click View report .
   2. Click Save output text .