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.

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 .
    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:

      OptionDescription
      Default IntervalIf 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 HoursThe results include errors in all APPTUNE intervals within the last 24 hours, based on the server's time zone.
      TodayThe 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  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  to return to the subsystem detail view.
  12. (Optional) Click  to update the information displayed in the subsystem detail view.
  13. (SPE2104) (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.
 Classic console
  1. In the upper right corner of the Classic console, click Apps.
  2. Click SQL Errors .
    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  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  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  to return to the subsystem detail view.
  11. (optional) Click  to update the information displayed in the subsystem detail view.
  12. Click  to return to the errors by subsystem view.
  13. (optional) Click  to update the information displayed in the errors by subsystem view.



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

Comments