> Documentation > Backup and Restore Agents > Databases > DB2 > DB2 Backup Administrator Guide > DB2 High Availability Disaster Recovery (HADR)

Setting DB2 Configuration Parameters for DB2 HADR Using IBM Tivoli System Automation (TSA) with a Virtual IP Address

You can configure the primary and standby database by using the DB2 command line interface.

Procedure

Primary Database

  • Use the DB2 command line interface to configure the following DB2 parameters.

    Substitute the Primary_Database_Name parameter with the name of your primary database.

    Substitute the CVClientName parameter with the Virtual client name.

    db2 update db cfg for Primary_Database_Name using TRACKMOD on 
db2 update db cfg for Primary_Database_Name using LOGARCHMETH1 "'VENDOR:software_instalation_location/Base/libDb2Sbt.so'" 
db2 update db cfg for Primary_Database_Name using LOGARCHOPT1 "'CvClientName=<Virtual Client Name>,CvInstanceName=Instance001'" 
db2 update db cfg for Primary_Database_Name using VENDOROPT "'CvClientName=<Virtual Client Name>,CvInstanceName=Instance001'" 
db2 update db cfg for Primary_Database_Name using LOGINDEXBUILD on 
db2 update db cfg for Primary_Database_Name using INDEXREC RESTART

Standby Database

  • Use the DB2 command line interface to configure the following DB2 parameters.

    Substitute the Primary_Database_Name parameter with the name of your primary database.

    Substitute the CVClientName parameter with the Virtual client name.

    db2 update db cfg for Primary_Database_Name using TRACKMOD on 
db2 update db cfg for Primary_Database_Name using LOGARCHMETH1 "'VENDOR:software_instalation_location/Base/libDb2Sbt.so'" 
db2 update db cfg for Primary_Database_Name using LOGARCHOPT1 "'CvClientName=<Virtual Client Name>,CvInstanceName=Instance001'" 
db2 update db cfg for Primary_Database_Name using VENDOROPT "'CvClientName=<Virtual Client Name>,CvInstanceName=Instance001'" 
db2 update db cfg for Primary_Database_Name using LOGINDEXBUILD on 
db2 update db cfg for Primary_Database_Name using INDEXREC RESTART

Loading...