Planning

Prerequisites for using the BMC AMI SQL Assurance for Db2

• To use the product, make sure 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 12 for z/OS or later
  • Version 13.1.00 or later of BMC AMI SQL Explorer for Db2
  • Version 13.1.00 or later of BMC AMI Command Center for Db2
  • (BMC.DB2.SPE2407)JDK17 is supported for Jenkins.
  • (BMC.DB2.SPE2404) One of the following CI/CD tools:
    • (BMC.DB2.SPE2407)The current version of Jenkins
    • The current version of Azure DevOps
    • The current version of GitHub Actions
    • (BMC.DB2.SPE2501)The current version of GitLab CI/CD
  • (BMC.DB2.SPE2501)Versions 20.10.17 and later of Docker are supported for Azure DevOps, GitHub Actions, and GitLab CI/CD.

• 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 SQL statements are evaluated.
  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 Jenkins 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 DML 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 Explorerand Db2 authority requirements

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