Found it. The sysmaster:sysdri table has exactly the info I need, including the name of the other database server in the HDR pair!

Thanks,

Sean.

-----Original Message-----
From: informix-list-bounces (AT) iiug (DOT) org [mailto:informix-list-bounces (AT) iiug (DOT) org] On Behalf Of Sean Baker
Sent: Thursday, May 26, 2011 7:51 AM
To: informix-list (AT) iiug (DOT) org
Subject: Query for database HDR mode?

I'm trying to determine from within an SPL routine what HDR mode the current database is in (standard, primary or secondary). Is there anything in systables that has this information? I've looked at sysopendb, but it doesn't seem to have that info.

Even better, if I can detect that I'm on a secondary server, is there a wayto lookup the primary server?

We're on IDS 11.50.FC6.

Thanks,

Sean.
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list