IDENTITY column RESTART in DB2 UDB8.2

/*
使用輸銀風險管理stagging tables 為例, 隨著倉儲資料越來越大, 經過幾次資料搬移, 幾個identity的欄位將爆掉. 將identity restart的程序如下:
*/

-- EXPORT TABLE WITH IDENTITY

EXPORT TABLE F_N_CNTDETAIL.DEL OF DEL SELECT * FROM F_N_CNTDETAIL ORDER BY SEQ

--清空 table

ALTER TABLE F_N_CNTDETAIL ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE

--RESTART IDENTITY

ALTER TABLE F_N_CNTDETAIL ALTER COLUMN SEQ RESTART WITH 1;

--LOAD

LOAD FROM F_N_CNTDETAIL.DEL OF DEL MODIFIED BY IDENTITYIGNORE
INSERT INTO F_N_CNTDETAIL