Error connecting to NZ using ODBC
Posted: Thu Jan 07, 2010 4:47 pm
Hello...
I am trying to configure ODBC to read a table on Netezza Database. Actually I am not even able to connect to the Database....
Executing the "example" script in branded_odbc results in this error. I am able to connect to Netezza database from AIX.
[turks: isadmin8 :/opt/IBM/InformationServer/Server/branded_odbc/example] example
example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : NZDEVSTG
Enter the user name : nz_usr
Enter the password : nz_pwd
Illegal instruction (core dumped)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
and when I tried to use DS_CONNECT here is the error
>DS_CONNECT NZDEVSTG
Enter username for connecting to 'NZDEVSTG' DBMS [isadmin8]: nz_usr
Enter password for stgdev:nz_pwd
Abnormal termination of DataStage.
Fault type is 4. Layer type is BASIC run machine.
Fault occurred in BASIC program DS_CONNECT at address adc.
Illegal instruction (core dumped)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steps I performed after installing the NZ odbc driver and Data Direct :
Step-1: Updated odbc.ini
[NZDEVSTG]
Driver = /usr/nps/kit/lib/libnzsqlodbc3_64bit.so
Description = Netezza CDM Dev Database
Servername = dinar
Port = 5480
Database = cmdev01
Username = nz_usr
Password = nz_pwd
ReadOnly = false
ShowSystemTables = true
LegacySQLTables = false
LoginTimeout = 0
QueryTimeout = 0
DateFormat = 1
NumericAsChar = false
SQLBitOneZero = false
StripCRLF = false
Step-2: Updated uvodbc.config in both Project and DSEngine directories.
<NZDEVSTG>
DBMSTYPE = ODBC
Step-3: Updated dsenv PATH and LIBPATH
#!/bin/sh
####################################################################
#
# dsenv - DataStage environment file
...
...
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $
DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$ORACLE_HOME/lib/
..
NZ_HOME="/usr/nps/kit/"
export NZ_HOME
...
...
export PATH=$PATH:$ORACLE_HOME/bin:$NZ_HOME/bin
export LIBPATH=$LIBPATH:$ORACLE_HOME/lib:$NZ_HOME/lib64
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`~
Here is the NZ library...
[turks: isadmin8 :/usr/nps/kit/lib] ls -ltr
total 97848
-r--r--r-- 1 nz nz 422 Jul 29 2008 odbcinst.ini.sample
-r--r--r-- 1 nz nz 710 Jul 29 2008 odbc.ini.sample
-r--r--r-- 1 nz nz 5876 Jul 29 2008 ODBC_README
-rwxr-xr-x 1 nz nz 851251 Jul 29 2008 libnzodbc.a
-rwxr-xr-x 1 nz nz 16120717 Jul 29 2008 libnzodbcT_I_U16.so
-rwxr-xr-x 1 nz nz 16118290 Jul 29 2008 libnzodbcT_I_U8.so
-rwxr-xr-x 1 nz nz 227250 Jul 29 2008 libnzodbcT_L9_U16.so
-rwxr-xr-x 1 nz nz 16119961 Jul 29 2008 libnzodbcT_I_U32.so
-rwxr-xr-x 1 nz nz 224487 Jul 29 2008 libnzodbcT_L9_U8.so
-rwxr-xr-x 1 nz nz 227346 Jul 29 2008 libnzodbcT_L9_U32.so
-rwxr-xr-x 1 nz nz 173847 Jul 29 2008 nzjdbc3.jar
lrwxrwxrwx 1 nz nz 20 Jan 26 2009 libnzsqlodbc3_64bit.so -> ../lib64/libnzodbc.a
lrwxrwxrwx 1 nz nz 11 Jan 26 2009 libnzsqlodbc3.so -> libnzodbc.a
[turks: isadmin8 :/usr/nps/kit/lib]
Pls advise...
Thnx
I am trying to configure ODBC to read a table on Netezza Database. Actually I am not even able to connect to the Database....
Executing the "example" script in branded_odbc results in this error. I am able to connect to Netezza database from AIX.
[turks: isadmin8 :/opt/IBM/InformationServer/Server/branded_odbc/example] example
example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : NZDEVSTG
Enter the user name : nz_usr
Enter the password : nz_pwd
Illegal instruction (core dumped)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
and when I tried to use DS_CONNECT here is the error
>DS_CONNECT NZDEVSTG
Enter username for connecting to 'NZDEVSTG' DBMS [isadmin8]: nz_usr
Enter password for stgdev:nz_pwd
Abnormal termination of DataStage.
Fault type is 4. Layer type is BASIC run machine.
Fault occurred in BASIC program DS_CONNECT at address adc.
Illegal instruction (core dumped)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steps I performed after installing the NZ odbc driver and Data Direct :
Step-1: Updated odbc.ini
[NZDEVSTG]
Driver = /usr/nps/kit/lib/libnzsqlodbc3_64bit.so
Description = Netezza CDM Dev Database
Servername = dinar
Port = 5480
Database = cmdev01
Username = nz_usr
Password = nz_pwd
ReadOnly = false
ShowSystemTables = true
LegacySQLTables = false
LoginTimeout = 0
QueryTimeout = 0
DateFormat = 1
NumericAsChar = false
SQLBitOneZero = false
StripCRLF = false
Step-2: Updated uvodbc.config in both Project and DSEngine directories.
<NZDEVSTG>
DBMSTYPE = ODBC
Step-3: Updated dsenv PATH and LIBPATH
#!/bin/sh
####################################################################
#
# dsenv - DataStage environment file
...
...
LIBPATH=`dirname $DSHOME`/branded_odbc/lib:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:`dirname $
DSHOME`/PXEngine/lib:$ASBHOME/apps/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc_64:$ORACLE_HOME/lib/
..
NZ_HOME="/usr/nps/kit/"
export NZ_HOME
...
...
export PATH=$PATH:$ORACLE_HOME/bin:$NZ_HOME/bin
export LIBPATH=$LIBPATH:$ORACLE_HOME/lib:$NZ_HOME/lib64
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`~
Here is the NZ library...
[turks: isadmin8 :/usr/nps/kit/lib] ls -ltr
total 97848
-r--r--r-- 1 nz nz 422 Jul 29 2008 odbcinst.ini.sample
-r--r--r-- 1 nz nz 710 Jul 29 2008 odbc.ini.sample
-r--r--r-- 1 nz nz 5876 Jul 29 2008 ODBC_README
-rwxr-xr-x 1 nz nz 851251 Jul 29 2008 libnzodbc.a
-rwxr-xr-x 1 nz nz 16120717 Jul 29 2008 libnzodbcT_I_U16.so
-rwxr-xr-x 1 nz nz 16118290 Jul 29 2008 libnzodbcT_I_U8.so
-rwxr-xr-x 1 nz nz 227250 Jul 29 2008 libnzodbcT_L9_U16.so
-rwxr-xr-x 1 nz nz 16119961 Jul 29 2008 libnzodbcT_I_U32.so
-rwxr-xr-x 1 nz nz 224487 Jul 29 2008 libnzodbcT_L9_U8.so
-rwxr-xr-x 1 nz nz 227346 Jul 29 2008 libnzodbcT_L9_U32.so
-rwxr-xr-x 1 nz nz 173847 Jul 29 2008 nzjdbc3.jar
lrwxrwxrwx 1 nz nz 20 Jan 26 2009 libnzsqlodbc3_64bit.so -> ../lib64/libnzodbc.a
lrwxrwxrwx 1 nz nz 11 Jan 26 2009 libnzsqlodbc3.so -> libnzodbc.a
[turks: isadmin8 :/usr/nps/kit/lib]
Pls advise...
Thnx