Troubleshooting

If you encounter problems while using SQL Tuning Services, use the information in this topic to gather diagnostic information before contacting IBM Support.

  1. Locate the log information in the TMS_HOME/logs directory for the period of time when problem occurred.

    If you are able to re-create the problem, enable detailed logging by setting logger.ibm.appenderRef.rollingFileInfo.ref=rollingFileDebug. Then restart SQL Tuning Services and perform the actions that cause the problem to occur.

  2. Download the log from server.
  3. Download the application.properties, tmsserver_override.properties, and repodb_override.properties files from the TMS_HOME/Config directory.
  4. Open a support case at https://www.ibm.com/mysupport/s/.
  5. Attach the log and properties files to the support case.