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 SQL Assurance for Db2 13.1.

Planning

This section provides information about the following topics:

Prerequisites for using the BMC AMI SQL Assurance for Db2

  • To use the product, ensure that the following products are installed on your system:
    • IBM z/OS Management Facility (z/OSMF)
    • IBM z/OS JES2 or JES3 system
    • IBM Db2 11 for z/OS or later
    • Version 12.1.00 or later of BMC AMI SQL Explorer for Db2
    • Version 12.1.00 or later of BMC AMI Command Center for Db2
    • Version 2.121.1 or later of Jenkins

    • Java 8 (JDK/JRE) or any later version of Java supported by Jenkins

      Important

      For Java 8 older versions (< 8u161 ), you must download the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy file (jce_policy-8.zip) from the Oracle® website and place it in the security folder of the Java home directory.

  • Configure security authorization for z/OSMF
    For more information, see the IBM z/OS Management Facility Configuration Guide from the IBM documentation.

    Important

    You might need to create authorizations for z/OSMF core functions. To create these authorizations:

    1. Use the IZUSEC job to set up the following accesses:
      • SERVAUTH resource class for CEA.CEATSO.TSOREQUEST
      • TSOPROC resource class for IZUFPROC
    2. Follow the procedure to use the default Language Environment MSGFILE of SYSOUT. For more information, see the section about IBM PI86429 in the IBM documentation.

  • Configure the required user authorities, IBM stored procedures, and plan tables needed to run as an Explain. For more information, see SQL Explorer and Db2 authority requirements and Required authorities for Explains and the What-If Index feature.

  • Ensure that your objects used in the SQL statements performs like your production environment. For more information, see step 2 of the procedure to prepare for a project.
  • Customize the plug-in variables file. For more information, see step 3 of the procedure to prepare for a project.

  • For each project, during configuration, specify the following details for the LPAR in the SYSPLEX on which z/OSMF is running:

    • Mainframe IP address or host name
    • Port number for z/OSMF

    Use the following procedure to determine the IP address or host name and port number:

    1. Identify the Db2 subsystem to which schema changes are applied.
    2. Identify the LPAR and SYSPLEX on which this Db2 subsystem resides.
    3. Verify that z/OSMF is running on an LPAR in this SYSPLEX.
    4. Determine the IP address or host name for this LPAR.
    5. Determine the port number for z/OSMF running on this LPAR.
  • To use SQL Assurance features in pipelines, ensure that the following plug-ins are installed on Jenkins:
    • Pipeline Utility Steps
      This plug-in is a suite of plug-ins that supports implementing and integrating continuous delivery pipelines into Jenkins.
    • Pipeline: Build Step
      This plug-in is a component of the Pipeline Utility Steps plug-in. You must install this plug-in on Jenkins to use SQL Assurance features in Declarative Pipelines using other jobs (projects).

Licensing

To run BMC AMI SQL Assurance for Db2, you must have a license for the following simplified solution:

  • BMC AMI SQL Performance for Db2

This license enables the following premium features for BMC AMI Command Center for Db2 related to BMC AMI SQL Assurance for Db2:


    • Viewing expert rule violations
    • Managing violations to ignore rules
    • Deploying SQL Assurance violation to ignore rules

For more information, see Assuring SQL statement quality.

In addition, this license enables the following premium features for BMC AMI SQL Explorer for Db2:


    • Explain SQL statements
    • What-If Index 
    • SQL Explorer and Db2 authority requirements

For more information, see BMC AMI SQL Explorer for Db2.

Related topic

Preparing-for-a-project



 

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