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:
- On the database server, connect to the database, on which
you activated the license and enabled the Index Advisor stored procedure.
- 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)
- 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