Sunday

Mon

Tue

Wed

Thu

Fri

Sat

Sunday

Full

Full

Cumulative Backups 

Full

Delta Backups 

Full

Figure 8 1   Incremental backup

Example 8 1   Incremental backup

db2>backup database itsodb2 to /home/itso/backup

db2>backup database itsodb2 INCREMENTAL to /home/itso/backup_inc

db2>backup database itsodb2 INCREMENTAL DELTA to /home/itso/backup_delta

Database restore

DB2 UDB database restore is as easy as taking database backup. This can be 

done by using the

 RESTORE

utility. The restore database command rebuilds the 

database data or table space that was backed up using the backup command 

above. This utility supports full and incremental database restore. Incremental 

database restore can be automatic or manual. Example 8 2 shows automatic 

incremental restore, and Example 8 3 shows manual incremental restore.

Example 8 2   Automatic incremental restore

db2>restore database itsodb2 INCREMENTAL AUTOMATIC from /home/itso/backup taken 

at 20040116

Example 8 3   Manual incremental restore

db2>create database itsodb2new1

db2>restore database itsodb2 INCREMENTAL from /home/itso/backup taken at 

20040114

db2>restore database itsodb2 INCREMENTAL from /home/itso/backup taken at 

20040114

db2>restore database itsodb2 INCREMENTAL from /home/itso/backup taken at 

20040114

238 

MySQL to DB2 UDB Conversion Guide