软件开发
请问怎样快速导入导出DB2数据库
一个项目中要使用DB2，然后就开始了痛苦的过程，首先，我真的真的真的无意冒犯使用DB2的大家，我就是想问下DB2有什么快捷的导入导出数据库，我在oracle里完全就用imp/emp搞定了。我在DB2里创建了数据库、缓冲池、表空间后，然后，我实际环境使用的DB2数据库跟我测试环境的一样的，我怎样...显示全部
查看其它 5 个回答sunyangnj的回答
2 如果你采取导入导出数据export+load的话
在导入数据,且668报错后,执行以下脚本,解除完整性暂挂状态
with gen(tabname,seql) as (select rtrim(tabschema)||'.'||rtrim(tabname) as tabname,row_number() over (partition by status) as seq from syscat.tables where status='C'),r(a,seq1) as (select cast(tabname as varchar(3900)),seq from gen where seq=1 union all select r.a||'.'||rtrim(gen.tabname),gen.seq from gen, r where (r.seq1+1)=gen.seq),r1 as (select a,seq1 from r) select 'set integrity for'||a||'immediate checked' from r1 where seq1=(select max(seq1) from r1)
在导入数据,且668报错后,执行以下脚本,解除完整性暂挂状态
with gen(tabname,seql) as (select rtrim(tabschema)||'.'||rtrim(tabname) as tabname,row_number() over (partition by status) as seq from syscat.tables where status='C'),r(a,seq1) as (select cast(tabname as varchar(3900)),seq from gen where seq=1 union all select r.a||'.'||rtrim(gen.tabname),gen.seq from gen, r where (r.seq1+1)=gen.seq),r1 as (select a,seq1 from r) select 'set integrity for'||a||'immediate checked' from r1 where seq1=(select max(seq1) from r1)
浏览702