SLA listener failed Connection Manager shutdown

Posted in 2009

Summary

Jessica Flores' Connection Manager (oncmsm) with oltp and report SLAs on an HDR pair stopped with 'SLA listener failed'. Madison Pruet said the machine name and service for the CM define the CM's listener threads and he did not think two SLAs from one CM can use different IP addresses. Jak aka asked about onstat -m and SLA_WORKERS. Jessica thanked them; the fix was not stated.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: High Availability & Replication, Networking & sqlhosts Configuration, Clustering, Grid & MACH11

JESSICA FLORES — Thu, 26 Feb 2009 23:17:36 — source: IIUG Forums & Mailing Lists

Hi at all! I need help for this: I want to configure connection manager with Configuration File below: NAME cm1 SLA oltp=primary SLA report=HDR FOC HDR,5 SLA_WORKERS 16 DEBUG 2 LOGFILE /opt/IBM/informix/tmp/cm1.log I typed : oncmsm -c cmsm.cfg In the logfile last line appears: Error: SLA listener failed. Connection Manager shutdown. My INFORMIXSQLHOSTS is: hdrprim1 onsoctcp 192.168.100.128 9088 hdrsec1 onsoctcp 192.168.100.129 9089 oltp onsoctcp 192.168.100.128 9092 report onsoctcp 192.168.100.129 9093 I have a pair HDR working fine. Thanks for u attention.

↪ replying to JESSICA FLORES

Madison — Fri, 27 Feb 2009 00:34:17 — source: IIUG Forums & Mailing Lists

The machine name and service for the connection manager is defining the= listener threads for the CM, not for the server. I don't think that you can have different IP addresses for two SLA comi= ng from the same connection manager. ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "JESSICA FLORES" = <jessytapoli@hotm = ail.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect SLA listener failed Connection = 02/26/2009 05:17 Manager shutdown [15032] = PM = = = Please respond to = ids@iiug.org = = = Hi at all! I need help for this: I want to configure connection manager with Configuration File below: NAME cm1 SLA oltp=3Dprimary SLA report=3DHDR FOC HDR,5 SLA_WORKERS 16 DEBUG 2 LOGFILE /opt/IBM/informix/tmp/cm1.log I typed : oncmsm -c cmsm.cfg In the logfile last line appears: Error: SLA listener failed. Connection Manager shutdown. My INFORMIXSQLHOSTS is: hdrprim1 onsoctcp 192.168.100.128 9088 hdrsec1 onsoctcp 192.168.100.129 9089 oltp onsoctcp 192.168.100.128 9092 report onsoctcp 192.168.100.129 9093 I have a pair HDR working fine. Thanks for u attention. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to JESSICA FLORES

jak aka — Fri, 27 Feb 2009 04:55:13 — source: IIUG Forums & Mailing Lists

Hi , How about onstat -m ? What's SLA_WORKERS ? ________________________________ From: JESSICA FLORES <jessytapoli@hotmail.com> To: ids@iiug.org Sent: Friday, February 27, 2009 6:17:37 AM Subject: SLA listener failed Connection Manager shutdown [15032] Hi at all! I need help for this: I want to configure connection manager with Configuration File below: NAME cm1 SLA oltp=primary SLA report=HDR FOC HDR,5 SLA_WORKERS 16 DEBUG 2 LOGFILE /opt/IBM/informix/tmp/cm1.log I typed : oncmsm -c cmsm.cfg In the logfile last line appears: Error: SLA listener failed. Connection Manager shutdown. My INFORMIXSQLHOSTS is: hdrprim1 onsoctcp 192.168.100.128 9088 hdrsec1 onsoctcp 192.168.100.129 9089 oltp onsoctcp 192.168.100.128 9092 report onsoctcp 192.168.100.129 9093 I have a pair HDR working fine. Thanks for u attention. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Madison

Jessica T. — Thu, 05 Mar 2009 17:36:50 — source: IIUG Forums & Mailing Lists

...Yes.. You are right .. thanks.. > To: ids@iiug.org > From: mpruet@us.ibm.com > Subject: Re: SLA listener failed Connection Manager shu.... [15033] > Date: Thu, 26 Feb 2009 19:34:18 -0500 > > The machine name and service for the connection manager is defining the= > > listener threads for the CM, not for the server. > > I don't think that you can have different IP addresses for two SLA comi= > ng > from the same connection manager. > > ------------------------------------- > Madison Pruet, STSM > IDS Replication Architect > > = > > "JESSICA FLORES" = > > <jessytapoli@hotm = > > ail.com> = > To > > Sent by: ids@iiug.org = > > ids-bounces@iiug. = > cc > > org = > > Subj= > ect > > SLA listener failed Connection = > > 02/26/2009 05:17 Manager shutdown [15032] = > > PM = > > = > > = > > Please respond to = > > ids@iiug.org = > > = > > = > > Hi at all! > > I need help for this: > > I want to configure connection manager with Configuration File below: > > NAME cm1 > SLA oltp=3Dprimary > SLA report=3DHDR > FOC HDR,5 > SLA_WORKERS 16 > DEBUG 2 > LOGFILE /opt/IBM/informix/tmp/cm1.log > > I typed : oncmsm -c cmsm.cfg > > In the logfile last line appears: > > Error: SLA listener failed. Connection Manager shutdown. > > My INFORMIXSQLHOSTS is: > > hdrprim1 onsoctcp 192.168.100.128 9088 > hdrsec1 onsoctcp 192.168.100.129 9089 > > oltp onsoctcp 192.168.100.128 9092 > report onsoctcp 192.168.100.129 9093> > I have a pair HDR working fine. > > Thanks for u attention. > > ***********************************************************************= > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > = > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ ¿Qué hay de nuevo con tus contactos de Messenger? www.messengernews.com.mx

Related threads

Glossary

HDR
sqlhosts