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