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

Selecting the time interval for SQL apps

Use the Time Intervals dialog to select the custom time period in which you need to investigate SQL errors or SQL performance issues. You can select multiple contiguous rows that define the start and end time used to display information in the applications. Use the following procedure to select the custom time interval for the SQL Errors or SQL Analysis applications.

To select the time interval for SQL apps

  1. (SPE2104)

     From the Timeframe list, select Custom Interval.
    The Time Intervals dialog is displayed with the current intervals already selected (CheckedSign-24.png).

  2. (Optional) Clear all selected intervals by performing the following steps:
    1. Click MinusSign-24.png.
      The Time Intervals dialog selects all displayed intervals.
    2. Click CheckedSign-24.png.
      The Time Intervals dialog clears all displayed intervals.
  3. To display additional intervals, click Show More. The Time Interval dialog refreshes the display the with additional intervals. If no additional rows are available Show More is disabled.
  4. Select the interval rows within the time period you want to investigate. Selected rows must be contiguous. The Time Interval dialog will automatically select any cleared rows between the row you selected and another row already selected.
  5. Click OK to save your changes.
  6. Click Cancel to return to the application without saving your changes.

Related topic

Troubleshooting-SQL-statements



 

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