Partitioning - Writing to DB2
Posted: Wed Nov 22, 2006 11:11 am
I am trying to understand the partitioning mechanism with DS and cannot seem to get it working properly.
In the Transformer stage I created a Stage Variable containing the init. value as
@PARTITIONNUM - @NUMPARTITIONS + 1 =====> Stored in svCounter
In my stage derivation I put
MAXEVNTID + svCounter + @NUMPARTITIONS
Where MAXEVNTID is the MAX record from the last write from the prior run.
When I look at the key, it is incrementally increase by huge numbers. I wanter to increase by 1 spread out by partition.
Could someone please help me understand what the @PART.. @NUM..
determine and how do I get the patitions correctly increased.
Thanks
In the Transformer stage I created a Stage Variable containing the init. value as
@PARTITIONNUM - @NUMPARTITIONS + 1 =====> Stored in svCounter
In my stage derivation I put
MAXEVNTID + svCounter + @NUMPARTITIONS
Where MAXEVNTID is the MAX record from the last write from the prior run.
When I look at the key, it is incrementally increase by huge numbers. I wanter to increase by 1 spread out by partition.
Could someone please help me understand what the @PART.. @NUM..
determine and how do I get the patitions correctly increased.
Thanks