Setting DB2 environment variables

suneelchallagali · Post by **suneelchallagali** » Fri Jan 08, 2010 9:41 am

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,

suneelchallagali · Post by **suneelchallagali** » Fri Jan 08, 2010 1:30 pm

please any help

ray.wurlod · Post by **ray.wurlod** » Fri Jan 08, 2010 5:08 pm

Learn patience. You posted at 2:41am my time.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 10:06 am

Hi can any one help out with the configuration of the environment variable for the db2.

chulett · Post by **chulett** » Wed Jan 13, 2010 10:28 am

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.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 10:36 am

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

chulett · Post by **chulett** » Wed Jan 13, 2010 10:41 am

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?

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 10:45 am

Thanks for you replay chulett I have not BIND the database i dont know how to do it.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 13, 2010 3:34 pm

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.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 3:57 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).

chulett · Post by **chulett** » Wed Jan 13, 2010 4:24 pm

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.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 4:27 pm

Yes chulett only for db2 z/os

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 4:29 pm

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

chulett · Post by **chulett** » Wed Jan 13, 2010 4:31 pm

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.

suneelchallagali · Post by **suneelchallagali** » Wed Jan 13, 2010 4:35 pm

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