Query logging
For troubleshooting, you may want to log SQL queries to the database.
To enable query logging, open the Configuration Editor and select the Logging configuration. Browse to the node (under ) and set the Enabled attribute to True. Make sure the Log Level attribute is set to Info.
Next, select the node under the node. Again, set the Enabled attribute to True and set the Log Level attribute to Info.
Query logs are written to the CORE.QUERYLOG table in the Infor Operations and Regulations database.
Note: Query logging has a performance impact. It should only be used for troubleshooting, and not in a production environment.