Troubleshooting
If you encounter problems while using SQL Tuning Services, use the information in this topic to gather diagnostic information before contacting IBM Support.
- 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. - Download the log from server.
- Download the application.properties, tmsserver_override.properties, and repodb_override.properties files from the TMS_HOME/Config directory.
- Open a support case at https://www.ibm.com/mysupport/s/.
- Attach the log and properties files to the support case.