Skip to content

Db2 11.1 Mod 4 Fix Pack 4

March 6, 2019

This fix pack was released on 27 Nov 2018 so it isn’t new but it has some enhancements worth moving to and exploiting. Reads on standby has been improved via reduction in replay window thru a the new  variable DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW.  The DB2_USE_ASYNC_FOR_MIRRORLOG variable can be used to improve mirror logpath performance by enabling log writing in parallel to the active and mirror log path.  The performance of online backups can be improved by using the new DB2_REDUCE_FLUSHING_DURING_BACKUP registry variable by reducing the amount of changed pages that have to be flushed from the bufferpool at online backup startup.

There are a bunch more of improvements, get all the details here: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.wn.doc/doc/c0061179.html#c0061179__MP4FP4

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: