Limited supportBMC 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.

Using Schema Standards rules with user-defined variables

This topic describes how to use the schema standards process to define variables with which to create rules. To use this functionality, perform the following tasks:

Task 1: Create an XML document in which to define user variables

  • Create the document in a mainframe PDS and member.  

    Best practice

    We recommend that you use a data set configuration similar to the rtehlq.BMCXML installation data set configuration.

  • The document should contain beginning and ending user_vars and variable tags.

Task 2: Define user variables

  • In the XML document, create user variables to define your rule expression or WHEN condition. Make sure that the user variable names are unique; you can't define a user variable name identical to the host variable name.

  • The following example illustrates a user variable layout in XML:

    <?xml version="1.0"?>

    <user_vars>
     <variable_name1>XXXX</variable_name1>
     <variable_name2>##</variable_name2>
    </user_vars>

    Tip

    For your reference, the following sample user variable XML documents are available in rtehlq.BMCCNTL

    • For a development environment: AMADUSVR
    • For a production environment: AMAPUSVR

    Each document defines sample variables. You can use these documents to test the user variables and to customize rule attributes for your environment.

Task 3: Create Schema Standards rules with the user variables

  • In BMC Workbench for DB2, use the user variables defined in the XML document to create a rule set with rules.
  • $BMC USRVARS SAMPLE RULE SET contains two sample rules that were created with the XML user variables in the earlier example.

  • For more information, see Using the sample rule sets.

Task 4: Update the Schema Standards JCL with an additional DD that references the user variable XML document

  • Add an additional DD to the Schema Standards JCL so that it can access the user variable XML member.
  • When using the BMC AMI DevOps Schema Mgmt for Db2 - Schema Standards plugin step, add the following DD after the ALUIN DD keywords in the Schema Standards Input Stream:
    • //SCHEMAS.$USRVARS DD DISP=SHR,DSN=<user variable pds data set(member)>
  • When using the Schema Standards batch job located in your installation data set, rtehlq.BMCCNTL(AMASSTDS), you can add the following DD after the ALUIN DD keywords:
    • //SCHEMAS.$USRVARS DD DISP=SHR,DSN=<user variable pds data set(member)>

Related topics

Using

Using-BMC-AMI-DevOps-in-Jenkins

 

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