Preparing to customize SQL PA
Before you start to customize SQL PA, determine all of the customization values that you need to specify during the customization process, and familiarize yourself with all of the customization 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 reference | |
| Software requirements | ||
Verify that your environment meets the minimum software requirements.
|
Verify that your environment meets software requirements | |
| SMP/E installation | ||
| Verify that Db2 SQL Performance Analyzer has been installed correctly. Db2 SQL Performance Analyzer is installed by using standard SMP/E processing. | Verify that Db2 SQL Performance Analyzer 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 | |
| Db2 components | ||
| Verify that the DSNTIAD sample program, which is used to run SQL statements, is available. | None. | |
| Plan table configurations for Db2 EXPLAIN output | ||
| Understand the differences between generic, alternative, or unique EXPLAIN plan tables. | Plan table configurations for Db2 EXPLAIN output | |
| Db2 SQL Performance Analyzer stored procedure requirements | ||
| Ensure that the requirements for using the stored procedures are met. | Requirements for using the SQL Performance Analyzer stored procedures | |
| Gather data set names | ||
During the customization process, you must specify names for the following
types of data sets:
|
Worksheets: Gathering required data set names | |
| Gather parameter values | ||
| During the customization process, you must specify parameter values for Db2 SQL Performance Analyzer, for Db2, and for your LPAR. | Worksheets: Gathering parameter values for Tools Customizer | |
| Customize Db2 SQL Performance Analyzer | ||
|
Start Tools Customizer by running a REXX EXEC from the ISPF Command Shell panel. |
Tools Customizer reference | |
|
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. |
Tools Customizer reference | |
|
Complete the steps in the appropriate customization roadmap based on the type of customization that you are performing. |
||
|
Customizing Db2 SQL Performance Analyzer for the first time Follow this roadmap if you do not have a customized version of Db2 SQL Performance Analyzer and you need to customize it for the first time. |
Roadmap: Customizing Db2 SQL Performance Analyzer for the first time | |
|
Customizing a different version of Db2 SQL Performance Analyzer Follow this roadmap if you have already customized a version of Db2 SQL Performance Analyzer and you want to use the same parameter values to customize a different version. |
Roadmap: Customizing a new version of Db2 SQL Performance Analyzer from a previous customization | |
|
Recustomizing Db2 SQL Performance Analyzer Follow this roadmap if you have a customized version of Db2 SQL Performance Analyzer but you want to change one or more parameter values. |
Roadmap: Recustomizing Db2 SQL Performance Analyzer | |
|
Some customization options require you to manually complete additional tasks after you have used Tools Customizer. If you generated jobs in Tools Customizer that correspond to the following customization options, complete the additional tasks before you submit the jobs. In some cases, an optional task can be completed either by using Tools Customizer or by manually completing tasks without using Tools Customizer. |
||
| Optional: Creating generic plan tables | ||
| Create secondary authorization IDs that will act as the owners of the generic Db2 SQL Performance Analyzer plan tables. | Optional: Creating generic plan tables | |
| Optional: Interfacing with Db2 Query Monitor | ||
| Enable Db2 SQL Performance Analyzer to interface with Db2 Query Monitor. | Optional: Interfacing with Db2 Query Monitor | |
| Optional: Adding SQLPA to Db2 Administration Tool launch pad | ||
| Add Db2 SQL Performance Analyzer to the Db2 Admin Launchpad. | Optional: Adding SQLPA to Db2 Administration Tool launch pad | |
| Optional: Integrating SQLPA with Db2 Administration tool catalog | ||
| Integrate Db2 SQL Performance Analyzer to the Db2 Admin Catalog. | Optional: Integrating SQLPA with Db2 Administration tool catalog | |
| Optional: Configuring Db2 SQL Performance Analyzer for use with QMF | ||
| Create the interface between Db2 SQL Performance Analyzer and QMF, and customize the interface by modifying the parameters that define the target host system. | Optional: Configuring Db2 SQL Performance Analyzer for use with QMF | |
| Optional: Set up ANLCSPA for use from Browse or Edit sessions | ||
| Either use Tools Customizer to generate the job or run the ANLCALLC CLIST. | Optional: Set up ANLCSPA for use from Browse or Edit sessions | |
| Optional: Enabling the stored procedure customization for Db2 SQL Performance Analyzer | ||
| Customizing and calling the stored procedure address space startup procedure. | Optional: Enabling the stored procedure customization for Db2 SQL Performance Analyzer | |