IS connectivity to Netezza error

inter5566 · Post by **inter5566** » Tue Sep 30, 2008 6:57 am

Hello,

I'm currently working on configuring Information Server to work with Netezza. Just trying to start with a simple

ODBC connection to the Netezza machine.

I have installed the Netezza 4.5.0 ODBC drivers to the following location :

Code: Select all

/as_edw_wwt03/Netezza/npsclient450

Here is the content of the lib directory below the Netezza ODBC directoy:

Code: Select all

drwxr-xr-x    2 dsadm    irm            4096 May 14 18:06 .
drwxrwxr-x    9 dsadm    irm             256 Sep 29 21:21 ..
-r--r--r--    1 dsadm    irm            7151 May 14 17:27 ODBC_README
-rwxr-xr-x    1 dsadm    irm         2612133 May 14 17:56 libnzodbc.a
-rwxr-xr-x    1 dsadm    irm        16120933 May 14 17:56 libnzodbcT_I_U16.so
-rwxr-xr-x    1 dsadm    irm        16120231 May 14 17:56 libnzodbcT_I_U32.so
-rwxr-xr-x    1 dsadm    irm        16118506 May 14 17:56 libnzodbcT_I_U8.so
-rwxr-xr-x    1 dsadm    irm          227178 May 14 17:56 libnzodbcT_L9_U16.so
-rwxr-xr-x    1 dsadm    irm          227274 May 14 17:56 libnzodbcT_L9_U32.so
-rwxr-xr-x    1 dsadm    irm          224415 May 14 17:56 libnzodbcT_L9_U8.so
lrwxrwxrwx    1 dsadm    irm              11 Sep 29 21:21 libnzsqlodbc3.so -> libnzodbc.a
lrwxrwxrwx    1 dsadm    irm              20 Sep 29 21:21 libnzsqlodbc3_64bit.so -> ../lib64/libnzodbc.a
-r--r--r--    1 dsadm    irm              76 May 14 18:06 nzjdbc.ini
-rwxr-xr-x    1 dsadm    irm          225319 May 14 18:06 nzjdbc3.jar
-r--r--r--    1 dsadm    irm             778 May 14 17:27 odbc.ini.sample
-r--r--r--    1 dsadm    irm             422 May 14 17:27 odbcinst.ini.sample

I have modified the dsenv file to contain the path of the lib driectory above in the LIBPATH variable as shown below:

Code: Select all

LIBPATH=`dirname $DSHOME`/branded_odbc/lib:/as_edw_wwt03/Netezza/npsclient450/lib/:`dirname $DSHOME`/DSComponents/lib:`dirname $DSHOME`/DSComponents/bin:$DSHOME/lib:$DSHOME/uvdlls:$ASBHOME/app
s/jre/bin:$ASBHOME/apps/jre/bin/classic:$ASBHOME/lib/cpp:$ASBHOME/apps/proxy/cpp/aix-all-ppc:$ORACLE_HOME/lib32:$LIBPATH

export LIBPATH

Here is the entry in the .odbc.ini file:

Code: Select all

[netezza_poc]
Driver=/as_edw_wwt03/Netezza/npsclient450/lib/libnzsqlodbc3.so
Description=NetezzaSQL ODBC
ServerName=brkcla01-odbc
PortNumber=5480
Database=navistar
Username=admin
Password=password
ReadOnly=false
ShowSystemTables=false
LegacySQLTables=false
LoginTimeout=0
QueryTimeout=0
DateFormat=1
NumericAsChar=false
SQLBitOneZero=false
StripCRLF=false
securityLevel=preferredUnSecured
caCertFile            =

Here is the entry in the uvodbc.config file:

Code: Select all

<netezza_poc>
DBMSTYPE = ODBC

Here is the output of the "example" ODBC test executable in the branded_odbc directory:

Code: Select all

brksvx41a:/as_edw_wwt03/IBM/InformationServer/Server/branded_odbc/example>example
example DataDirect Technologies, Inc. ODBC Example Application.

Enter the data source name : netezza_poc

Enter the user name        : admin

Enter the password         : password
SQLSTATE = HY000
NATIVE ERROR = 33
MSG = Server and/or port attributes are empty

SQLConnect: Retrying Connect.
SQLSTATE = HY000
NATIVE ERROR = 33
MSG = Server and/or port attributes are empty

SQLConnect: Retrying Connect.
SQLSTATE = HY000
NATIVE ERROR = 33
MSG = Server and/or port attributes are empty

SQLConnect: Retrying Connect.
brksvx41a:/as_edw_wwt03/IBM/InformationServer/Server/branded_odbc/example>

I receive the same error when trying to import ODBC table definitions via the DataStage designer client.

I would be greatful to anyone who can add a new perspective on this case. I've been working with both IBM and Netezza, but no answer yet. I have tried all possible combinations of Server/Servername/ServerName and Port/Portnumber/PortNumber as well to insure that it's not just a simple variable name problem.

Thanks for your time and help,
Steve

P.S. Who's going to be the first to reply with an answer that will force me to become a premium member

Aruna Gutti · Post by **Aruna Gutti** » Tue Sep 30, 2008 7:38 am

I don't think getting a reply for this post should be the sole reason for you to become premium member as there are several other benefits you can derive being a premium member.

But here is what I think you may be missing.

You need to have a soft link odbc.ini in your $DSHOME that points to .odbc.ini.

For example :

ls -l odbc.ini
lrwxrwxrwx 1 dsadm dsadm 11 Jun 8 2006 odbc.ini -> ./.odbc.ini

I usually have a copy of .odbc.ini as odbc.ini file in $DSHOME and make sure both have same content.

Good Luck,

Aruna.

inter5566 · Post by **inter5566** » Tue Sep 30, 2008 8:54 am

Thanks Aruna,

Your solution was spot on!!!

Is this a Netezza specific thing, or is it associated to AIX? (this is a software trial we are currently working on a new AIX box rather than our usual HP-UX platform)

Thanks for the quick response.
-Steve

chulett · Post by **chulett** » Tue Sep 30, 2008 9:03 am

It's more of a third-party ODBC driver thing, you need to help DataStage find them. You would have had the same issue with HP-UX.

inter5566 · Post by **inter5566** » Tue Sep 30, 2008 9:23 am

Thanks for the clarification Craig.

I will mark this thread as RESOLVED.

Now to move on to getting Netezza Enterprise working

-Steve

Aruna Gutti · Post by **Aruna Gutti** » Tue Sep 30, 2008 10:08 am

Good Luck with getting Netezza Enterprise stage working. That is a challenge as we don't seem to find too many people with Netezza / DataStage experience.

Aruna Gutti · Post by **Aruna Gutti** » Tue Sep 30, 2008 10:10 am

Good Luck with getting Netezza Enterprise stage working. That is a challenge as we don't seem to find too many people with Netezza / DataStage experience.