Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Enable ODBC tracing on a Windows machine, in Informatica Cloud (ICS)
Solution
To enable ODBC tracing on Windows, follow these steps for IICS:
  1. Copy the files dwtrc27.dll, dwicu27.dll from $AGENT_HOME\drivers\odbc\datadirect\r31 to C:\windows\system32\
  2. Open 'ODBC Data Source Administrator' (odbcad32.exe) utility in C:\windows\system32\
  3. Go to the Tracing tab and configure 'Custom Trace DLL' to C:\windows\system32\dwtrc27.dll
  4. Configure a convenient location for the 'Log File Path'. Click on Apply and save the changes.
  5. ODBC.PNG
  6. Open the Windows Registry editor. Windows > Run > regedit
  7. Navigate to HKEY_CURRENT_USER / Software / ODBC / ODBC.INI / ODBC.
  8. Right click> New > String Value: Value name = TraceOptions, Value data = 3KB_513459_RegEdit.png

  9. Click on Start Tracing Now option in the ODBC Administrator.
  10. Perform the operation to be traced in Informatica Cloud - Run a task, fetch metadata etc.
  11. Once the operation is complete, click on 'Stop Tracing Now' in the ODBC Administrator.
The ODBC Trace log file(s) are generated in the configured Log File Path directory. 
​​​​​​
More Information
  • Steps 6-8 are highly recommended, but can be omitted if required. Setting TraceOptions to 3 ensures the ODBC trace contains important information for e.g. PID of the process, Timestamps etc.
  • If the user performing the steps is different from the user account configured to start the Informatica Service, Start the Informatica Agent as the current user. Detailed steps in KB 510410​​.
  • Before making changes to the Windows Registry, it is recommended to take a backup of the current contents.
    https://support.microsoft.com/en-in/help/322756/how-to-back-up-and-restore-the-registry-in-windows​
  • Do NOT forget to Stop the tracing, once the required logs are collected. Enabling ODBC tracing impacts all ODBC operations performed by the current user and slows down performance. To stop tracing, click on the button 'Stop Tracing Now'.
Reference
​KB 524247 - HOW TO: Enable ODBC Tracing for ODBC connection in a Linux Informatica Cloud Secure Agent
KB 518935 - HOW TO: Enable ODBC trace for Oracle/SQL Server connection in a Linux Informatica Cloud Secure Agent
Applies To
Product: Cloud Data Integration
Problem Type: Configuration; Connectivity; Crash/Hang
User Type: Developer
Project Phase: Implement; Configure
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:8/10/2020 2:50 AMID:513459
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)