Using Schema Standards rules with user-defined variables in Jenkins

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: To 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: To 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: To create Schema Standards rules with the user variables

In BMC AMI Command Center 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: To 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)>