DB2如何在一张表上建立两个分区字段

[杰小]

create table test(
test_id varchar(10),
test_nm varchar(10),
test_dat varchar(10)
)
PARTITION BY RANGE(test_id)
(PART OTHERS1 STARTING(MINVALUE) EXCLUSIVE ENDING('2000') EXCLUSIVE IN TBS_GATHER,
PART OTHERS2 STARTING('3000') ENDING(MAXVALUE) EXCLUSIVE IN TBS_GATHER)


create table test(
test_id varchar(10),
test_nm varchar(10),
test_dat varchar(10)
)
PARTITION BY RANGE(test_dat)
(PART OTHERS1 STARTING(MINVALUE) EXCLUSIVE ENDING('20090101') EXCLUSIVE IN TBS_GATHER,
PART OTHERS2 STARTING('20100101') ENDING(MAXVALUE) EXCLUSIVE IN TBS_GATHER)

要求按test_id建立一个分区，再按test_dat建立一个分区
如上：如何将两个分区建到一张表上，请给出具体的SQL代码，谢谢

[zhaojianmi1]

create table test(
test_id varchar(10),
test_nm varchar(10),
test_dat varchar(10)
)
PARTITION BY RANGE(test_id, test_dat)
(PART PAR1 STARTING(MINVALUE, MINVALUE) EXCLUSIVE ENDING('2000', '20090101') EXCLUSIVE, 
 PART PAR2 STARTING(MINVALUE, MAXVALUE) EXCLUSIVE ENDING('2000', '20090101') EXCLUSIVE, 
 PART PAR3 STARTING('2000', '20090101') ENDING(MAXVALUE, MINVALUE) EXCLUSIVE, 
 PART PAR4 STARTING('2000', '20090101') ENDING(MAXVALUE, MAXVALUE) EXCLUSIVE, 
)

[杰小]

create table test(
test_id varchar(10),
test_nm varchar(10),
test_dat varchar(10)
)
PARTITION BY RANGE(test_id, test_dat)
(PART PAR1 STARTING('0', '20080101') EXCLUSIVE ENDING('2000', '20090101') EXCLUSIVE,
PART PAR2 STARTING('0', '20090101') EXCLUSIVE ENDING('2000', '20100101') EXCLUSIVE,
PART PAR3 STARTING('2000', '20080101') ENDING('4000', '20090101') EXCLUSIVE,
PART PAR4 STARTING('2000', '20090101') ENDING('4000', '20100101') EXCLUSIVE,
)

我在建立的时候，提示说par1的数据覆盖了其他分区的数据？
仔细看下没有相同的数据会落到同一个点啊，可以解释下其中的范围是怎么算的吗？
谢谢

[zhaojianmi1]

你画一个坐标，以'2000', '20090101'为原点
然后看看这四个分区所覆盖的区域有没有重叠