IBM Support

Why request goes to Clone while Master is back after shutdown on keystore?

Technical Blog Post


Abstract

Why request goes to Clone while Master is back after shutdown on keystore?

Body

In case Master Node is down and Clone is set up in cfg file.
We can notice few of the Read only Query to Keystore goes to Clone server even after
Master Node is up.


In v11.1.2.2 we introduced a “blocklist” that servers are placed on when we get an error
from them. The default time they are on the blocklist is 5 minutes, after which we will try
them again. There is no command to reset the blocklist.

    
Any commands that require creating a new key, such as create database, are sent to the
Master key manager regardless of whether it is on the blocklist (so in affect the blocklist
is only for read requests).

If we have trouble reaching all servers (primary and clones), we reset the blocklist and
start again.

So with blocklist If Master is down it will be added to blocklist. And read-only request
will go to Clone.As Master will be on blocklist even if it comes up in next 5 minutes all

read-only request will go to Clone,as Master will remain in the blocklist.

 

After 5 minutes if Master is available it will be removed from blocklist and will continue
serving all request.

UNAVAILABLE_SERVER_BLACKOUT_PERIOD is variable control time for blocklist  5 minutes is default time.
 
UNAVAILABLE_SERVER_BLACKOUT_PERIOD
    Optional. The amount of time, in seconds, to skip sending key requests to a particular
    master or clone centralized key manager after a failed connection attempt or it has
    returned errors. This parameter was introduced in Db2 V11.1.2.2. Default value: 300 seconds.

 

[{"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

ibm13286101