请问DB2的数据如何恢复?

我是新手,现在在维护人行CIS的DB2数据库现在的操作系统是suse linux 9.3,DB2的版本是8.2,DB2的补丁是fp10现在有一台生产机,DB2运行正常,请问如何把生产机的上数据备份出来,导入到备机上面?两台机器的操作系统一致,数据库也一致谢谢!...显示全部
我是新手,现在在维护人行CIS的DB2数据库
现在的操作系统是suse linux 9.3,DB2的版本是8.2,DB2的补丁是fp10
现在有一台生产机,DB2运行正常,请问如何把生产机的上数据备份出来,导入到备机上面?两台机器的操作系统一致,数据库也一致
谢谢!收起
参与49

查看其它 48 个回答yeek的回答

通过以下语句建表空间的
drop tablespace TBS_IDX4K;
CREATE REGULAR TABLESPACE TBS_IDX4K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_idx01'50M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;
drop tablespace TBS_LOB1;
CREATE LARGE TABLESPACE TBS_LOB1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE
         USING (FILE '/db2_large/tbs_lob1.dat'6000M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL BUF32K         
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000;
drop tablespace TBS_LOB2;
CREATE LARGE TABLESPACE TBS_LOB2 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 32768 MANAGED BY DATABASE
         USING (FILE '/db2_large/tbs_lob2.dat'6000M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL BUF32K
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000;

drop tablespace TBS_8K;
CREATE REGULAR TABLESPACE TBS_8K IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 8192 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_dta02'100M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL BUF8K
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;
         
CREATE SYSTEM TEMPORARY TABLESPACE TBS_systmp IN DATABASE PARTITION GROUP IBMTEMPGROUP PAGESIZE 4096 MANAGED BY SYSTEM         USING ('/db2_systmp')
         EXTENTSIZE 8
         BUFFERPOOL IBMDEFAULTBP;
DROP TABLESPACE TEMPSPACE1;

DROP TABLESPACE TBS_IDX_CISA_E, TBS_TABLE_CISA_E;

CREATE REGULAR TABLESPACE TBS_TABLE_CISA_E IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_jf_dta01'500M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;


CREATE REGULAR TABLESPACE TBS_IDX_CISA_E IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_jf_idx01'250M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;


drop tablespace userspace1;

CREATE REGULAR TABLESPACE USERSPACE1 IN DATABASE PARTITION GROUP IBMDEFAULTGROUP PAGESIZE 4096 MANAGED BY DATABASE
         USING (device '/dev/mapper/data_vg-db2_dta01'1000M)
         EXTENTSIZE 32
         PREFETCHSIZE AUTOMATIC
         BUFFERPOOL IBMDEFAULTBP
         OVERHEAD 12.670000
         TRANSFERRATE 0.180000
         DROPPED TABLE RECOVERY ON;
2009-09-02
浏览695

回答者

回答状态

  • 发布时间:2009-09-02
  • 关注会员:0 人
  • 回答浏览:695
  • X社区推广