Canceling an SQL optimization exploration process

Edit online

You can cancel the SQL optimization exploration process should the need arise.

Before you begin

In order to cancel the SQL optimization process, you must have IBM® Z Database Assistant SQL optimization administrator authority and have READ access for the DB2ZAI.ADMIN RACF profile when RACF user interface access control is enabled.

About this task

If your SQL optimization exploration process gets stuck, you might need to manually cancel the process. Explorations might get stuck while in progress or in the Exploration requested status if too many explorations are in the queue.

Procedure

To cancel an SQL optimization exploration process:

  1. Open the SQL tuning tab of the connection for which you want to cancel an exploration.
    By default, the Top SQL statement is displayed, which shows the SQL statements that are using the most CPU resource.
  2. Location the statement for which you want to cancel the exploration.
  3. Click Cancel in the Actions column.