ITPub博客

首页 > Linux操作系统 > Linux操作系统 > DB2数据库的备份测试--开始备份

DB2数据库的备份测试--开始备份

原创 Linux操作系统 作者:anycall2010 时间:2009-10-06 15:27:39 0 删除 编辑

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、做增量备份

[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

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8334342/viewspace-616033/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-24

  • 博文量
    182
  • 访问量
    559379