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

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