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