Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Enable/Disable JDBC Tracing on a Connection Database
Solution

​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:


    SpyAttributes=(log=(file)\\your_server_path\\spy_NAME.log ;linelimit=220;logTName=yes;timestamp=yes);

 

 syp_connection.png

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:

   SpyAttributes=(log=(file)\\your_server_path\\spy_NAME.log ;linelimit=220;logTName=yes;timestamp=yes);

no_syp_connection.png

More Information


Enabling JDBC tracing does not require any reboot of Informatica service or any node shutdown.

Reference
Applies To
Product: Data Quality; PowerCenter; Data Engineering Integration(Big Data Management); Data Engineering Quality(Big Data Quality)
Problem Type: Configuration; Product Feature
User Type: Administrator
Project Phase: Configure; Implement
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:6/30/2020 6:17 AMID:174433
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)