Configuring Database Activity Logging

You turn on various types of database information logging through the dblog.cfg file.

The file is delivered with a pound sign (#) character to comment lines out, or turn off some features. To enable this feature, be sure to remove the # character.

  1. Open the $LACFGDIR/dblog.cfg file in a text editor.
  2. Configure DEBUG logging by entering values for the following parameters:
    Parameter Description
    DEBUG

    True or False

    If DEBUG is true, lads logging gathers database debug information. The default logging level is TRACE.

    DEBUGLEVEL can be set to override the default level.
    DEBUGLEVEL

    level

    When DEBUG is enabled, this entry sets the logging level. DEBUGLEVEL defaults to TRACE. For more information, see Log Level Values
  3. Configure database driver error logging by entering a value for the following parameter:
    Parameter Description
    LADBLOGLEVEL

    level

    Where level is the minimum logging level, e.g (none, fatal, warning, info, trace, sql, timestats, all, etc) for messages. These can also be the integer level equivalents.

    LADBLOGLEVEL defaults to DBLog.ERROR as before. Controls logging level for messages to ladb.log

    Log Level Values
  4. Configure TIMESTATS performance logging by entering values for the following parameters:
    Parameter Description
    TIMESTATS

    True or False

    If TIMESTATS is true, lads logging gathers timed statistics information to analyze performance.
    TIER

    DBI, OPF, or ALL

    A comma-separated list of Tiers (data processing levels) logging is turned on for.
    DATAAREAS

    A comma-separated list of data areas logging is turned on for.

    For example, the line DATAAREAS=procurement,gen filters out everything except database activity in the procurement and gen data areas.
    USERS A comma-separated list of actors that logging is turned on for.
    PROGRAMS A comma-separated list of programs that logging is turned on for.
  5. Specify the output directory for the log by entering a value for the DIR parameter:
    Parameter Description
    DIR

    A complete directory path that indicates where log files will be kept.

    If this entry is commented out or left blank, log files will be written to $LALOGDIR. All files will be prefixed with DBLog.debug or DBLog.timestats.
  6. Save and close the file.
  7. Once you change this file, you need to restart any Infor Landmark Technology products and your application server to implement the change.