The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
with Tags:
standby
X
X
DB2 : SQL2038N while reading a log file on HADR Primary
Recently, we had a case where customer reported of problems on Primary HADR when their Q-replication was trying to read a log but failed with SQL2038N. Problem Description : Customer used TSM for log archiving and the log archival location was shared between Primary(write to TSM) and Standby(read from TSM). When Q-rep tried to read a log on Primary, it reported the following error : ASN0005E CAPTURE "ASN01" : "LogrdThread". The Capture program encountered an error when reading the DB2... [More]
Tags: disk primary shared sql2038n standby qrep tsm hadr |
How to achieve master key rotation in HADR setup?
A key rotation on the primary will drive a key rotation automatically on the standby. The key rotation on the standby is not instantaneous. The key rotation is written on regular log records, and is not sent to the standby until a other log records are sent. So it’s possible and expected that you could do a key rotation on the primary, and then immediately check for the key rotation on the standby and not see it. Some write activity at the primary is required to drive sending the log records. There is no explicit command to force... [More]
Tags: primary standby key hadr rotation |
In HADR can we have one of Primary/Standby as encrypted DB while other is not?
Our recommendation is that both primary and standby are encrypted. However, running with an encrypted primary and a non-encrypted standby is supported, but only for enabling Native encryption in existing setup without complete outage.(i.e. Online implementation) It’s not intended to be a long term solution. if we enforced that both primary and standby had to be encrypted, you would not be able to use this online method of enabling encryption. You’d have to shutdown both primary and standby (whole system offline), enable... [More]
Tags: standby hadr encryption primary |
Why were connections attempted on HADR Standby ?
We had a customer with HADR+TSA setup in place. For about 3 hour period they noticed extreme workload and hence system (Primary) was almost hung most times. During this period, they saw a lot of connections made to standby db but there was no takeover through TSA. How did connections go to HADR standby db when no TAKEOVER command manually or by TSA was issued ? On investigation, we could confirm that - while primary db was in hung state intermittently due to workload, on standby db there were numerous connections attempts which... [More]
Tags: standby client hadr automatic sql1776n tsa primary reroute acr |
In DB2LUW why SYSIBMADM.LOG_UTILIZATION is returning SQL0801N
Using SYSIBMADM.LOG_UTILIZATION to retrieve log utilization details. But, getting a SQL0801 error. Example, => db2 "select LOG_UTILIZATION_PERCENT from SYSIBMADM.LOG_UTILIZATION" LOG_UTILIZATION_PERCENT ----------------------- SQL0801N Division by zero was attempted. SQLSTATE=22012 This can happen if this Admin View is used in a HADR standby database. In HADR standby all the columns returned by LOG_UTILIZATION will be zero. As a result of that the... [More]
Tags: standby ibm-blog log_utilization hadr db2luw |
