HADR SUPERASYNC Mode

IBM introduced SUPERASYNC mode in DB2 9.7 along with the ability to read on the STANDBY. Both of these settings provide clients with additional flexibility in implementing HADR. By setting the HADR_SYNCMODE to SUPERASYNC, the STANDBY remains in REMOTE CATCHUP and won’t cause back-pressure on the PRIMARY. The read only on the STANDBY (ROS) is enabled by setting the DB2_HADR_ROS registry variable to ON. ROS can be used in all HADR synchronization modes. That’s the view from here…..