Preparing to customize Db2 Query Monitor

Before you customize Db2 Query Monitor for the first time, determine the values that you will need to specify and familiarize yourself with the necessary tasks.

The following checklist lists and describes each significant customization step. Use this checklist to guide you through the entire customization process.

Task Link to detailed instructions Status
Tools Customizer basics
Prior to beginning the customization process, familiarize yourself with Tools Customizer terminology and data sets, and other basic information about Tools Customizer. Tools Customizer terminology  
Software requirements
Verify that your environment meets the minimum software requirements. To install and use Db2 Query Monitor, your environment must be running a supported version of the z/OS operating system and of Db2 for z/OS. Additionally, certain levels of maintenance must be applied. Verify that your environment meets software requirements  
SMP/E installation
Verify that Db2 Query Monitor has been installed correctly. Db2 Query Monitor is installed by using standard SMP/E processing. Verify that Tools Customizer has been installed successfully  
Verify that Tools Customizer for z/OS has been installed correctly. Tools Customizer for z/OS is installed by using standard SMP/E processing. Verify that Tools Customizer has been installed successfully  
Security requirements
Make sure that you have the required authorizations to use Db2 Query Monitor. Verify that your environment meets security requirements  
Prepare to customize collector, ISPF, and CAE components
Perform these additional tasks to prepare for the customization of collector, ISPF, and CAE components Perform the additional tasks described in Preparing to customize collector and ISPF components and Preparing to customize CAE components to prepare your collector, ISPF components, and CAE components for customization.  
Gather data set names
During the customization process, you must specify data set names for the following things:
  • Tools Customizer
  • FEC (common code)
  • Db2 Query Monitor
Worksheets: Gathering required data set names  
APF authorization
The following data sets must be APF authorized:
  • SCQMLOAD
  • SFECLOAD
APF authorizing load libraries  
Gather parameter values
During the customization process, you must specify parameter values for Db2 Query Monitor, for Db2, and for your LPAR. Worksheets: Gathering parameter values for Db2 Query Monitor  
Customize Db2 Query Monitor

Start Tools Customizer by running a REXX EXEC from the ISPF Command Shell panel.

Starting Tools Customizer  

Set up Tools Customizer user settings. If you are running Tools Customizer for the first time, you must modify several user settings to suit your environment. Otherwise, if the user settings that you have already established are still appropriate, skip this step.

Modifying Tools Customizer user settings  

Complete the steps in the appropriate customization roadmap based on the type of customization that you are performing.

Customizing Db2 Query Monitor for the first time

Follow this roadmap if you do not have a customized version of Db2 Query Monitor, and you need to customize it for the first time.

Roadmap: Customizing Db2 Query Monitor for the first time  

Customizing a different version of Db2 Query Monitor

Follow this roadmap if you have already customized a version of Db2 Query Monitor and you want to use the same parameter values to customize a different version.

Roadmap: Customizing new version of Db2 Query Monitor from a previous customization  

Recustomizing Db2 Query Monitor

Follow this roadmap if you have a customized version of Db2 Query Monitor but you want to change one or more parameter values.

Roadmap: Recustomizing Db2 Query Monitor