1、查询出分区名
select
datapartitionname
from syscat.datapartitions t
where tabschema = 'ECIF'
AND tabname =:tableName
AND datapartitionname LIKE 'PART%'
WITH UR
或者,(可以查询出分区区间)
select
datapartitionname,lowvalue,highvalue
from syscat.datapartitions t
where tabschema = 'ECIF'
AND tabname ='SCHEDULE_TRANS_HIS'
AND datapartitionname LIKE 'PART%'WITH UR;
2、将分区数据拆分成临时表
alter table ECIF.LAZY_BROADCASTED_HIS(表名) detach partition PART4(默认分区名) into ECIF.LAZY_BROADCASTED_HIS_TEMP_4(临时表名);
3、判断是否拆分成功
select count(*) from SYSCAT.DATAPARTITIONS where tabschema='' and tabname='' and status in('D','I','L')
如果这个值是0 ,就表名分区拆分成功
4、删除临时表
drop table ECIF.LAZY_BROADCASTED_HIS_TEMP_4;