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博客 ” ，链接：https://blog.itpub.net/8334342/viewspace-616033/ ，如需转载，请注明出处，否则将追究法律责任。
