Posted on 2008-12-25 16:40
Prayer 閱讀(614)
評論(0) 編輯 收藏 引用 所屬分類:
DB2
insert into deal_st(ins,brch_ins) select a.ins,b.ins from (select ins from ins_inf where cata!='02') as a,(select ins from ins_inf where cata='02') as b
提醒數據庫事務日志已滿。
不想改數據庫日志設置。
方法：
1 采用export導出數據。
export to d:\xxx.del of del select a.ins,b.ins from (select ins from ins_inf where cata!='02') as a,(select ins from ins_inf where cata='02') as b
2 采用import導入數據，關鍵是一定要commitcount 10000來限定一次提交的交易數量。
import from d:\dxxx.del of del commitcount 10000 insert into deal_st(ins,brch_ins)