writing to AIX sequential files and DB2 concurrently

Bill_G · Post by **Bill_G** » Mon Mar 08, 2010 1:14 pm

I have a question regarding job design. I am not sure i have ever seen this done in 7.x, but thought i'd ask the masses in case i am just not as well versed in DS as i think OR 8.x brings new functionality that could be leveraged.

If i have a single parallel job - reads data from a database, churns through various transformations and then writes concurrently to both a sequential file and DB2, is it possible to allow for the job to complete to one of the targets should the other fail?

Thanks,

Bill

kogads · Post by **kogads** » Mon Mar 08, 2010 2:47 pm

I don't think you can complete the write if one of the two fails.
Consider using Funnel Stage (Sequence type), though you can not write concurrently.

dsuser_cai · Post by **dsuser_cai** » Mon Mar 08, 2010 4:43 pm

How about having two jobs?

Bill_G · Post by **Bill_G** » Mon Mar 08, 2010 5:01 pm

Two jobs controlled by a Job Sequence is the way to go, however the requirement is for concurrent load of both the file and the db table. 2 jobs would require that i process the data in the same manner twice.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 08, 2010 5:11 pm

No, process it once only into a staging area (Data Set). Then read from there with separate load jobs. The sequence could then also report on the success or failure of each of these.

Bill_G · Post by **Bill_G** » Mon Mar 08, 2010 5:52 pm

Thanks for the confirmation. I appreciate your replies.

DSXchange

writing to AIX sequential files and DB2 concurrently

writing to AIX sequential files and DB2 concurrently

Re: writing to AIX sequential files and DB2 concurrently