Enabling IBM Db2 SQL Performance Analyzer

IBM Db2 SQL Performance Analyzer provides resource usage information and costs associated with SQL queries without having to run them in Db2. This analysis helps you to tune your queries to achieve maximum performance.

Before you begin

You must install IBM Db2 SQL Performance Analyzer as a separate product before you begin. See the IBM Db2 SQL Performance Analyzer for z/OS Installation Guide in the IBM Db2 Tools Product Documentation.

Performance Warehouse must be enabled before you begin and running while you are using SQL Performance Analyzer.

Note: Only SQL Performance Analyzer versions 5.1 and 5.2 specified in KD2_PFxx_SQLPA_VERSION are supported with OMEGAMON for Db2 Performance Expert version 5.5.0.

Procedure

Set parameter KD2_PFxx_SQLPA_ENABLE to Y.
You can configure the following additional parameters:
  • KD2_PFxx_SQLPA_STEPDSN
  • KD2_PFxx_SQLPA_VERSION
  • KD2_PFxx_SQLPA_CF_ENBL
  • KD2_PFxx_SQLPA_CF_ANLC
  • KD2_PFxx_SQLPA_CF_ANLP