Posted on 2008-12-25 16:40
Prayer 阅读(598)
评论(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)