Guru Of Geeks

Netezza ODBC config in Linux 1) Configuration ODBC Modify .odbc.ini file under $DSHOME and add 2 entries:

Use ODBC trace when a problem is encountered with a component that uses ODBC to get at data sources. This includes the following components: ODBC Connector (DataStage Parallel Jobs) ODBC Enterprise Stage (DataStage Parallel Jobs) ODBC Stage (DataStage Server Jobs) Information Analyzer Since collection of ODBC trace can affect performance, enable ODBC trace before you re-run a job or repeat a task. Disable ODBC trace as soon as possible. Problems with metadata import in Information Analyzer If you are collecting ODBC trace because of problems with metadata import in Information Analyzer, restart the ASB Agent service after enabling or disabling the trace.  To do so, follow these instructions: