Hi, I'm trying to understand the data distribution based on limit keys. This was created before v8 (DB2 Z/os) and based on index based partitioning. The DDLextract is as below.
CREATE UNIQUE INDEX creator1.index1
(PART 1 VALUES(2014 'DA02'),
PART 2 VALUES(2014, 'DB04'),
PART 3 VALUES(2014, 'F004'),
PART 4 VALUES(2014, '0014')
PART 5 VALUES(2014, 'Z010')
PART 6 VALUES(2014))
1)What DATA goes to partition 6 ? It does not contain value for sales_area. what would be the logic behind PART 6 not having value for SALES_AREA ?
2)If sales_area has value 'G004' then will it goes to the partition 3. I assumed limit key F004 can accommodate G004 values. How to work it out different alphabetic values (on column SALES_AREA) go to which partition please.
Thanks for your help in advance.