Initially I created a table with three partitions, i.e for 13,14 and 15. I see these partitions under syscat.datapartitions.
Expand|Select|Wrap|Line Numbers
- create table r_dummy
- (
- a_date date,
- b_int int
- )
- partition by range(a_date)
- (
- starting from('03/13/2013') ending at('03/15/2013') every 1 day
- )
- ;
- select *
- from syscat.datapartitions
- where tabname='R_DUMMY'
- ;
Expand|Select|Wrap|Line Numbers
- alter table r_dummy add partition starting('03/16/2013') ending('03/18/2013') every 1 day;
Please correct if I'm missing something.
Thanks
Raghu