Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Troubleshooting SQL statements

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 BMC AMI 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.

ToDo
Change the time intervalSelect the time interval from the Timeframe drop-down list.
Change the subsystems displayedSelect the subsystems to display from the Filter Subsystems drop-down list.
Refresh the data displayed

Click

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

Filter the rows displayed by:

  • Plan
  • Program
  • User Name
  • Client Application (SPE2010)

Click

Return to previous view

Click

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 codeDouble-click a row on the list of occurrences
Open the SQL Analysis app

Click


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.

ToDo
Choose subsystemSelect the subsystem from the Subsystems drop-down list.
Change the subsystems displayedSelect the subsystems to display from the Filter Subsystems drop-down list.
Refresh the data displayed

Click

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

Filter the rows displayed by:

  • Plan
  • Program
  • User Name (SPE2010)
  • Client Application (SPE2010)

Click

Return to previous view

Click

Open the SQL Errors app

Click

This section provides more information about the following topics:

Was this page helpful? Yes No Submitting... Thank you

Comments