–1:在表中增加一列object_id
alter table my_table add object_id varchar(30);
–2:将历史数据的object_id填充为com_id
(也就是将主键的数据复制到新建列中,如果数据多等待时间可能会长)
update my_table set object_id =com_id;
commit;
–3:将object_id置为非空
alter table my_table alter object_id set not null;
–4:删除主键
ALTER TABLE my_table DROP primary key ;
–5:重组表结构(这一步必须)
call sysproc.admin_cmd ( ’ reorg table db2inst1.my_table’ );
–6:增加主键
ALTER TABLE my_table ADD CONSTRAINT
PK_my_table PRIMARY KEY(COM_ID,object_id, DATE1, INDEX_ID);
注:一步一步来,最好在测试库进行,以免出错。# 学习目标: