Posted on 2008-12-25 16:40
Prayer 閱讀(621)
評論(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
提醒數(shù)據(jù)庫事務(wù)日志已滿。
不想改數(shù)據(jù)庫日志設(shè)置。
方法：
1 采用export導(dǎo)出數(shù)據(jù)。
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導(dǎo)入數(shù)據(jù)，關(guān)鍵是一定要commitcount 10000來限定一次提交的交易數(shù)量。
import from d:\dxxx.del of del commitcount 10000 insert into deal_st(ins,brch_ins)