×
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
 
 

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.

BMC AMI Command Center for Db2 12.1 ... Using Troubleshooting SQL statements

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 ().
  2. (Optional) Clear all selected intervals by performing the following steps:
    1. Click .
      The Time Intervals dialog selects all displayed intervals.
    2. Click .
      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



Was this page helpful? Yes No Submitting... Thank you
Last modified by Sarig Scudder on Mar 29, 2021
task using spe2104

Comments

Identifying performance issues in SQL statements
Filtering the result set for an SQL app
© Copyright 2013 - 2021 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2021 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.