Skip to Content

Troubleshooting SQL statements (PTF BQU1678 applied)

You can troubleshoot SQL statements for DB2 errors and performance problems. Use the SQL Errors app to identify SQL statements that are generating SQL errors. Use the SQL Analysis app to identify SQL statements with performance problems. 

Overview of the SQL Errors app

The SQL Errors application displays SQL errors captured by APPTUNE for DB2. You can view a list of errors generated on one or more subsystem. You can also drill down to identify the programs and statements that are causing the errors.

The following table lists the actions you can perform in the SQL Errors app.

To

Do

Change the time interval

Select the time interval from the Timeframe drop-down list.

Change the subsystems displayed

Select the subsystems to display from the Filter Subsystems drop-down list.

Refresh the data displayed

Click refresh_app-24.png

View errors for a subsystem

Perform one of the following actions:


    • Click the bar for a subsystem on the bar graph
    • Double-click a row on the list of subsystems

Adjust the time interval for the errors displayed

Click Select_time_interval-24.png

Filter the rows displayed by Plan, Program, or User Name

Click Filter_app_Contents-24.png

Return to previous view

Click back_icon_app-24.png

View list of occurrences of an error code

Perform one of the following actions:

  • Select the error from the Occurrences for Error Code drop-down list
  • Click the section of the pie graph that represents the error code

View the details for an occurrence of an error code

Double-click a row on the list of occurrences

Open the SQL Analysis app

Click SQL_analysis_app-24.png


Overview of the SQL Analysis app

The SQL Analysis application displays a list of the top 100 SQL statements with the highest CPU time for a given subsystem and time period. You can also view the details for a statement.

The following table lists the actions you can perform in the SQL Analysis app.

To

Do

Choose subsystem

Select the subsystem from the Subsystems drop-down list.

Change the subsystems displayed

Select the subsystems to display from the Filter Subsystems drop-down list.

Refresh the data displayed

Click refresh_app-24.png

View details for an SQL statement

Double-click a row on the list of SQL statements

Adjust the time interval for the SQL statements displayed

Click Select_time_interval-24.png

Filter the rows displayed by Plan, or Program

Click Filter_app_Contents-24.png

Return to previous view

Click back_icon_app-24.png

Open the SQL Errors app

Click SQL_errors_app-24.png

This section provides more information about the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Workbench for DB2 12.1