To make DB2 read in parallel

vnspn · Post by **vnspn** » Thu Nov 15, 2007 11:59 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 16, 2007 12:45 am

No.

You use a DB2 Enterprise stage for that.

balajisr · Post by **balajisr** » Fri Nov 16, 2007 1:09 am

And you need DB2 DPF license as well.

stefanfrost1 · Post by **stefanfrost1** » Fri Nov 16, 2007 2:22 am

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

vnspn · Post by **vnspn** » Fri Nov 16, 2007 5:19 pm

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.