增量备份的key points

1) trackmod是incremental/delta backup唯一必须设置参数
2) database incremental/delta backup可以offline, 但tablespace incremental/delta只能online
3) 若需要作online backup, db2 v9.5之前必须设置userexit或logretain,但db2 v9.7之后只须设置logarchmeth1, userexit 和 logretain 在Version 9.5已经废弃不用
4) trackmod设置yes后必须先做 full database backup后, 才能使用incremental/delta backup.
5) trackmod设置yes后,如果建立新表空间，必须要做包含该表空间的full database/tablespace backup,才能使用tablespace incremental/delta backup

另外，下面提供了database incremental/delta offline backup例子

1. DB CFG parameters:

Track modified pages                         (TRACKMOD) = ON

Default number of containers                            = 1
Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32

Max number of active applications            (MAXAPPLS) = AUTOMATIC(40)
Average number of active applications       (AVG_APPLS) = AUTOMATIC(1)
Max DB files open per application            (MAXFILOP) = 32768

Log file size (4KB)                         (LOGFILSIZ) = 1024
Number of primary log files                (LOGPRIMARY) = 13
Number of secondary log files               (LOGSECOND) = 4
Changed path to log files                  (NEWLOGPATH) =
Path to log files                                       = F:DB201NODE0000SQL00003SQLOGDIR
Overflow log path                     (OVERFLOWLOGPATH) =
Mirror log path                         (MIRRORLOGPATH) =
First active log file                                   =
Block log on disk full                (BLK_LOG_DSK_FUL) = NO
Block non logged operations            (BLOCKNONLOGGED) = NO
Percent max primary log space by transaction  (MAX_LOG) = 0
Num. of active log files for 1 active UOW(NUM_LOG_SPAN) = 0

Group commit count                          (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled             (LOGRETAIN) = OFF
User exit for logging enabled                (USEREXIT) = OFF

HADR database role                                      = STANDARD
HADR local host name                  (HADR_LOCAL_HOST) =
HADR local service name                (HADR_LOCAL_SVC) =
HADR remote host name                (HADR_REMOTE_HOST) =
HADR remote service name              (HADR_REMOTE_SVC) =
HADR instance name of remote server  (HADR_REMOTE_INST) =
HADR timeout value                       (HADR_TIMEOUT) = 120
HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC
HADR peer window duration (seconds)  (HADR_PEER_WINDOW) = 0

First log archive method                 (LOGARCHMETH1) = OFF
Options for logarchmeth1                  (LOGARCHOPT1) =
Second log archive method                (LOGARCHMETH2) = OFF
Options for logarchmeth2                  (LOGARCHOPT2) =

2. Backups
db2 => list history backup since 20120928 for bankdemo

                    List History File for bankdemo

Number of matching file entries = 3


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20120928101119001   F    D  S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
  Contains 3 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 SYSTOOLSPACE
----------------------------------------------------------------------------
    Comment: DB2 BACKUP BANKDEMO OFFLINE
Start Time: 20120928101119
   End Time: 20120928101127
     Status: A
----------------------------------------------------------------------------
  EID: 6 Location: F:


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20120928101318001   I    D  S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
  Contains 3 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 SYSTOOLSPACE
----------------------------------------------------------------------------
    Comment: DB2 BACKUP BANKDEMO OFFLINE
Start Time: 20120928101318
   End Time: 20120928101322
     Status: A
----------------------------------------------------------------------------
  EID: 7 Location: F:


Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log  Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
  B  D  20120928101604001   D    D  S0000000.LOG S0000000.LOG
----------------------------------------------------------------------------
  Contains 3 tablespace(s):

  00001 SYSCATSPACE
  00002 USERSPACE1
  00003 SYSTOOLSPACE
----------------------------------------------------------------------------
    Comment: DB2 BACKUP BANKDEMO OFFLINE
Start Time: 20120928101604
   End Time: 20120928101605
     Status: A
----------------------------------------------------------------------------
  EID: 8 Location: F: