Connection manager parametrs

Can anyone help us out that we are not able to find detailed documentation about “informix connection manager” like what are the optional parameters to define SLA. And what does “timeout value” in FOC of “connection manager” mean? regards, Kamran

In IDS 11 Replication Redbook http://www.redbooks.ibm.com/redbooks/SG247488/wwhelp/wwhimpl/java/html/wwhelp.htm refer to Chapter 8, it talks about connection manager in detail. Regards, Nilesh ids-bounces@iiug.org wrote on 05/01/2009 09:21:44 AM: > [image removed] > > Connection manager parametrs [15649] > > KAMRAN HAQ > > to: > > ids > > 05/01/2009 09:25 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Can anyone help us out that we are not able to find detailed documentation > about “informix connection manager” like what are the optional parameters to > define SLA. > And what does “timeout value” in FOC of “connection manager” mean? > regards, > Kamran > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Nilesh Ozarkar wrote: > In IDS 11 Replication Redbook > http://www.redbooks.ibm.com/redbooks/SG247488/wwhelp/wwhimpl/java/html/wwhelp.htm > refer to Chapter 8, it talks about connection manager in detail. > > Regards, > Nilesh > > > ids-bounces@iiug.org wrote on 05/01/2009 09:21:44 AM: > > > [image removed] > > > > Connection manager parametrs [15649] > > > > KAMRAN HAQ > > > > to: > > > > ids > > > > 05/01/2009 09:25 AM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids > > > > Can anyone help us out that we are not able to find detailed > documentation > > about “informix connection manager” like what are the optional parameters > to > > define SLA. > > And what does “timeout value” in FOC of “connection manager” mean? > > regards, > > Kamran > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > Easy for you to say! -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com The following is a disclaimer and a protest at the collection, retention and sharing of my personal mail by the morally bankrupt state. By adding a string of key words, it will guarantee that each and every mail that I send will now need to be manually viewed as it is picked up by the auto scan software. If every person in the UK does exactly the same, then the entire system will quickly become so unmanageable, so unwieldy that it will become unworkable. Key words: bomb, assassinate, president, brown, Osama, Obama, Sarkozy, Merkel, government, target, location, rocket, grenade, al-Qaeda, Pakistan, India, Afghanistan, UK, America, guns, jets, bombs, machine-gun, terrorists, MP's, pigs, troughs, France, Germany, Italy, nuclear, Korea. PPS If you are reading this because you've picked up the above keywords: I hope your parents are proud of what you have become. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Resending original message: In IDS 11 Replication Redbook http://www.redbooks.ibm.com/redbooks/SG247488/wwhelp/wwhimpl/java/html/wwhelp.ht m refer to Chapter 8, it talks about connection manager in detail. Regards, Nilesh

Hi, Not sure where you were looking, but the Connection Manager is documented in the Administrator's Guide here: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.admin.doc/id s_admin_1210.htm And in the Administrator's Reference here: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adref.doc/id s_adr_0617.htm The timeout_value specifies the amount of time (in seconds) to wait before performing a failover. Please let me know if you cannot find the information you need. Regards, Bill

Thanks for that link it really helped alot. But it does not tell about the SLA_WORKER, can some tell howmany SLA_WORK would be appropriate for about 500 connection on average? Can we change the FOC parameter without restarting the connection manager? How can we configure the cmsm.cfg and enviornment script for Connection Manager so that one connection manager can handle more than one clusters (e.g., having SLA for PRIMARY server od both cluster). We are running more than one instance and trying to configure the single Connection Manager for all these instance. regards, Kamran

ids-bounces@iiug.org wrote on 05/14/2009 12:36:45 PM: > [image removed] > > Re: Connection manager parametrs [15772] > > KAMRAN HAQ > > to: > > ids > > 05/14/2009 12:38 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Thanks for that link it really helped alot. But it does not tell abou= t the > SLA_WORKER, can some tell howmany SLA_WORK would be appropriate for a= bout 500 > connection on average? I presume this is pretty much similar to what poll_threads option in NETTYPE parameter specify.Refer to http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adr= ef.doc/ids_adr_0116.htm for more details. > Can we change the FOC parameter without restarting the connection manager? yes, you can reload configuration file without restarting the connectio= n manager oncmsm -r <connection manager instance name> > How can we configure the cmsm.cfg and enviornment script for Connecti= on > Manager so that one connection manager can handle more than one clust= ers > (e.g., having SLA for PRIMARY server od both cluster). We are running= more > than one instance and trying to configure the single Connection Manag= er for > all these instance. I don't think currently you can setup single connection manager to supp= ort two different clusters. Why would you want to do that ? Can application= s work with any of the primary of those two clusters ? > regards, > Kamran > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=

Thanks for following command: oncmsm -r <connection manager instance name> Web URL is no more valid I think: http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adr= ef.doc/ids_adr_0116.htm We have two applications with very different load on databases (i.e.,TPS,memory requirement,CPU utilization etc) so we configured 2 different databases residing on different instances (we tested that, that way we got better throughput). Each application will communicate only with its own database not with the other one. The setup is somewhat like: DB server1 Primary [instance1, instance2] DB server2 HDR [instance1, instance2] DB server3 RSS [instance1, instance2] We are trying to run two connection manager (cluster of Connection Manager so that if one ConMgr gets down the other will replace it), but we are trying that if we can run a single Conection Manager to cope with both clusters on one machine, and another standby Connection Manager on some other machine.