DB2备份测试的开始备份的操作流程
此文章主要讲述的是DB2备份测试的开始备份的实际操作步骤，如果你对DB2备份测试的开始备份的实际操作步骤有兴趣的话，你就可以对以下的文章点击观看了，以下就是文章的详细内容介绍，望大家借鉴。
成都创新互联公司是一家专业提供井研企业网站建设,专注与成都网站制作、网站建设、外贸网站建设、H5响应式网站、小程序制作等业务。10年已为井研众多企业、政府机构等服务。创新互联专业网站设计公司优惠进行中。
DB2, DB2备份数据库, 实例, 讲解
1、做一个在线全备操作：
- [db2inst1@db2 ~]$ db2 backup db sample online to /tmp/db2inst1/sample/off_back include logs
- Backup successful. The timestamp for this backup image is : 20090917061921
2、创建一个表，并插入数据：
- db2 => connect to sample
- Database Connection Information
- Database server
- = DB2/LINUX 9.1.3
- SQL authorization ID
- = DB2INST1
- Local database alias
- = SAMPLE
- db2 => insert into sales1 select * from sales
- DB20000I
- The SQL command completed successfully.
- db2 => insert into sales1 select * from sales1
- DB20000I
- The SQL command completed successfully.
- db2 => insert into sales1 select * from sales1
- DB20000I
- The SQL command completed successfully
- db2 => select * from sales1
- SALES_DATE SALES_PERSON
- REGION
- SALES
- 12/31/2005 LUCCHESSI
- Ontario-South
- 1
- 12/31/2005 LEE
- Ontario-South
- 3
- 12/31/2005 LEE
- Quebec
- 1
- 12/31/2005 LEE
- Manitoba
- 2
- 12/31/2005 GOUNOT
- Quebec
- 1
- 03/29/2006 LUCCHESSI
- Ontario-South
- 3
- 03/29/2006 LUCCHESSI
- Quebec
- 。。。。。。。。。。。
3、DB2备份测试之做增量备份：
- [db2inst1@db2 ~]$ db2 backup db sample online incremental to /tmp/db2inst1/sample/off_back include logs
- Backup successful. The timestamp for this backup image is : 20090917062532
4、删除表操作：
- [db2inst1@db2 off_back]$ db2stop force
- 09/17/2009 06:26:47
- 0
- 0
- SQL1064N
- DB2STOP processing was successful.
- SQL1064N
- DB2STOP processing was successful.
- [db2inst1@db2 off_back]$ db2start
- 09/17/2009 06:26:57
- 0
- 0
- SQL1063N
- DB2START processing was successful.
- SQL1063N
- DB2START processing was successful.
- db2 => connect to sample
- Database Connection Information
- Database server
- = DB2/LINUX 9.1.3
- SQL authorization ID
- = DB2INST1
- Local database alias
- = SAMPLE
- db2 => drop table sales1
- DB20000I
- The SQL command completed successfully.
- db2 => select * from sales1
- SQL0204N
- "DB2INST1.SALES1" is an undefined name.
- SQLSTATE=42704
以上的相关内容就是对DB2备份测试的介绍，望你能有所收获。
【编辑推荐】
- IBM DB2 Content Manager V83与手工配置SSL
- 失败DB2® access 服务器配置的正确恢复流程
- DB2 V9.7启用索引压缩大揭秘
- DB2数据库备份参数修改后报错如何拯救？
- 手动安装DB2数据库的实现在UNIX操作环境下
网站名称：DB2备份测试的开始备份的操作流程
文章位置：http://zsjierui.cn/article/dpshicp.html