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.
DB2 API Stage Configuration
Moderators: chulett, rschirm, roy
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.
viewtopic.php?t=113908
I'm guessing you missed that step.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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)
Can anyone tell us how to configure DB2 client in AIX?
(we are using the DB2 database that came along with datastage server)
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am
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.
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.