DSDB2 Plugin- Unable to locate Server

[kalyanvinnakota]

Hi All,

I have the DSDB2 Plugin. I could connect to tables located in local DB2.
When I am trying to connect to the tables in DB2(Main frame)- It gives the following error.

[b]DSDB2MF..DSDB2_4: [IBM][CLI Driver] SQL1013N The database alias name or database name "EGGTDBN1" could not be found. SQLSTATE=42705

Unable to connect to DB2 server 'EGGTDBN1'.
DSDB2MF..DSDB2_4.DSLink1: DSP.Open GCI $DSP.Open error -2.[/b]

I have set the [b]dsenv, uvodbc.config, .odbc.ini[/b] files. I am able to connect to DB2 tables in main frame using the ODBC. But when I am trying with the DSDB2 plug in, I see the above error.

I also did a bind to DSN.

I have the "EGGTDBN1" DSN in both uvodbc.config and also in .odbc.ini.

Could you please help me.

I find myself in big trouble.

Thanks in ADvance
Regards,
Kalyan

[amsh76]

Its a DB2 error, Check with your DBAs..it looks like your server name is incorrect.

[kalyanvinnakota]

That is an existing DSN(EGGTDBN1- on DB2 mainframe). It has been in use since the project started 2 years back.

I am able to connect to the same DSN using ODBC. But when I am using DSDB2, then I get this error.

We are setting up a new server. In the existing servers, we do connect to it, using the DSDB2. The people who configured it then are now not available.

Any Help/Thought/Idea is greatly appreciated.

Thanks in Advance,
Regards,
Kalyan

[ranga1970]

r u able to connect to db2 from your new server with odbc???

if I am not wrong

1 . you are able to connect to db2 from odbc and dsdb2 from old servers
2. you are able to connect to db2 from odbc but not from dsdb2 from your new server...

ans secondly
did you try comparing the uv config files fo both the servers and dsenv of the both servers....

[gpatton]

What version of db2 are you connecting to and what version of the db2 connectivity software are you using?

db2 version 8 completely changed the API.

[vmcburney]

The DB2 plugin will not use any of your ODBC settings and I don't think it will use your DB2 binding either. It depends heavily on the configuration of the DB2 client on your machine and the settings in your dsenv file. I would try to import plugin table definitions through the DataStage Manager. I would inspect the environment variables being displayed in the second job log message for any executed job, in particular the path statements, the library path and the DB2INSTANCE value. I would also run DB2 from a telnet session using the dsadm user on the DataStage server an attempt to connect to the target DB2 database using the CONNECT TO DatabaseName command. This will validate whether the DB2 client is setup correctly.

[kalyanvinnakota]

Hi Vincent,

Thanks for your reply. The DB2 is setup fine on the server. I am able to connect to the DB2 from telnet and also from Datastage server.

I am copy pasting my dsenv file, just in case if you see anything missing.

[b]dshome=`cat /.dshome`

# ALL PLATFORMS SECTION

ODBCINI=$dshome/.odbc.ini; export ODBCINI
HOME=${HOME:-/}; export HOME

#UDTHOME=$dshome/../ud41; export UDTHOME
#UDTBIN=$dshome/../ud41/bin; export UDTBIN

# PLATFORM SPECIFIC SECTION

LIBPATH=/.dslibs:$dshome/lib:$LIBPATH; export LIBPATH

PATH=$PATH:$dshome/bin
PATH=/home/db2inst7/sqllib/bin:$PATH; export PATH
DB2_PATH=/home/db2inst7/sqllib; export DB2_PATH
DB2DIR=/usr/lpp/db2_07_01; export DB2DIR
DB2INSTANCE=db2inst7; export DB2INSTANCE
INSTHOME=/home/db2inst7; export INSTHOME
. /home/db2inst7/sqllib/db2profile[/b]


One thing I want to know, is can I connect to the DSN on DB2(mainframe), by saying [b]connect to[/b] from DB2 on the local ETL server.


Thanks in Advance,
Regards,
Kalyan

[vmcburney]

You may also need the following:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INSTHOME/sqllib/lib;export LD_LIBRARY_PATH

and

PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc