DSXchange

Hi All,

I have strange situation in my project. In the DB2 Connector I enable: Enable partition reads. Then I choose Modulo and specify column.
I have examples where the DB2 connector after such settings multiplies my data by 2. But I also have DB2 connectors where it doesn't multiply the data.

What can be reason?

Job is running on 2 nodes. Version 11.5

Kind regards,
TJ

Hi

"Enable partition reads" will work with partitioned databases in DB2 - if you have a single partition database you will not see a performance effect

regards
MT

If it runs on four nodes, I bet it'll quadruple the data.

I'm guessing that your modulo and your partitioning in DB2 aren't the same. So, effectively, your SQL statement, that runs on each partition, is not constraining its results to the records that are on that partition.

Did you select a numeric column type like integer?