Maximo Open Forum

 View Only

 Not seeing Milliseconds in systemout.log when SQL logging set to INFO- Maximo 7.6.0.9

  • Administration
Pat Galloway's profile image
Pat Galloway posted 05-06-2022 12:01
Hi 
I'm at Maximo 7.6.0.9 and set sql logging  to INFO.  In systemout.log I see sql statements but no Milliseconds on execution time.  Thought I should?  Any additional setting needed to see execution time?  Thanks!
Prashant Sharma's profile image
Prashant Sharma posted 05-07-2022 02:47
Hi Pat,

You need to enable mxe.db.logSQLTimeLimit in System Properties.

This is set to a number of milliseconds and will cause Maximo to log any statement which takes longer than the specified number of milliseconds to execute.
Pat Galloway's profile image
Pat Galloway posted 05-09-2022 13:03
Thank you!

Related Content