Viewing DB2 Object Performance Data in the Investigator › Application Performance Monitoring › SQL Errors

SQL Errors

This application performance activity lets you view current and historical data about application errors that are incurred as a result of abnormal SQL call return codes. You can:

• Use this information to determine which SQL errors are occurring most frequently.
• View all users and programs that encountered the error.
• List all SQL events in date and time order.
• Retrieve SQL text (static or dynamic) for a single subsystem and data sharing group.

No performance trace activity is required for SQL error collection.

Note: You can exclude SQL error conditions that are of no interest to you using profiles in CA Detector to customize the SQL error collection. Additional thresholds are also provided so that you can limit the amount of SQL error information you want retained. For more information about using the collection and reporting facilities of CA Detector, see the CA Detector documentation.

We recommend that you:

• Set a warning threshold to alert you when the total occurrences for a specific SQLCODE equal a specific value.
• Include a note for codes that occur frequently on your systems to help others researching these codes.
• Note solutions that are unique in your environment with the SQLCODE suggestion database.