Db2 Z loader - Issue

dsuser_cai · Post by **dsuser_cai** » Tue Apr 17, 2012 1:44 pm

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

dsuser_cai · Post by **dsuser_cai** » Tue Apr 17, 2012 5:13 pm

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

qt_ky · Post by **qt_ky** » Tue Apr 17, 2012 5:17 pm

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.