IBM Support

Can we assign different master key on primary and standby Database in HADR?

Technical Blog Post


Abstract

Can we assign different master key on primary and standby Database in HADR?

Body

The same master key must be used on both primary and standby.  A key rotation on the primary will drive a key rotation automatically on the standby.
 It’s possible that they can start out with different keys, but they will come into sync during the first key rotation. 

We can not keep different Key in Primary and Standby as a long term solution.

 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13286107