DB2分区表数据管理

一、检查分区

select datapartitionname,lowvalue,highvalue from syscat.partitions where tabname='XXX' and tabschema='XXX' order by datapartitionname;

二、分区剥离归档

1、db2 "ALTER TABLE ECIFAPP.CBM_CORP_DEP_DTL DETACH PART PART201208 INTO ECIFAPP.CBM_CORP_DEP_DTLTEMP_REMOVE"

2、db2 "EXPORT TO CBM_CORP_DEP_DTL.txt of del modified by coldelx1B nochardel codepage=1386 select * from ecifapp.CBM_CORP_DEP_DTLTEMP_REMOVE"

3、db2 "ALTER TABLLE ECIFAPP.CBM_CORP_DEP_DTL DETACH PART PART0 INTO ECIFAPP.CBM_CORP_DEP_DTLTEMP_DETACH"

4、db2 "SET INTEGRITY FOR ECIFAPP.CBM_CORP_DEP_DTL OFF"

5、db2 "ALTER TABLE ECIFAPP.CBM_CORP_DEP_DTL ATTACH PART PART0 STARTING MINVALUE FROM TABLE ECIFAPP.CBM_CORP_DEP_DTLTEMP_DETACH"

6、db2 "SET INTEGRITY FOR ECIFAPP.CBM_CORP_DEP_DTL ALLOW WRITE ACCESS IMMEDIATE CHECKED"

7、db2 "call sysproc.admin_cmd('load from (select * from ecifapp