Detection of Secondary
Kate asked how to tell, on 11.50.FC8 with HDR, whether an instance is primary or secondary at startup. Answers: Bob said onstat - shows it; Sam Gentsch suggested oncheck -pr and its DR Last Mode Change line (8 secondary, 7 primary), with INFORMIXCONTIME and INFORMIXCONRETRY set to speed it up; Dick Snoke said to query sysfeatures in sysmaster.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hey gurus, I need to know how to determine if an instance is the primary or secondary when it starts up. I want this so I can delay the start up of a secondary in my scripts and give the primary time to start up first. This is for when all the servers are shut down and restarted. This is in Version 11.50.FC8 with HDR on a HP Itanium 11.23 server. Does anyone know an online command for this? Or do I have to look in the logs? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratliffe
When it starts up, it should be noted in the output from "onstat -" whether
it's a primary or secondary.
Bob
----- Original Message -----
From: "kate" <kate@iiug.org>
To: ids@iiug.org
Sent: Wednesday, March 2, 2011 1:48:21 PM
Subject: Detection of Secondary [22963]
Hey gurus,
I need to know how to determine if an instance is the primary or secondary
when it starts up. I want this so I can delay the start up of a secondary in
my scripts and give the primary time to start up first. This is for when all
the servers are shut down and restarted. This is in Version 11.50.FC8 with
HDR on a HP Itanium 11.23 server.
Does anyone know an online command for this? Or do I have to look in the logs?
Thanks!
Kate Tomchik [ kate@iiug.org ] www.iiug.org
International Informix Users Group Board of Directors
A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
Mitch Ratliffe
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
You might want to export the following to reduce the time an oncheck -pr takes
to run for an offline engine.
export INFORMIXCONTIME=1
export INFORMIXCONRETRY=0
oncheck -pr |grep 'DR Last Mode Change'
on secondary DR Last Mode Change 8 Secondary mode
on primary:
DR Last Mode Change 7 Primary mode
disclaimer -- this was discovered by tiral and error...
Sam
You can get this by querying the sysfeatures view in sysmaster. Cheers, Dick Snoke IBM ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "kate" <kate@iiug.org> To: ids@iiug.org Date: 03/02/11 01:49 PM Subject: Detection of Secondary [22963] Sent by: ids-bounces@iiug.org Hey gurus, I need to know how to determine if an instance is the primary or secondary when it starts up. I want this so I can delay the start up of a secondary in my scripts and give the primary time to start up first. This is for when all the servers are shut down and restarted. This is in Version 11.50.FC8 with HDR on a HP Itanium 11.23 server. Does anyone know an online command for this? Or do I have to look in the logs? Thanks! Kate Tomchik [ kate@iiug.org ] www.iiug.org International Informix Users Group Board of Directors A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratliffe ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.