Connection Manager - Sessions Terminate Abnormally
User reported that when shutting down Connection Manager with 3 Informix instances (each with HDR secondary), some instances successfully deregistered while others terminated abnormally. Initial configuration clarification revealed a misconfiguration: user had 3 primary instances each with HDR secondaries, which is invalid—only one primary and one HDR secondary are supported.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
3 Informix instances setup on a HDR pair w/Connection Manager. When I shutdown Connection Manager, I look at the database online logs and see some of the instances successfully de-registering from Connection Manager; whereas others terminate abnormally. What factors would cause this issue? I'm running 11.7 FC7 with CSDK 3.70.
Hi Jacob. One doubt, you have a primary, one sds, plus one hdr sec instances, is that your configuration? Please specify exactly what instance(s) were successfully disconnected from CM, and what was not (if that is always the same behaviour, I mean). Also please send us the last lines of one instance that was terminated abnormally, that should give us some idea of what could be going on.... Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: jacobshadix@gmail.com > Subject: Connection Manager - Sessions Terminate Abnormally [33898] > Date: Thu, 2 Oct 2014 23:21:19 -0400 > > 3 Informix instances setup on a HDR pair w/Connection Manager. When I shutdown > Connection Manager, I look at the database online logs and see some of the > instances successfully de-registering from Connection Manager; whereas others > terminate abnormally. What factors would cause this issue? I'm running 11.7 > FC7 with CSDK 3.70. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
I have 3 primary instances and 3 hdr secondary instances. The instances that terminate abnormally appear to be random; I don't see a pattern. Here's the error - CM:Session for Connection manager connmgr1 terminated abnormally
Ok I see. You could just check the CM's log file, for any kind of specific detail about the reason. On the engines, you might see any network error (25580, or similar)? Do you have a good network between each primary and secondary nodes?? How is your HDR configured (synchronous or asynchronous mode)?? Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: jacobshadix@gmail.com > Subject: Re: RE: Connection Manager - Sessions Terminat.... [33903] > Date: Fri, 3 Oct 2014 13:37:55 -0400 > > I have 3 primary instances and 3 hdr secondary instances. The instances that > terminate abnormally appear to be random; I don't see a pattern. Here's the > error - CM:Session for Connection manager connmgr1 terminated abnormally > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
This is a misconfiguration. You can only have one primary instance and only one HDR secondary. The= other secondary must be either SDS or RSS. From: "JACOB SHADIX" <jacobshadix@gmail.com> To: ids@iiug.org Date: 10/03/2014 12:39 PM Subject: Re: RE: Connection Manager - Sessions Terminat.... [33903] Sent by: ids-bounces@iiug.org I have 3 primary instances and 3 hdr secondary instances. The instances= that terminate abnormally appear to be random; I don't see a pattern. Here's= the error - CM:Session for Connection manager connmgr1 terminated abnormall= y ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
let me rephrase, I have 3 instances - ifx1, ifx2, ifx3 and then each of these has a designated HDR secondary. sorry for the confusion