Identifying errors generated by SQL statements

The view displayed depends on the number of Db2 subsystems selected on the Options dialog box. For a single subsystem, the subsystem detail view displays. For multiple subsystems, the errors by subsystem summary view displays.

By default, the Command Center displays the Options dialog box when you open the SQL Errors app. You can suppress the dialog's display by clearing Always show this panel on startup in the Options dialog box.

(BMC.DB2.SPE2304) BMC AMI Command Center supports BMC AMI Apptune for Db2 Advanced and Standard monitoring modes. When Apptune is in Standard monitoring mode, a value of N/A or -1 is displayed for metrics that are not recorded.

Use the following procedure to view a report of the errors generated by SQL statements for each subsystem selected.

To identify errors generated by SQL statements

1. In the upper left corner of the New console, click Apps.
2. Click SQL Errors .
   The Options dialog box of the SQL Errors application is displayed.
3. In the Options dialog box, perform the following actions:
   1. Select the Subsystems that you need to investigate.

   2. Select the Timeframe in which you want to view SQL Errors from the following options:

      Option	Description
      Default Interval	If you selected a single subsystem, the default interval start and end times are determined by the current APPTUNE interval. If you selected more than one subsystem, the default interval starts at the earliest interval among all active Db2 subsystems defined to the chosen data collector. It ends at the current date and time.
      Last Hour	The results include errors in all APPTUNE intervals within the last hour, based on the server’s time zone.
      Last 24 Hours	The results include errors in all APPTUNE intervals within the last 24 hours, based on the server's time zone.
      Today	The results include errors in all APPTUNE intervals since midnight, based on the server's time zone.
      Yesterday (BMC.DB2.SPE2401)	The results include errors in all APPTUNE intervals within the 24 hours before midnight, based on the server's time zone.

   3. Click OK.
      The view displayed depends on the number of subsystems selected. If you selected a single subsystem, the subsystem detail view is displayed (continue with step 6). If you selected multiple subsystems, the errors by subsystem summary view is displayed.
4. From the Timeframe list, select an interval to adjust the time frame in which you are investigating errors. If you select Custom Interval, the Time Intervals dialog box is displayed. For more information, see  Selecting-the-time-interval-for-SQL-apps.

5. Open the subsystem detail view by:

   • Clicking the subsystem's bar on the bar chart. If you select a data-sharing group, the app displays the errors for all the subsystems in the group.
   • Double-clicking the subsystem's row on the grid. If you select a subsystem in a data-sharing group, the app displays the errors for the subsystem selected.
   • Selecting the subsystem's row on the grid and clicking Details. If you select a subsystem in a data-sharing group, the app displays the errors for the subsystem selected.

   The subsystem detail view is displayed. This view includes a pie chart that displays the proportion of all SQL errors found in the subsystem. This view also consists of a grid, below the pie-chart, that shows the occurrences for an error number. The grid defaults to the first error found in ascending order.

6. Select the error number that you are investigating from the Occurrences for Error Code list. Alternatively, you can select the error number by clicking on the appropriate section of the pie chart.
   (BMC.DB2.SPE2410) To view a list of occurrences of all error codes, select All from the Occurrences for Error Code list.
7. From the Timeframe list, select an interval to adjust the time frame in which you are investigating errors. If you select Custom Interval , the Time Intervals dialog box is displayed. For more information, see Selecting-the-time-interval-for-SQL-apps.

8. Click Filter  to restrict the results displayed based on one or more of the following fields:

   • Plan
   • Program
   • User Name
   • Client Application

   If you add a filter, BMC AMI Command Center displays  next to the title of the results pane and changes the color of the filter icon (). 
   For more information, see Filtering-the-result-set-for-an-SQL-app.
   (BMC.DB2.SPE2404) To clear the filters, click Clear all filters .

9. (Optional) Click Summary to view statistics such as error count, calls count, and commits that the app displays on the errors by subsystem summary view.
10. To view the details for a row:
    1. Select the row and click Details
    2. Double-click the row
11. Click  to return to the subsystem detail view.
12. (Optional) Click  to update the information displayed in the subsystem detail view.
13. (Optional) Click Options  to open the Options dialog box and select new search options.
14. Click    to return to the errors by subsystem view.
15. (Optional)  Click   to update the information displayed in the errors by subsystem view.