Page 1 of 2
Setting DB2 environment variables
Posted: Fri Jan 08, 2010 9:41 am
by suneelchallagali
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,
Posted: Fri Jan 08, 2010 1:30 pm
by suneelchallagali
please any help
Posted: Fri Jan 08, 2010 5:08 pm
by ray.wurlod
Learn patience. You posted at 2:41am my time.
Posted: Wed Jan 13, 2010 10:06 am
by suneelchallagali
Hi can any one help out with the configuration of the environment variable for the db2.
Posted: Wed Jan 13, 2010 10:28 am
by chulett
So... are you saying that you have 8.1 installed but it's not working because it can't communicate with your DB2 XMETA install? I didn't think that was possible and that it checked connectivity during that process.
Posted: Wed Jan 13, 2010 10:36 am
by suneelchallagali
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
Posted: Wed Jan 13, 2010 10:41 am
by chulett
I've never touched DB2 in my life but I seem to remember from reading here that you need to 'bind' any new DB2 database you want to access. Have you done that?
Posted: Wed Jan 13, 2010 10:45 am
by suneelchallagali
Thanks for you replay chulett I have not BIND the database i dont know how to do it.
Posted: Wed Jan 13, 2010 3:34 pm
by ray.wurlod
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.
Posted: Wed Jan 13, 2010 3:57 pm
by suneelchallagali
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).
Posted: Wed Jan 13, 2010 4:24 pm
by chulett
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).
The name of the stage is a big clue to the answer. Yes, right, only for DB2 on Z/OS.
Posted: Wed Jan 13, 2010 4:27 pm
by suneelchallagali
Yes chulett only for db2 z/os
Posted: Wed Jan 13, 2010 4:29 pm
by suneelchallagali
I tried to search for few examples or documentation related db2 z/os stage how to load data in to db2 and how to set environment variables but i could not find much still searching
Posted: Wed Jan 13, 2010 4:31 pm
by chulett
Are you actually trying to connect to DB2 on Z/OS? It doesn't sound like it from the kind of questions you are asking.
Posted: Wed Jan 13, 2010 4:35 pm
by suneelchallagali
I am tryind to connect to db2 on mainframes using db2z stage but i am unable to connect it since it is asking me to set some variables dshome and atp_respath