db2 bulk load error

[suneelchallagali]

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 into db2database

[chulett]

First suggestion is always going to be to disable operator combination so you can see where the error is actually being generated. Add $APT_DISABLE_COMBINATION to your job, set it to True and rerun the job.

[suneelchallagali]

I have set the $APT_DISABLE_COMBINATION to true iam getting the same error as mention above

[chulett]

If you set it correctly, it won't be the same error from "APT_CombinedOperatorController".

[ray.wurlod]

Yes, but you're no longer getting it from APT_CombinedOperatorController - you now know which operator (stage) is throwing the error.

Now you need to inspect parameters and properties to determine why the job can not connect to the data source.

[suneelchallagali]

actually the error is throwing by db2 bulk load. when i run the job bulk load job .bat files are created but the status of the job is aborted but when i run the .bat file manually all the rows are inserted into db2 database. it is working like wired still working on that to figure out the problem

[ray.wurlod]

I believe this has been reported before on DSXchange. Did you Search?

(Or did I read about it on IBM's web site? Hmm...)

[suneelchallagali]

Actually i have searched the dsxchange and ibm db2 form also but i could not exact solution. I got few tips to rectify the error in detail but unable to solve it