IBM Support

Creating a SQL Log File to Troubleshoot Problems

Question & Answer


Question

Is there a way to turn on and create a log file using the front-end Logging application?

Answer

Steps:

1. Go to the Logging application.

2. From the "Select Action" menu, select "Manage Maximo Root Logger".





3. Click on the book icon next to the Appenders field.





4. Select "Rolling".



5. Click OK.

6. From the "Select Action" menu, "Apply Settings".


To log all SQL statements the SQL logger in the Logging application should be set to INFO:



7. From the "Select Actions" menu, "Apply Settings".

8. From the "Select Actions" drop down and select "Set Logging Root Folder".

9. Enter a valid path in the "Set Logging Root Folder" field.




10. Click OK.

11. From the "Select Actions" menu, "Apply Settings".


12. Restart the application server for this change to take effect.

13. Perform some operations in Maximo.

14. Check that a Maximo log has been created in the root logging folder.




SQL statements have been recorded in the log:




Turning on the SQL logger may put 3-4% overhead on performance. After replicating the problem and collecting SQL logs, please set the logging level back to ERROR so it will not affect performance.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"System Related","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"Edition Independent","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWK4A","label":"Maximo Asset Management Essentials"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21385917