Thursday, April 3, 2008

DB2: HADR Resync or Restablish

DB2 HADR Setup (Use when Databases Lose Connectivity or to Resynch Logs)
1. On the primary server issue:

db2 stop hadr on database icmnlsdb
2. On the primary server:
db2 BACKUP DATABASE [database] TO "/cm/dbfs/lsbak/offline/full" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS WITHOUT PROMPTING

Note: Document DB Backup Timestamp ICMNLSDB.0.db2inst1.NODE0000.CATN0000.20080320232702.001
3. FTP backup file to [standbyserver]:/cm/dbfs/lsbak/offline/full
4. On the standby server:

db2 restore database [database] from "/cm/dbfs/lsbak/offline/full" taken at 20080320232702 replace history file without rolling forward
Note: Timestamp = 20080320232702
There should be no need to change any other HADR parms as they should be maintained.

No comments: