Optional: Interfacing with Db2 Query Monitor

You can use an optional task in Tools Customizer to set up the interface between Db2 SQL Performance Analyzer and Db2® Query Monitor. If you are also installing Db2 Query Monitor, you might want to enable this interface.

About this task

This optional configuration task allows Db2 Query Monitor to call Db2 SQL Performance Analyzer for further analysis of problem SQL.

Tools Customizer creates the ANLCIQM CLIST in the high_level_qualifier.SANLCLST library for interfacing Db2 SQL Performance Analyzer with the Db2 Query Monitor.

Procedure

To enable Db2 SQL Performance Analyzer to interface with Db2 Query Monitor:

  1. Select and specify values for all of the required Set up interface to Query Monitor task parameters.
    The ANLCIQM CLIST is created for you.
  2. Set QDEBUG to NO.
    The remaining parameters are set by Db2 Query Monitor upon invocation.
  3. In Db2 Query Monitor, export SQL text of interest to a data set through the Export SQL Text to DSN panel, shown in Figure 1.
  4. Specify Y in the Execute SQL PA against exported data set field, to invoke Db2 SQL Performance Analyzer against the data set where you are exporting SQL text.
    Access the Export SQL Text to DSN panel when you view operational summaries of activity, exceptional query activity, or in-process activity.

Example

Figure 1. Query Monitor panel to invoke Db2 SQL Performance Analyzer against an exported data set containing SQL
CQM$EXPT--------------- Export SQL Text to DSN ---------------------  

Option  ===> _______________________________________________________      
                                                                     
Export to data set ... _____________________________________________    
                 Member. ________  (Required if data set is a PDS)  
                                                                     
Execute SQL/PA against exported data set Y/N Y                   
                                                                     
Press Enter to process request or PF3/CANCEL to exit