To enable JDBC tracing on a connection database configured in Informatica Administrator so that it generates a spy log, do the following:
1. Login to Informatica Administrator with Administrator permissions.2. Click on "Connections" button.3. Locate the database connection in which you want to set JDBC tracing.4. Edit the "Metadata Access Properties".5. Add the following string at the end of the connection string as follows:
To disable JDBC tracing that is not required anymore or as suggested by Informatica Global Customer Support, remove the string from the connection as follows:
Enabling JDBC tracing does not require any reboot of Informatica service or any node shutdown.
KB 174411 Human task failed with:" nested exception is javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction."
HOW TO: Enable/Disable logging (KB 308336)
What can we do to improve this information (2000 or fewer characters)