Oninit cdi / Archive
Talk to an expert →

Detection of Secondary

Posted in 2011

Topics: High Availability & Replication, Versions, Editions & End-of-Life

kate — — source: IIUG Forums & Mailing Lists

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

↪ replying to kate
rroussey@comcast.net — — source: IIUG Forums & Mailing Lists

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.

↪ replying to rroussey@comcast.net
SAM GENTSCH — — source: IIUG Forums & Mailing Lists

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

↪ replying to kate
Richard Snoke — — source: IIUG Forums & Mailing Lists

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.

Glossary