Search code examples
informatica-powercenterinformatica

Reduce sessions' log size

We have a session that process a millions of rows. The problem is that it creates a huge log with two main issues:

  1. Log size makes it hard to handle and analize.
  2. Log size slows down the process (we guess, since the log is >55 GB).

There is a way to reduce the size of the log? We don't need to know every time the application does a commit for instance.

Solution

  • You can set the log level to Terse, which will get your log size to minimal. (setting in session configuration).

    The downside of setting Terse is that you wont get lot of information when something goes wrong and you want to find something in log.

    To change the log level:

    • Open your session (double click on it in your workflow, unless its a reusable session)
    • Go to the Config Object tab
    • Select appropriate value from the Override tracing drop-down list (it allows you to control the logging level of the session as a whole; if you want, you can override the individual components' log level in the Components tab)