DSXchange

Hi ,

We are getting the following error while loading the data into DB2 table using DRS stage.In the same project other jobs are running fine only few jobs are throwing the following error.

Error messages:
DSP.Open GCI $DSP.Open error -100.


Additional Info:
1. DB connection is good.
2. I have renamed the link
3. create copy of job and run the copy job
4 export and reimport the job
We did all the thing tough its not worked....

If i remove the link and create the new link and map the columns to target stage then its working. But i feel there should be better way.

Can any body have an idea...

Thanks in advance.

When the job aborts and you Reset it, do you get a 'From previous run...' message generated into the log? If so, post it.

Have you provided any default connection details in the stage ?

Hi Sainath,

We are not providing any default values...

Chulett- every time we are recompiling...same error is incurring in all the runs

Well then, stop recompiling and Reset the dang job instead. Also post whatever other errors you see with that one, it by itself is fairly meaningless.