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
DB2 connector - doubling records
Moderators: chulett, rschirm, roy
Re: DB2 connector - strange behaviour
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
"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
regards
Michael
Michael
-
- Participant
- Posts: 8
- Joined: Mon Mar 11, 2013 2:51 pm
- Location: RTP, North Carolina
Re: DB2 connector - doubling records
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.
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.