DB2 API Stage Configuration

[pradkumar]

Hi,
We are trying to configure DB2 API stage in AIX server. We configured the following variable in the dsenv file.

INSTHOME=/dss/db2inst1;export INSTHOME
DB2INSTANCE=db2inst1;export DB2INSTANCE
DB2DIR=/dss/opt/IBM/db2/V9;export DB2DIR
DB2CLIINIPATH=$DSHOME;export DB2CLIINIPATH
LIBPATH=$LIBPATH:$INSTHOME/sqllib/lib; export LIBPATH
PATH=$PATH:$INSTHOME/sqllib/bin:$INSTHOME/sqllib/adm:$INSTHOME/sqllib/misc; export PATH

When we try to view the data from DB2 API stage or try to run the job, we are getting the error:
The database alias name or database name "DB2T" could not be found. SQLSTATE=42705
DSTAGE-DB2CLI-0005`:`Unable to connect to DB2 server 'db2t'.

DB2T is our database name.

Do we need to configure anything else?

Please help to resolve this issue.

Thanks in Advance.

[chulett]

For DB2 you need to "bind" the instance to the server or some such thing. It's been discussed here a number of times, for example:

viewtopic.php?t=113908

I'm guessing you missed that step.

[pradkumar]

We were able to connect from the Datastage server on windows but we are unable to do so in AIX. But in windows we added DB2 database connection using DB2 configuration assistant and we used the same when we create DSN.
Can anyone tell us how to configure DB2 client in AIX?
(we are using the DB2 database that came along with datastage server)

[sjfearnside]

I am using V8.0.1 on an AIX 5.3 platform with DB2 V9. I have successfully connected using the following configuration -

DB2DIR=/opt/app/IBM/db2/V9; export DB2DIR
DB2INSTANCE=db2inst1; export DB2INSTANCE
INSTHOME=/data/db/db2inst1; export INSTHOME
LIBPATH=$LIBPATH:$DB2DIR/lib32:$DB2DIR/lib64; export LIBPATH
PATH=$PATH:$DB2DIR/bin; export PATH
THREADS_FLAG=native; export THREADS_FLAG

You may need to make adjustments depending on your installation, but hopefully it will help.

[pradkumar]

We are able to connect now after we created DB2 catalog entry and configured the DB2 client. Issue is resolved. :D

Thanks!