When we have Database Encryption is setup with Master-Clone node in KeySecure.
If Master Node is down,we may get error while Creating database.

When MASTER Node is down in Kesecure:
 

db2 create db test encrypt

SQL1782N  The command or operation failed because an error was encountered

accessing the centralized key manager. Reason code "5:111".

 

A new master key is automatically added when you create an encrypted database without
specifying the MASTER KEY LABEL option on the CREATE DATABASE command.

Clone servers are considered read only and are only used for retrieving
existing master keys from the centralized keystore. Clone servers are not used when
inserting a new key.

Workaround:
a) Set your master server to your clone IP.
b) Create the master key on KeySecure ahead of time when Master is available before using create db.
 

Tags:  database create master clone sql1782n encrypt