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.

Related topics

Tuning SQL

Using

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 subsystems. You can also drill down to identify the programs and statements that are causing the errors.

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

Purpose	Action
Change the time interval	Select the time interval from the Timeframe list.
Change the subsystems displayed (SPE2104)	Click Options . Select the Subsystems that you need to investigate. Click OK.
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	Select the time interval from the Timeframe list.
Filter the rows displayed by: Plan Program User Name Client Application (SPE2010)	Click .
Return to the previous view	Click .
View a list of occurrences of an error code	Perform one of the following actions: Select the error from the Occurrences for Error Code 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.
Suppress the display of the Options dialog box (SPE2104)	Click Options . Clear Always shows this panel on startup. Click OK.
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 that you can perform in the SQL Analysis app:

Purpose	Action
Choose subsystem	Select the subsystem from the Subsystems 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	Select an interval from the Timeframe list.
Filter the rows displayed by: Plan Program User Name (SPE2010) Client Application (SPE2010)	Click .
Export the list of SQL statements currently displayed (BMC.DB2.SPE2210)	Click Generate Report Select one of the following options: CSV - With SQL text preview CSV - With full SQL text PDF Based on your browser settings, after Command Center generates the report, either the Save As dialog is displayed or the browser saves the file automatically. Enter a name for the report Click Save
Return to the previous view	Click .
Suppress the display of the Options dialog box (SPE2104)	Click Options . Clear Always show this panel on startup. Click OK.
Open the SQL Errors app	Click .

This section provides more information about the following topics:

Troubleshooting SQL statements

Overview of the SQL Analysis app

Comments