Troubleshooting SQL PA

Use this information to diagnose and correct problems that you experience with Db2 SQL Performance Analyzer.

Gathering diagnostic information
Before you report a problem with SQL Performance Analyzer to IBM® Software Support, you need to gather the appropriate diagnostic information.
Resetting the Db2 SQL Performance Analyzer REGISTRY
Db2 SQL Performance Analyzer includes a cleanup mechanism that resets all the SQL PA entries in the REGISTRY to their original status.
TSO interfacing notes for installers
The following topics contain special TSO interfacing notes for installers.
Applying user indexes to tables
To improve Plan Table performance, apply user indexes to three system catalog tables.
Problems with missing module DSNACAB
SQLPA load library SANLLOAD must not be APF authorized.