Performing an incremental cumulative database backup

Incremental database backups help reduce backup times by tracking changes since the most recent full backup, in the case of an incremental cumulative backup.

Getting ready

Compared to an incremental delta backup, this backup may take a while longer to operate, since it picks up everything from the last full backup. Allow a larger maintenance window than for an incremental delta.

How to do it...

In our example, we created a table, POS.PAYMENT, since our last full backup, and we did an incremental delta backup. Now, let's add some data to the table, to have some activity on the database.

1. Database transactions:

   [db2inst1@nodedb21 ~]$ db2 "insert into POS.PAYMENT
   ( nofact   ,
     nopaiem  ,
     nolot    ,
     datepaim ,
     total    ,
     paiem    ,
     debit    ,
     visa     ,
     mv       ,
     remclnt ) values  
    (5493, 1, 78, to_date('201010191543','YYYYMMDDHH24MI'), 5.50, 'DT', 6.00, null, null, null),
    (5496, 1, 78, to_date('201010191748','YYYYMMDDHH24MI...