DSXchange

Hi,

We have a parallel job where we use a DB2 API stage as the source. By default, this stage runs Sequentially.

As we needed to improve the performance, we changed the property of the stage to run Parallely. The source table originally had 1 million records. But what we noticed was, when the job is run on a 4 way parallel, the records out of the DB2 stage was 4 million. Each record is read 4 times; looks like each node reads the same record once.

Is there a way we could make the DB2 stage to read parallely the way we want to; so as to improve the preformance?

Thanks.

No.

You use a DB2 Enterprise stage for that.

And you need DB2 DPF license as well.

and you have to use read method table or a simple sql that doesn't have group by or joins and similar stuff

Thanks All for your inputs.

We would look into having the DB2 Enterprise stage configured. Looks like it has a long set of configuration steps.

Thanks.