Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How do I enable extra ETL logging

How do I enable extra ETL logging to capture information when ETL's fail.

1

0 votes



One answer

Permanent link
Got the log4j.properties of the application.
It is located in {RTC_install_folder}/server/conf/<application>

Edit the ETL's section, it should look like snippet below.
Reload the log4j file using a web browser:
https://<server_public_url>/<application_context_root>/admin#action=com.ibm.team.repository.admin.reloadLoggingSettings
Click the 'Reload Log Setting' button.
Reproduce the issue.
A file called '<app>-etl-driver.log' will be generated in the folder with the other logs.

log4j.properties file ETL's section after edit:

################################
#            ETL's             #
################################
#Turn off Rational XML JDBC driver logging by default. This is only needed for troubleshooting the ETLs
#log4j.logger.com.ibm.rational.drivers.jdbc.xml=OFF
#log4j.logger.com.ibm.rational.etl=OFF
#Comment the above 2 lines and uncomment the lines below to turn on logging
log4j.logger.com.ibm.rational.drivers.jdbc.xml=INFO, etlDriver
log4j.logger.com.ibm.rational.etl=INFO, etlDriver
log4j.additivity.com.ibm.rational.drivers.jdbc.xml=false
log4j.additivity.com.ibm.rational.etl=false
log4j.appender.etlDriver=org.apache.log4j.RollingFileAppender
log4j.appender.etlDriver.MaxFileSize=10MB
log4j.appender.etlDriver.MaxBackupIndex=5
log4j.appender.etlDriver.File=logs/ccm-etl-driver.log
log4j.appender.etlDriver.layout=org.apache.log4j.PatternLayout
log4j.appender.etlDriver.layout.ConversionPattern=%d{ISO8601} [%30t] %5p %-50.50c - %m%n

2 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 53
× 15
× 1

Question asked: Apr 16 '14, 12:22 p.m.

Question was seen: 8,256 times

Last updated: Jul 14 '14, 1:14 p.m.

Confirmation Cancel Confirm