cheeseman-support
asked on
DB2 HADR > Read From Standby and Write To Primary
Is it possible to read from an HADR Standby (read-only) database and write back to the Primary database without using a middle-man application or script? I have some hard hitting processes that I would like to read from Standby and perform updates on the Primary database.
For example:
Do you have any recommendations on performing such tasks?
For example:
INSERT INTO primary.table SELECT * FROM standby.table
If this is possible, what is the likelihood of encountering concurrency or other issues? Do you have any recommendations on performing such tasks?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i don't understand why you want to do that
if the data in on the stand by, it is already in the primary as well
if the data in on the stand by, it is already in the primary as well
ASKER
The reason I've been asked to do this is to eliminate as many reads to the Primary database for in-house applications that are not part of our ERP. Some reads are very large transactions for generating financial and costing information. The goal is to enhance the internal customer perception of the performance of our ERP.
We have had some DB2 performance issues for the last few months with no obvious solution. Although we do not believe our custom applications are the cause of the DB2 performance issues, we believe they may exacerbate them.
We have had some DB2 performance issues for the last few months with no obvious solution. Although we do not believe our custom applications are the cause of the DB2 performance issues, we believe they may exacerbate them.
ASKER
On the second part of the question... is ANYONE doing anything like this? That is to say.. Read from standby, generate insert/update/merge/etc statements and execute against the Primary.