DSXchange

Hi

I have a job that reads data from a data set (10 fields) and then passes thro transformer (im propagating only 4 fields to output), then i use a Z-loader stage (DB2 Bulk load) to load into the table. The job completes with Status = "Finished". I dont see any warnings or fatal errors, no message handlers used. And when i check the table, the data looks correct. but when i call this job in the main sequence its failing.
There is no detailed error message or warning, but this is what i get from the Director Logs:

Warning1)
SequenceName.InvocationID.JobControl (JobName): Errors in Job

Fatal Error:
Job Aborted after 1 errors logged.

Warning2)
Attempting to Cleanup after ABORT raised in job EE_SEQ_ADV_TPC_DATA_ACQUISITION_EXT.ADVANTAGE_TPC.JobControl

Can somebody help me with this?

Thanks

Hi

I tried these, and looks like its working fine now.

1) I replaced the z-loader with the DB2 connector stage - this works fine.

2) I deleted the job and re-created the entire load job again. This time i used the same z-loader (DB2 bulk loading) stage. and the job is working fine. Not sure what happened in the background...

Can anybody share your experience....

Thanks

I don't know the reason there, but the Connector stages are the preferred support way to go. The Connectivity Guide for DB2 will mention that in chapter 2.