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
Db2 Z loader - Issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Db2 Z loader - Issue
Thanks
Karthick
Karthick
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 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
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
Thanks
Karthick
Karthick