TEPS database export

Workspace definitions, queries, and the like are kept in the TEPS database that resides on the server with your Tivoli® Enterprise Portal Server. Support may ask for an export of this data or it might be suggested in the problem determination matrix. To get an exported copy of the data:

Windows systems

Navigate to the CNPS subdirectory and enter this command: migrate-export. This script generates a file named saveexport.sql in the c:\ibm\itm\cnps\sqllib subdirectory. It contains all the Tivoli Enterprise Portal Server data.

UNIX or Linux systems

Navigate to /opt/IBM/ITM/bin and run the following command: ./itmcmd execute cq "runscript.sh migrate-export"

This script generates a file named saveexport.sql in the /opt/IBM/ITM/$platform/cq/sqllib subdirectory. It contains all the Tivoli Enterprise Portal Server data, where $platform is one of the following:

  • li6243 or li6263 for Intel(R) Linux
  • ls3263 for zSeries(R) Linux
  • aix533 for AIX®