Execute method on failover member (mirror)

Question

Question

Mathew Lambert · May 3, 2018

#HealthShare

I need to know what options exist to execute methods on the failover members of a mirror system from the primary.

Discussion (4)1

Log in or sign up to continue

Robert Cemper · May 3, 2018

as Jeff mentioned: the Shadowed DB is Read Only.

Execution of some code in a remote instance of Caché is independent of Mirror or not

Either pack your code (or its call) into a ClassMethod with a return value.
mark the Method as [SqlProc ]
trigger it by SELECT my.procedure()
Or wrap it into some WebService ( REST, SOAP) and execute it that way.

0 0

score 0 · Answer 1 · 2018-05-03T12:31:41-04:00

The primary practical difference is that the mirror backup databases are mounted read-only, so any methods you might run on a mirror backup can't make changes to the database(s).

Can you provide any additional detail as to what you're trying to do?

score 0 · Answer 2 · 2018-05-04T03:57:22-04:00

Yes. Connect to Mirror using SQLgateway.
Link Procedure And then just to a SELECT or CALL.
The code has, of course, to be prepared already on Mirror.

score 0 · Answer 3 · 2018-05-04T01:52:25-04:00

I know that the mirrored DB's are in read-only.

With the SqlProc sollution, how do I execute the call from the primary to the secondary? Using ODBC?

Thank you