Creating migrate and baseline profiles in batch mode


You can use ALTER and BMC AMI Change Manager for Db2 to automate profiles by creating migrate and baseline profiles in batch. You create these profiles by copying and editing the JCL provided with ALTER or Change Manager.

To create profiles in batch mode

  1. Make a copy of the JCL in the ACMBPROF 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 ALTER or 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 profile commands in the ALUIN DD.
  4. Add the batch profile commands for the required profiles. For more information about the batch profile commands, see the following topics:

    The following figure shows sample batch profile commands: 

    //ALUIN    DD *                                                             
     SSID <SSID>                                                                
    ***  
    ** CREATE MIGRATE PROFILE WITH SCOPE RULES
    ***                                                                       
    CREATE MIGRATE PROFILE PROFCR.MPSAMP3
    ADD SCOPE INCLUDE DB QADB1 MIGDATA MIGCK MIGFK MIGTS MIGTB MIGRP MIGMK MIGTR
    ADD SCOPE INCLUDE TS QADB2.TS01 MIGTB, MIGVW, MIGIX
    ADD SCOPE INCLUDE TB QADB3.TB01 MIGDATA
    ***
    ** CREATE CAT BASELINE PROFILE WITH RETAINMAX AND SCOPE RULES
    ***
    CREATE BASELINE PROFILE PROFCR.BPCAT01 CATALOG
    RETAINMAX=5 REMARKS(CATALOG BP create RETAINMAX)
    ADD SCOPE DB QADB1 MIGALL
    ADD SCOPE TS QADB2.TS01 MIGTB MIGFK MIGCK
    ADD SCOPE SG SG001
    ***
    ** REPLACE EXISTING MIGRATE PROFILE WITH PROFILE THAT REFS A BASELINE PROFILE
    ***
    REPLACE MIGRATE PROFILE PROFCR.MPSAMP1
    OUTBOUND BLPREF=PROFCR.BPTST1
    REMARKS(MP replace with BLPREF)
    ***
    ** REPLACE EXISTING BASELINE PROFILE WITH PROFILE THAT REFS A MIGRATE PROFILE
    ***
    REPLACE BASELINE PROFILE PROFCR.BPCAT01 CATALOG
    MIGPREF=PROFCR.MPSAMP3 DELETEAGE=10
    REMARKS(CATALOG BP create MIGPREF DELETEAGE)
    /*                                                                          
    //*                                                                         
    //**********************************************************************    

  5. To create the profiles, submit the JCL.

 

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