Setting DB2 environment variables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
Setting DB2 environment variables
Hi All we have installed Infosphere8.1 on windows server and our DBA's have installed DB2 on some other server, so the installation of infosphere 8.1 and db2 are different so how do i configure db2 and set environment variables so that i can use it, if both of them (infosphere 8.1 and DB2) are on same i know how to set the APT_DB2instance_name,Apt_Dbname but if they are remotly how do i need to configure please help me out
thank you,
thank you,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
No chulette my problem our dba has installed db2 on main frames with is on 'X' server.
we have installed datastage8.1 on 'Y' server. I have created odbc connection for db2 database.
now my question is i want to use db2z/os stage for retreving n number of rows from db2 database.I have enter db2name,user_id,password
before runnning the job i am trying to view data from db2z stage it is giving me an error stating
db2name,user_id,password not found please check DSHOME or APT_RESPATH so please tell what the environment variable need to set up to connect to remote db2 database
we have installed datastage8.1 on 'Y' server. I have created odbc connection for db2 database.
now my question is i want to use db2z/os stage for retreving n number of rows from db2 database.I have enter db2name,user_id,password
before runnning the job i am trying to view data from db2z stage it is giving me an error stating
db2name,user_id,password not found please check DSHOME or APT_RESPATH so please tell what the environment variable need to set up to connect to remote db2 database
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is an entire manual on DB2 connectivity. Have you read it?
Are you using DB2 Connect on the DataStage server (which is the DB2 client)? This is the usual method for accessing DB2 tables on different platforms.
You still need to bind, though.
Are you using DB2 Connect on the DataStage server (which is the DB2 client)? This is the usual method for accessing DB2 tables on different platforms.
You still need to bind, though.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
I have gone through db2 connectivity documentation i am able to connect to db2 server from db2 client but when i am using db2stage like db2 udb,db2 enterprise db2 load and db2 z i am unable to connect to the database asking me to set some environment variable so i dont know how to set it.
one more thing does db2z/os is only to retrive or load data from db2 database on main frames only or db2 database on other environment(windows or unix).
one more thing does db2z/os is only to retrive or load data from db2 database on main frames only or db2 database on other environment(windows or unix).
The name of the stage is a big clue to the answer. Yes, right, only for DB2 on Z/OS.suneelchallagali wrote:one more thing does db2z/os is only to retrive or load data from db2 database on main frames only or db2 database on other environment(windows or unix).
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm
-
- Participant
- Posts: 251
- Joined: Tue Dec 02, 2008 3:09 pm