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: Get a debug log for for Netezza connections
Solution

To generate a debug log for Informatica run-time objects (PowerCenter sessions, Informatica DQ mappings, etc.) using Netezza connections (ODBC or native) do the following:

Windows

  1. Edit the ODBC connection
  2. Click on Driver options
  3. Select the check box Enable Debug Logging
  4. Enter a path for Log File Path
    22447_01.JPG 
     

UNIX platforms

  1. Open the file odbcinst.ini and add the following in the [NetezzaSQL] section:
    DebugLogging=true
    LogPath=<path to write file>

    NOTE:

    If the DebugLogging ​entry already exists (as "false"), then change the value to "true".
    Set LogPath to a path that the Informatica user has write permissions.

    Sample entry

    [NetezzaSQL]

    Driver=<Netezza Driver Path>/libnzodbc.so

    Setup=<Netezza Driver Path>/libnzodbc.so

    APILevel=1

    ConnectFunctions=YYN

    Description=Netezza ODBC driver

    DriverODBCVer=03.51

    DebugLogging=true

    LogPath=/tmp

  2. Re-run the session or mapping.

A log file with the name in the format nzodbc_<user><pid>.log will be produced in the LogPath directory.

More Information
​This applies to session connections using both Netezza relational reader and writer as well as Netezza Bulk Reader and Netezza Bulk Writer.
Reference
Applies To
Product: PowerExchange; PowerCenter; Data Quality
Problem Type: Connectivity
User Type: Administrator; Developer
Project Phase: Configure
Product Version: PowerExchange for Netezza
Database: Netezza
Operating System:
Other Software:
Attachments
Last Modified Date:9/16/2020 10:58 AMID:22447
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)