Skip to Content

Clearing an SQL Viewer

Use this task when you want to purge information from an SQL Viewer.

Before you begin

You must stop an active viewer before you can clear it. To do this, select the Stop SQL Viewer command from the SQL Viewer instance menu.

Clearing a viewer enables you to free up space and continue collecting SQL data. This action is useful for providing continuity when you are monitoring the same application or the same user. If you want to change the criteria that you are using to monitor for SQL activity, you should delete the viewer and create a new viewer.

Additionally, clearing an SQL Viewer does not free up all the space used by the viewer. Only the buffer that holds the data associated with the viewer is cleared. Dropping a viewer frees all the space being used by the viewer.

Warning

Note

It might be useful to retain the collected SQL information before purging. To retain the information, select the Write to Report option from the SQL Viewer Information dialog box.

To clear an SQL Viewer

  1. Double-click the SQL_VIEWER icon to display the SQL Viewer instance icons.
  2. Right-click the SQL Viewer instance icon and select Clear SQL Information.

  3. When the confirmation message appears, click OK.

    Warning

    Note

    To restart the SQL monitoring process after clearing a viewer, use the Start SQL Viewer command.

 

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

BMC PATROL for DB2 Universal Database 9.0