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.
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 |
|
Refresh the data displayed | Click . |
View errors for a subsystem | Perform one of the following actions:
|
Adjust the time interval for the errors displayed | Select the time interval from the Timeframe list. |
Filter the rows displayed by:
| Click . |
Return to the previous view | Click . |
View a list of occurrences of an error code | Perform one of the following actions:
|
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 |
|
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. |
Click . | |
Export the list of SQL statements currently displayed |
|
Return to the previous view | Click . |
Suppress the display of the Options dialog box |
|
Open the SQL Errors app | Click . |
This section provides more information about the following topics:
Comments
Log in or register to comment.