Deactivating the product license and the Index Advisor stored procedure for Optim Query Tuner for DB2 for Linux, UNIX, and Windows

You can deactivate the product license and the Index Advisor stored procedure for Optim™ Query Tuner for DB2® for Linux, UNIX, and Windows, and uninstall the files that were created when you ran the installation program.

Procedure

To deactivate the license and the stored procedure and uninstall the installation files:

  1. On the database server, connect to the database, on which you activated the license and enabled the Index Advisor stored procedure.
  2. Run the following commands to deactivate the license and the stored procedure:
    DROP FUNCTION DB2OE.QT_LIC
    DROP PROCEDURE DB2OE.CALLDB2ADVIS
    CALL SQLJ.REMOVE_JAR(DB2OE.CALLDB2ADVIS)
  3. Manually delete the installation directory that was created when you ran the installation program. By default, the installation directory is in the following locations.
    • On Windows: C:\Program Files\IBM\OQTS
    • On Linux or UNIX: /opt/IBM/OQTS

Feedback