Uninstalling custom queries on the Tivoli Enterprise Portal Server

To uninstall the IBM® Tivoli® Monitoring Scope sensor configuration, you must uninstall custom queries on the Tivoli Enterprise Portal Server.

The custom queries can be removed by running the uninstall query, uninstall_zkd7.sql. On the TADDM DVD, this query is in the TEPS_Query.zip file in the /itm-discovery-support directory.

To uninstall the custom queries on the Tivoli Enterprise Portal Server, complete the following steps:
Uninstall on Linux® operating system:
  1. Log in to the Tivoli Enterprise Portal Server, and copy the TEPS_Query.zip file to a local directory.

    In these instructions, the TEPS_Query.zip file is copied to the /tmp/teps directory and extracted. The uninstall_zkd7.sql file is then located in the /tmp/teps directory.

  2. Run the uninstall query:
     /opt/IBM/ITM/bin/itmcmd execute cq
     "/opt/IBM/ITM/li6263/cq/bin/KfwSQLClient -d KFW_DSN
     –f /tmp/teps/uninstall_zkd7.sql"
  3. Stop the Tivoli Enterprise Portal Server:
    /opt/IBM/ITM/bin/itmcmd agent stop cq
  4. Start the Tivoli Enterprise Portal Server:
    /opt/IBM/ITM/bin/itmcmd agent start cq
Uninstall on Windows operating system:
  1. Log in to the Tivoli Enterprise Portal Server, and copy the TEPS_Query.zip file to a local directory.

    In these instructions, the TEPS_Query.zip file is copied to the c:\TEMP\TEPS directory and extracted. The uninstall_zkd7.sql file is then located in the c:\TEMP\TEPS directory.

  2. Change to the directory where the Tivoli Enterprise Portal Server is installed:
    cd c:\IBM\ITM\CNPS
  3. Run the uninstall query (supports all platforms):
    .\kfwsqlclient.exe /d KFW_DSN /f c:\TEMP\TEPS\uninstall_zkd7.sql
  4. From the Tivoli Monitoring Services window, restart the Tivoli Enterprise Portal Server.