IDS Forum

Re: HDR is not working

Posted By: Nagaraju Inturi
Date: Saturday, 10 February 2018, at 4:18 p.m.

In Response To: HDR is not working (MUKESH TANUKU)

Connection manager couldn't connect to primary server. Primary server assigns active arbitrator role to connection manager. Pls. check connect manager log file to check on why CM cannot connect to primary server.

Thanks & Regards,
Nagaraju

On 2/9/18, 11:21 PM, "ids-bounces@iiug.org on behalf of MUKESH TANUKU" <ids-bounces@iiug.org on behalf of mukeshbt1328@gmail.com> wrote:

Dear All,

In our environment we have configured HDR. it is successfully configured.

Today unexpectedly primary server got physically restarted with unknown

reason. But as per HDR setup application should redirect to secondary server,

which has not happened, still the secondary server is in Read-only mode.

Why is this happen?

Priamry DB details:

Online log:

08:00:08 Maximum server connections 172

08:00:08 Checkpoint Statistics - Avg. Txn Block Time 0.017, # Txns blocked 0,

Plog used 0, Llog used 2

09:54:53 SCHAPI: thread dbWorker1 task mon_chunk(6-3524) shutting down

09:54:53 SCHAPI: thread dbWorker2 task Low Memory Reconfig(47-3523) shutting

down

09:54:54 SCHAPI: thread dbScheduler(112) shutting down

Secondary DB details:

Online log:

08:00:08 Maximum server connections 110

08:00:08 Checkpoint Statistics - Avg. Txn Block Time 0.019, # Txns blocked 0,

Plog used 9, Llog used 0

09:55:09 DR: Receive error

09:55:09 dr_secrcv thread : asfcode = -25582: oserr = 0: errstr = : Network

connection is broken.

09:55:09 DR_ERR set to -1

09:55:10 DR: Turned off on secondary server

09:55:13 SMX thread is exiting

09:55:13 SMX thread is exiting

We are suing connection manager:

NAME cm_hdr1

LOG 1

LOGFILE C:\Connection_Manager\tmp\cm.log

CLUSTER hdr_cluster

{

INFORMIXSERVER dbserv_g

SLA oltp DBSERVERS=PRI

SLA report DBSERVERS=HDR,PRI

FOC ORDER=ENABLED PRIORITY=1

CMALARMPROGRAM C:\Connection_Manager\etc\cmalarmprogram.bat

}

Now immediately we have started the primary server. it is started in PRIM mode

only.

In primary if i execute the onstat -g cmsm it is showing nothing

Primary: onstat -g cmsm

IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 00:44:43

-- 4400896 Kbytes

Secondary: onstat -g cmsm

IBM Informix Dynamic Server Version 12.10.FC8 -- Read-Only (Sec) -- Up 2 days

14:15:47 -- 4925184 Kbytes

Unified Connection Manager: cm_hdr1 Hostname: WINHDRCM.iacirc.com

CLUSTER hdr_cluster LOCAL

Informix Servers: dbserv_g

SLA Connections Service/Protocol Rule

oltp 0 50008/onsoctcp DBSERVERS=PRI

report 0 50010/onsoctcp DBSERVERS=HDR,PRI

Failover Arbitrator: Failover is enabled

ORDER=ENABLED PRIORITY=1

Help me on this?

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

::DISCLAIMER::
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Messages In This Thread

• HDR is not working
  MUKESH TANUKU -- Saturday, 10 February 2018, at 12:20 a.m.
  • Re: HDR is not working
    Nagaraju Inturi -- Saturday, 10 February 2018, at 4:18 p.m.
  • Re: HDR is not working
    R MICHAEL -- Thursday, 15 February 2018, at 3:54 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.