Deactivating Verbose Session Logging

By default, Informatica PowerCenter enables netty debug logging, which may produce excessive messages in the PowerCenter session log when using the VMware Greenplum Connector for Informatica.

To deactivate verbose session logging, you must configure an Informatica PowerCenter JVM log4j property.

Process

Follow these instructions to deactivate verbose session logging for the PowerCenter JVM. You will create an XML-format log4j configuration file and add a custom JVM property to Informatica PowerCenter that references this configuration file.

1. Identify a file system location for the configuration file. For example, you may choose c:\Users\gpadmin\gpiccfg\log4j.xml.

2. Open the file in the editor of your choice.

3. Copy/paste the following into log4j.xml:

   <?xml version="1.0" encoding="UTF-8"?>
   <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
   <log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">
      <appender name="console" class="org.apache.log4j.ConsoleAppender">
         <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n" />
         </layout>
      </appender>
      <root>
         <level value="OFF" />
         <appender-ref ref="console" />
      </root>
   </log4j:configuration>
   

4. Save the file and exit the editor.

5. Access the Informatica Administrator console using your Web browser. For example, access http://<informatica-server-address>:6008/administrator and log in with administrator credentials.

6. From the Domain Navigator, select the domain in which you have deployed the Integration Service.

7. Select the Properties tab.

8. Scroll down to the Custom Properties drop-down and expand.

9. Add a new custom property by pressing the New… button in the Custom Properties dialog.

10. Specify the property name JVMOption, the configuration option named -Dlog4j.configuration, and the file system path to the log4j.xml configuration file that you created earlier in this procedure. For example:

    Field	Value
    Name	JVMOption1
    Value	-Dlog4j.configuration=file:c:\Users\gpadmin\gpiccfg\log4j.xml

11. Save and exit the new property dialog.

The logs generated by subsequent Workflow sessions are less verbose.