How To
ForgeRock Identity Platform
Does not apply to Identity Cloud

How do I enable database logging in IDM (All versions)?

Last updated Jan 12, 2023

The purpose of this article is to provide information on enabling database logging in IDM. Database logging is useful for troubleshooting query related performance issues.

Enabling database logging

You can enable database logging by amending the file (located in the /path/to/idm/conf directory).


All the examples show the level being set to FINEST, which is the most detailed logging level and recommended for troubleshooting; however, you can also set them to FINER, FINE, CONFIG, INFO, WARNING and SEVERE (least detailed) to achieve different levels of logging.

You can change the global logging level to FINEST (although this affects all logging) by amending the .level value as follows:


Alternatively, you can set logging levels for specific items to override the global level:

  • To set logging to FINEST for JDBC databases only, you can add the following line: org.forgerock.openidm.repo.jdbc.level = FINEST
  • Where the logging entries are being generated by the Microsoft® SQL driver rather than IDM, you need to add the following line instead: = FINEST

See Also

How do I enable debug logging and log rotation for the .NET Remote Connector Server (RCS)?

How do I add logging to JavaScript files in IDM (All versions)?

How do I add logging to Groovy scripts in IDM (All versions)?

Related Training

ForgeRock Identity Management Deep Dive (IDM-420)

Related Issue Tracker IDs


Copyright and Trademarks Copyright © 2023 ForgeRock, all rights reserved.