Comparing baseline generations using baseline profiles in batch mode


You can compare baselines in batch that were created using a baseline profile. You compare these baselines by copying and editing the JCL provided with BMC AMI Change Manager for Db2.

You identify baselines by specifying a generation number and a DDL or catalog baseline profile name. A comparison is made only for the baselines indicated by the baseline profile names and generation numbers, not the baseline profiles themselves.

To compare baseline generations in batch

  1. Make a copy of the JCL in the ACMCMPBL member located in hlq.BMCCNTL.
  2. In an ISPF editor, perform the following actions for the placeholders in the JCL as follows:

    Placeholder

    Action

    <INSERT JOB CARD>

    Replace with a job card for your environment

    <ACM DOPTS MODULE NAME>

    Replace with the Change Manager DOPTS module name that was used during installation. The default DOPTS module name is ACMDOPD1.

    <User lib HLQ>

    Replace with the HLQ that was used during the installation for your user libraries

    <Run time HLQ>

    Replace with the HLQ that was used during the installation for your runtime libraries

    <DSNEXIT>

    <DSNLOAD>

    If DSNEXIT and DSNLOAD are in your LINKLIST, remove them from JOBLIB below. Otherwise, replace with the data set names.

    <SSID>

    Replace with the ID of the Db2 subsystem on which you are running

  3. Remove the sample batch baseline commands in the ALUIN DD.
  4. Add the following baseline compare commands for the baselines that you want to compare. For more information about the baseline compare commands, see ALUIN-keywords and Compare-baseline-command.

    • CMPTYPE1
    • CMPIN1 BLPROFILE
    • CMPTYPE2
    • CMPIN2 BLPROFILE

    The following figure shows sample batch compare baseline commands: 

    ***  
    ** COMPARE THE OLDEST WITH THE LATEST GENERATION OF A BASELINE CREATED WITH A BASLINE PROFILE
    ***                                                                       
    CMPTYPE1 BASELINE
      CMPIN1 BLPROFILE(PROFCR.MPSAMP3(0))
    CMPTYPE2 BASELINE
      CMPIN2 BLPROFILE(PROFCR.MPSAMP3(-10))

    ***
    ** COMPARE THE LATEST WITH THE IMMEDIATE PRIOR GENERATION OF A BASELINE CREATED WITH A BASELINE PROFILE
    ***
    CMPTYPE1 BASELINE
      CMPIN1 BLPROFILE(PROFCR.BPCAT01(0))
    CMPTYPE2 BASELINE
      CMPIN2 BLPROFILE(PROFCR.BPCAT01(-1))

  5. Submit the JCL.

 

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