Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Command Center for Db2 13.2

Identifying errors generated by SQL statements

The SQL Errors app displays a summary of the number of errors encountered by subsystem. The app defaults to displaying a summary of errors based on the selections in the Options dialog box for the app. The SQL Errors app displays the following views:

  • Errors by Subsystem summary 
  • Subsystem detail
  • Statement detail

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.

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

New console
  1. In the upper left corner of the New console, click Apps.
  2. Click SQL Errors NW_sql_exclamation_triangle_orange.png.
    The Options dialog box of the SQL Errors application is displayed.

  3. (SPE2104)

     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.

    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. (SPE2104)

     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 you are investigating from the Occurrences for Error Code drop-down. Alternatively you can select the error number by clicking on the appropriate section of the pie chart.

  7. (SPE2104)

     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 Filter_app_Contents-24.png to restrict the results displayed based on one or more of the following fields:

    • Plan
    • Program
    • User Name

    • Client Application (SPE2010)

    For more information, see Filtering-the-result-set-for-an-SQL-app.

  9. (SPE2104)

     (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 back_icon_app-24.png to return to the subsystem detail view.
  12. (Optional) Click refresh_app-24.png to update the information displayed in the subsystem detail view.

  13. (SPE2104)

     (Optional) Click Options NW_gear.png to open the Options dialog box and select new search options.

  14. Click  back_icon_app-24.png  to return to the errors by subsystem view.
  15. (Optional)  Click  refresh_app-24.png to update the information displayed in the errors by subsystem view.
Classic console
  1. In the upper right corner of the Classic console, click Apps.
  2. Click SQL Errors sql_errors_app_64.png.
    The SQL Errors application is displayed in a second tab.
  3. Select the Timeframe in which you want to view SQL errors.
    The bar graph and list for the selected time frame is displayed.
  4. Select the DB2 subsystems you need to investigate using the Filter Subsystems drop-down.
    The bar chart, displaying only the selected subsystems, is refreshed. The subsystems shown in the grid are not filtered.

  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 you are investigating from the Occurrences for Error Code drop-down. Alternatively you can select the error number by clicking on the appropriate section of the pie chart.
  7. Click Filter time interval Select_time_interval-24.png to adjust the time frame in which you are investigating errors. For more information, see Selecting-the-time-interval-for-SQL-apps.

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

    • Plan
    • Program
    • User Name

    For more information, see Filtering-the-result-set-for-an-SQL-app.

  9. To view the details for a row:
    1. Select the row and click Details
    2. Double-click the row
  10. Click back_icon_app-24.png to return to the subsystem detail view.
  11. (optional) Click refresh_app-24.png to update the information displayed in the subsystem detail view.
  12. Click back_icon_app-24.png to return to the errors by subsystem view.
  13. (optional) Click refresh_app-24.png to update the information displayed in the errors by subsystem view.

Related topic

Troubleshooting-SQL-statements



 

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