Staggered Sequential Key
Posted: Thu Nov 23, 2006 3:10 pm
When I generate a unique partitioned key using
@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 + MAXEVNTID
Where MAXEVNTID = max value from the last job execution,
The DB2 table sequentially increment the key by 1 on different partitions.
So far so good.
When the key sequence number hit 100, it begins to jump by 2, sometimes 4 etc. It no longer increase by one. Is this normal. I have 111 records and I would of thought that my key would of been 1 thru 111. It goes from 1 to 100 and then staggers up to 132.
Could someone please explain why.
Thanks
@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1 + MAXEVNTID
Where MAXEVNTID = max value from the last job execution,
The DB2 table sequentially increment the key by 1 on different partitions.
So far so good.
When the key sequence number hit 100, it begins to jump by 2, sometimes 4 etc. It no longer increase by one. Is this normal. I have 111 records and I would of thought that my key would of been 1 thru 111. It goes from 1 to 100 and then staggers up to 132.
Could someone please explain why.
Thanks