Procedure for starting a backup in the DB2 backup Test

This article mainly describes the actual steps for starting a backup in the DB2 backup test. If you are interested in the actual steps for starting a backup in the DB2 backup test, you can click to view the following articles. The following is a detailed description of the articles. I hope you can learn from them.

DB2, DB2 backup database, instance, explanation

1. perform an online full backup operation:

 
 

  
  
[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. Create a table and insert data:

 
 

  
  
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. Perform Incremental backup for the DB2 backup test:

 
 

  
  
[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. delete a table:

 
 

  
  
[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 
 
 

The above content is an introduction to the DB2 backup test. I hope you will get some benefits.