Enabling reads on standby for Db2 Warehouse

You can enable the reads on standby feature on your HADR standby Db2 Warehouse database by using the DB2_HADR_ROS registry variable.

About this task

For full documentation, see Enabling reads on standby.

Important:

The reads on standby feature should be enabled prior to Starting an HADR configuration for Db2 Warehouse.
You cannot use automatic client reroute (ACR) if you enable reads on standby.

Procedure

Exec into the Db2 Warehouse pod with catalog partition and switch to the database instance owner:
```
oc exec -it c-db2wh-primary-db2u-0 -- bash
su - db2inst1
```
Use the db2set command to enable reads on standby:
```
db2set DB2_HADR_ROS=ON
```
Restart the Db2 Warehouse database.
```
db2stop
ipclean -a
db2start
```