Forum Discussion

SnirA's avatar
SnirA
Level 4
11 years ago

how to Backup db2 with hadr

Hi, I got a question Regarding backup of db2 that uses hadr.   I didnt see any explain on this from netbackup documentation side and i been wondering if there is any "best practice" on how to d...
7.5
AIX
Backing Up
Backup and Recovery
Best Practice
NetBackup
  • SnirA's avatar
    SnirA
    11 years ago

    yes, its true.

    Already did it and its working fine.

     

    we are not using ipaddress to backup the cluster node as there are 9 databases on those 2 nodes.

    we just created a mini script inside the db2_Backup script.

    if answer is true db2 run the backup if its false it exist with status 0.

     

Marianne's avatar
Marianne
Level 6
11 years ago

My understanding of hadr is a clustered installation that includes replication to a DR/remote site. Is that how it is configured in your environment?

Do you fail over production to the DR site on a regular basis, or only in the event of a disaster?
Do you only need to backup the cluster on the production site?

Clustered installations need NBU to be installed and configured on each node.
Ensure successful forward and reverse lookup between master, media server(s) and cluster nodes as well as the Virtual hostname for the DB2 instance.

Specify the virtual DB2 name as the client name in the policy.
Ensure backup scripts exist on both nodes in same location or on shared storage. Same for db2.conf.
 
Use these steps in NBU for DB2 manual to create/update bp.conf on cluster nodes:
Configuring bp.conf files in a cluster environment