Symptom
From the 16.1 RLV manual we can read:
If the coordinator fails over, the RLV store is not automatically enabled on the new coordinator. The RLV store must be first disabled on the original node and then enabled on the designated failover node. Uncommitted RLV transactions are rolled back.
(https://help.sap.com/viewer/a893406f84f21015b779cc846d759839/16.1.3.3/en-US/a48d34c384f21015b011f0f51675f658.html)
• How do you disable RLV on the coordinator when it isn’t running?
• How do you recover the committed transactions that are in the RLV store that is tied to the coordinator that is down?
• What’s the detailed failover process for an MPX that includes an RLV store?
• With RLV in a multiplex, does IQ automatically change the ODBC connection string to the new coordinator? If not, what’s that process?
What we are looking for are simply more details about how to make RLV work in a production multiplex. From the looks of it in the current manuals, this just isn’t clear enough.
Read more...
Environment
SAP IQ 16.x
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.