Skip to Content

Filtering the result set for an SQL app

Related topics

Troubleshooting SQL statements

Identifying errors generated by SQL statements

Identifying performance issues in SQL statements

You can filter a result set in the SQL Errors and SQL Analysis apps to limit the rows displayed.

To filter the result set

  1. Click Filter  Filter_app_Contents-24.png.
    The Filters dialog box is displayed. 
  2. (Optional) Click Clear to empty all the fields in the dialog box.

  3. Enter values in one or more of the following fields:

    • Plan
    • Program
    • User
    • Client Application
    • Text Hash (SQL Analysis app only)

    The app displays a row only if it matches the values in all the fields in which you entered values. You can use the asterisk (*) or percent sign (%) wildcards as the last character in all fields except the Text Hash field.  

  4. Perform one of the following actions:
    1. Click OK to save your changes.
      BMC AMI Command Center refreshes the rows displayed in the application and lists the filter values entered in the dialog box at the top of the page.
    2. Click Cancel to return to the application without saving your changes.
       

 

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

BMC AMI Command Center for Db2 13.2.00