DSXchange

Hi iam having issue to connect to database using datastage yesterday it was working fine but today i am unable to connect it is giving me an error DSR.MetaGeta(GET.DSNINFO)(SQLConnect('DMT','administrator')) : BCI Error : SQLSTATE=IM004,CODE=0,[DataStage][SQL Client][ODBC][Microsoft][ODBC Driver Man...

APT_CombinedOperatorController,0: Fatal Error: Fatal: Internal Error: Function 'load_data' failed DSTAGE-UDB-0008`:`Internal Error: Function 'connect_to_data_source' failed when i an trying to run the job i am getting above error but .bat file is created when i run that .bat file records are loading...

hey raju did find how to load the data into db2 database on mainframes using db2z stage if so please can you tell me

thank you

please help me out how to connect to db2 datastage on mainframes using db2z stage in datastage 8.1

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

actullay i just testing with remaning all other db2 stages but main issue is with db2 z/os

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

Yes chulett only for db2 z/os

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 t...

Hey Ray please can you tell what values need to set for DSHOME and APT_RESPATH Actually i have set the DSHOME in under userdefine in administrative client

DSHOME: C:\IBM\InformationServer\Server\DSEngine

Hi, I am reading the data from db2 database which is on main frames using db2z/os stage in datastage 8.1 before runnnig the job when i have entered valid user_name,password and database name and trying to view data i am getting the below error ##I IIS-DSEE-TFCN-00001 13:27:27(000) <main_program> IBM...

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

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,u...

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

try by stop and start the agent i think it will work