FW: Query for database HDR mode?

Posted in 2011

Sean Baker — Thu, 26 May 2011 08:24:17 -0700 — source: Usenet: comp.databases.informix

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@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Sean Baker Sent: Thursday, May 26, 2011 7:51 AM To: informix-list@iiug.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 way to lookup the primary server? We're on IDS 11.50.FC6. Thanks, Sean. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list