Question & Answer
Question
Does IBM Content Navigator (ICN) support a DB2 HADR environment with the reads on standby (ROS) feature enabled?
Cause
DB2 HADR consists of two or more databases. One is the primary where all applications connect, by default. The other is the standby, which sits idle. When the primary goes down, the standby becomes the new primary.
ROS stands for Reads On Standby. More information can be found here -> https://www.ibm.com/docs/en/db2/11.5?topic=feature-enabling-reads-standby.
When ROS is enabled and a failover situation occurs, the ICN application will connect to its standby CONFIGURATION database instead of to the primary database, and this can cause unexpected results. For example, some users may find that they are unable to access their desktops. Also, ICN administrators may find some desktops missing when accessing the ICN administration desktop.
Answer
For this reason, ROS feature is not supported for the ICN CONFIGURATION database.
To ensure that the ROS feature is disabled, complete the following steps:
1) Open a DB2 command window.
2) Run the db2set command. If the DB2_HADR_ROS property is set to YES, complete the following steps:
3) Run the following command to set the DB2_HADR_ROS property to OFF on the :
db2set DB2_HADR_ROS=OFF
4) Stop and then restart the DB2 instance on Standby for the update to take effect:
db2stop
db2start
2) Run the db2set command. If the DB2_HADR_ROS property is set to YES, complete the following steps:
3) Run the following command to set the DB2_HADR_ROS property to OFF on the :
db2set DB2_HADR_ROS=OFF
4) Stop and then restart the DB2 instance on Standby for the update to take effect:
db2stop
db2start
5) Ensure databases are activated after restart of Standby by running:
db2pd -hadr -alldbs
db2pd -hadr -alldbs
[{"Type":"MASTER","Line of Business":{"code":"LOB18","label":"Miscellaneous LOB"},"Business Unit":{"code":"BU056","label":"Miscellaneous"},"Product":{"code":"SSEUEX","label":"IBM Content Navigator"},"ARM Category":[{"code":"a8m3p000000LRzEAAW","label":"IBM Content Navigator-\u003EInstallation \u0026 Configuration"}],"ARM Case Number":"TS017910112","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
15 April 2025
UID
ibm17184193