--第一步:增加列object_id
alter table my_table add object_id varchar(30);
--第二部:将历史数据的object_id填充为com_id
update my_table set object_id =com_id;
commit;
--第三步:将object_id置为非空
alter table my_table alter object_id set not null;
--第四步:删除主键
ALTER TABLE my_table DROP primary key ;
--第五步:重组表结构
call sysproc.admin_cmd ( ' reorg table db2inst1.my_table' );
--第六步:增加主键
ALTER TABLE my_table ADD CONSTRAINT
PK_my_table PRIMARY KEY(COM_ID,object_id, DATE1, INDEX_ID);
alter table my_table add object_id varchar(30);
--第二部:将历史数据的object_id填充为com_id
update my_table set object_id =com_id;
commit;
--第三步:将object_id置为非空
alter table my_table alter object_id set not null;
--第四步:删除主键
ALTER TABLE my_table DROP primary key ;
--第五步:重组表结构
call sysproc.admin_cmd ( ' reorg table db2inst1.my_table' );
--第六步:增加主键
ALTER TABLE my_table ADD CONSTRAINT
PK_my_table PRIMARY KEY(COM_ID,object_id, DATE1, INDEX_ID);