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 BMC AMI DevOps for Db2 13.1.

Example values for Schema Mig: Use Existing CDL File


(SPE2101)

This topic contains example values for configuration of Schema Mig: Use Existing CDL File.  The example values are primarily comprised of properties from the sample component template for the fields that you must configure for this plug-in step.

Process step

Field

Value

Notes

BMC AMI DevOps Common - Authentication













Name

Authentication [default]


Run Step in Debug Mode


Clear this check box.

Mainframe (host name or IP address)

${p:ama.host.name}


Port Number

${p:ama.port}


Mainframe User ID

${p:ama.user}


Provide Password via Property Parameter


Mainframe Password


This field is not available when the Provide Password via Property Parameter check box is selected.

Mainframe Password via Property Parameter

${p:ama.password}


Plug-in Variables File Path

${p:ama.properties.file.path}

This path should be accessible by the Agent where Application process is running.

BMC AMI DevOps Schema Migration - Schema Mig: Use Existing CDL File





















Name

Schema Mig: Use Existing CDL File [default]


Disable Step


Clear this check box.

Skip Step if Previous Compare Found No Differences


Run Step in Debug Mode


Generate JCL Only


Clear this check box.

SSID

${p:ama.ssid}


Work ID Owner

${p:ama.work.id.owner}


Work ID Name

${p:ama.work.id.name}


CDL PDS and Member Name

${p:ama.cdl.pds.member}


Use Inbound Migrate Profile


This field is optional.

Inbound Migrate Profile

${p:ama.inbound.migrate.profile}

If you have selected the Use Inbound Migrate Profile check box, you must enter a value for this field.

Worklist PDS and Member Name

${p:ama.worklist.pds.member}


Impact Report PDS and Member Name

${p:ama.impact.report.pds.member}


Execution JCL PDS and Member Name

${p:ama.exec.jcl.pds.member}


Select Baseline Type Before Execution

None

This field is optional. By default, no baseline is created.

Baseline Profile Name (before execution)

${p:ama.baseline.profile.before}

If you have selected a baseline type in the Select Baseline Type Before Execution field, you must enter a value for this field.

Baseline Name (before execution)

${p:ama.baseline.name.before}

If you have selected a baseline type in the Select Baseline Type Before Execution field, you must enter a value for this field.

Generate CDL to Rollback Schema Changes


This field is optional.

Rollback PDS and Member Name (CDL)

${p:ama.rollback.pds.cdl}

If you have selected the Generate CDL to Rollback Schema Changes check box, you must enter a value for this field.

Create Baseline After Execution


This field is optional.

Baseline Profile Name (after execution)

${p:ama.baseline.profile.after}

If you have selected the Create Baseline After Execution check box, you must enter a value for this field.

Baseline Name (after execution)

${p:ama.baseline.name.after}

If you have selected the Create Baseline After Execution check box, you must enter a value for this field.

Job Card

//DEVOPS JOB (#acctno#),'COMPARE',
//  class="A",MSGLEVEL=(1,1)              
//*
//*
//*

This value is automatically generated for this field when you select a comparison type. If you modify this value and then change the comparison type, your changes persist.

Additional Compare Input Keywords


This field will be blank unless additional input keywords are manually added here.

Additional Import Input Keywords


This field will be blank unless additional input keywords are manually added here.

Additional Analysis Input Keywords


This field will be blank unless additional input keywords are manually added here.

Additional JCL Generation Input Keywords


This field will be blank unless additional input keywords are manually added here.

JCL

${Job Card}
//*
//        JCLLIB ORDER=(#proclib#)
//*
//JOBLIB  DD  DSN=#joblib1#,DISP=SHR
//        DD  DSN=#joblib2#,DISP=SHR
//        DD  DSN=#dsnexit#,DISP=SHR
//        DD  DSN=#dsnload#,DISP=SHR
//***************************************************
// SET ACMDOPT=#dopts#
// SET RTEHLQ=#rtehlq#
// SET USRHLQ=#usrhlq#
//***************************************************
// SET DDLFILE=${Compare2 DDL/Worklist PDS and Member Name}
// SET CDLFILE=${CDL PDS and Member Name}
// SET WORKLIST=${Worklist PDS and Member Name}
// SET EXECJCL=${Execution JCL PDS and Member Name}
// SET IMPRPT=${Impact Report PDS and Member Name}
//*
// SET POFFILE=#pofdsn#
//*----------------------------------------------------
//* BMC CHANGE MANAGER COMPARE
//*----------------------------------------------------
${Compare Input Stream}
//*----------------------------------------------------
//* BMC CHANGE MANAGER IMPORT
//*----------------------------------------------------
//IMPORT   EXEC AMAPROCI,
//    COND=${BMC_COMPARE_COND_CODE}
//IMPORT.IMPORTIN DD DISP=SHR,
//  DSN=&CDLFILE
${Import Input Stream}
//*----------------------------------------------------
//* BMC CHANGE MANAGER ANALYSIS
//*----------------------------------------------------
//ANALYSIS EXEC AMAPROCA,
//    COND=${BMC_COMPARE_COND_CODE}
${Analysis Input Stream}
//*----------------------------------------------------
//* BMC JCL GENERATION
//*----------------------------------------------------
//JCLGEN   EXEC AMAPROCJ,
//    COND=${BMC_COMPARE_COND_CODE}
${JCL Generation Input Stream}


Acceptable Return Code

0004


Maximum Job Wait Time

2


BMC AMI DevOps Schema Migration - Output Transmission

Name

Output Transmission [default]


Disable Step


Clear this check box.

Skip Step if Previous Compare Found No Differences


Run Step in Debug Mode


Source PDS Name (CDL)

${p:ama.src.pds.cdl}


Source PDS Name (WORKLIST)

${p:ama.src.pds.worklist}


Source PDS Name (EXEC_JCL)

${p:ama.src.pds.exec.jcl}


Source PDS Name (IMPACT REPORT)

${p:ama.src.pds.impact.report}


Source Member Name

${p:ama.src.member}


Destination Directory Name

${p:ama.dest.dir}



Destination File Name

${p:ama.dest.file}


BMC AMI DevOps Common - JCL Execution






Name

JCL Execution [default]


Disable Step     


Clear this check box.

Skip Step if Previous Compare Found No Differences


Run Step in Debug Mode


Execute JCL from Mainframe PDS


Execution JCL PDS or Directory Name

${p:ama.jcl.pds}


Execution JCL Member or File Name

${p:ama.jcl.member}


Acceptable Return Code

0004


Maximum Job Wait Time

2


BMC AMI DevOps Common - Clean Up

Name

Clean Up [default]


 

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

BMC AMI DevOps for Db2 12.1