DB2資料庫的備份測試--開始備份

anycall2010發表於2009-10-06
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、做增量備份

[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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章