Question for Connection manager and SDS
I have 2 question for IDS11.50 SDS 1. What is the machanism of Connect Manger to select the dabase server ? Round robin , random ? For example : SLA CMport=(dbport1+dbport2+dbport3) Can we set up the additional rule for CM such as use dbport1 40%, dbport2 30%, dbport3 30% ? 2. When using SDS (2 machine ,1 Primary - 1 SDS). If Primary crash, Can users access (write/read) SDS without restart database ? Do I have to force SDS to be primary ? Best Regards, Jakkrit A.
See below ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "jak aka" = <jakkritakeng@yah = oo.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Question for Connection manager = and 02/04/2009 12:22 SDS [14718] = AM = = = Please respond to = ids@iiug.org = = = I have 2 question for IDS11.50 SDS 1. What is the machanism of Connect Manger to select the dabase server = ? Round robin , random ? For example : SLA CMport=3D(dbport1+dbport2+dbport3) Can we set up the additional rule for CM such as use dbport1 40%, dbpor= t2 30%, dbport3 30% ? The Connection Manager utilizes the SLA as far as order of the groups, = but also considers the workload on eash of the nodes within that SLA level.= This includes the number of CPU cycles that it could have utilized, the= number of threads on the ready queue, the number of sessions alread on = that node, etc. 2. When using SDS (2 machine ,1 Primary - 1 SDS). If Primary crash, Can= users access (write/read) SDS without restart database ? Do I have to force S= DS to be primary ? You would need to convert one of the other nodes into a primary. Best Regards, Jakkrit A. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
Is there an online example/article on setting up any of the new HA servers (RSS, SDS, etc) at ibm.com or in the v11 manuals? Bob ----- Original Message ----- From: "Madison Pruet" <mpruet@us.ibm.com> To: ids@iiug.org Sent: Wednesday, February 4, 2009 10:08:24 AM GMT -05:00 US/Canada Eastern Subject: Re: Question for Connection manager and SDS [14732] See below ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "jak aka" = <jakkritakeng@yah = oo.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Question for Connection manager = and 02/04/2009 12:22 SDS [14718] = AM = = = Please respond to = ids@iiug.org = = = I have 2 question for IDS11.50 SDS 1. What is the machanism of Connect Manger to select the dabase server = ? Round robin , random ? For example : SLA CMport=3D(dbport1+dbport2+dbport3) Can we set up the additional rule for CM such as use dbport1 40%, dbpor= t2 30%, dbport3 30% ? The Connection Manager utilizes the SLA as far as order of the groups, = but also considers the workload on eash of the nodes within that SLA level.= This includes the number of CPU cycles that it could have utilized, the= number of threads on the ready queue, the number of sessions alread on = that node, etc. 2. When using SDS (2 machine ,1 Primary - 1 SDS). If Primary crash, Can= users access (write/read) SDS without restart database ? Do I have to force S= DS to be primary ? You would need to convert one of the other nodes into a primary. Best Regards, Jakkrit A. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Yes, here are the links Redbook - http://www.redbooks.ibm.com/abstracts/SG247488.html?Open v11 Manual - http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adm= in.doc/ids_admin_1162.htm Regards, Nilesh ids-bounces@iiug.org wrote on 02/04/2009 11:50:06 AM: > [image removed] > > Re: Question for Connection manager and SDS [14741] > > rroussey@comcast.net > > to: > > ids > > 02/04/2009 11:51 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Is there an online example/article on setting up any of the new HA servers > (RSS, SDS, etc) at ibm.com or in the v11 manuals? > > Bob > > ----- Original Message ----- > From: "Madison Pruet" <mpruet@us.ibm.com> > To: ids@iiug.org > Sent: Wednesday, February 4, 2009 10:08:24 AM GMT -05:00 US/Canada Eastern > Subject: Re: Question for Connection manager and SDS [14732] > > See below > > ------------------------------------- > Madison Pruet, STSM > IDS Replication Architect > > =3D > > "jak aka" =3D > > <jakkritakeng@yah =3D > > oo.com> =3D > To > > Sent by: ids@iiug.org =3D > > ids-bounces@iiug. =3D > cc > > org =3D > > Subj=3D > ect > > Question for Connection manager =3D > and > > 02/04/2009 12:22 SDS [14718] =3D > > AM =3D > > =3D > > =3D > > Please respond to =3D > > ids@iiug.org =3D > > =3D > > =3D > > I have 2 question for IDS11.50 SDS > > 1. What is the machanism of Connect Manger to select the dabase serve= r =3D > ? > Round > robin , random ? > > For example : > > SLA CMport=3D3D(dbport1+dbport2+dbport3) > Can we set up the additional rule for CM such as use dbport1 40%, dbp= or=3D > t2 > 30%, > dbport3 30% ? > > The Connection Manager utilizes the SLA as far as order of the groups= , =3D > but > also considers the workload on eash of the nodes within that SLA leve= l.=3D > > This includes the number of CPU cycles that it could have utilized, t= he=3D > > number of threads on the ready queue, the number of sessions alread o= n =3D > that > node, etc. > > 2. When using SDS (2 machine ,1 Primary - 1 SDS). If Primary crash, C= an=3D > > users > access (write/read) SDS without restart database ? Do I have to force= S=3D > DS > to > be primary ? > > You would need to convert one of the other nodes into a primary. > > Best Regards, > Jakkrit A. > > *********************************************************************= **=3D > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > =3D > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >=
Thank you sir! Bob ----- Original Message ----- From: "Nilesh Ozarkar" <nilesho@us.ibm.com> To: ids@iiug.org Sent: Wednesday, February 4, 2009 1:54:24 PM GMT -05:00 US/Canada Eastern Subject: Re: Question for Connection manager and SDS [14746] Yes, here are the links Redbook - http://www.redbooks.ibm.com/abstracts/SG247488.html?Open v11 Manual - http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adm= in.doc/ids_admin_1162.htm Regards, Nilesh ids-bounces@iiug.org wrote on 02/04/2009 11:50:06 AM: > [image removed] > > Re: Question for Connection manager and SDS [14741] > > rroussey@comcast.net > > to: > > ids > > 02/04/2009 11:51 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Is there an online example/article on setting up any of the new HA servers > (RSS, SDS, etc) at ibm.com or in the v11 manuals? > > Bob > > ----- Original Message ----- > From: "Madison Pruet" <mpruet@us.ibm.com> > To: ids@iiug.org > Sent: Wednesday, February 4, 2009 10:08:24 AM GMT -05:00 US/Canada Eastern > Subject: Re: Question for Connection manager and SDS [14732] > > See below > > ------------------------------------- > Madison Pruet, STSM > IDS Replication Architect > > =3D > > "jak aka" =3D > > <jakkritakeng@yah =3D > > oo.com> =3D > To > > Sent by: ids@iiug.org =3D > > ids-bounces@iiug. =3D > cc > > org =3D > > Subj=3D > ect > > Question for Connection manager =3D > and > > 02/04/2009 12:22 SDS [14718] =3D > > AM =3D > > =3D > > =3D > > Please respond to =3D > > ids@iiug.org =3D > > =3D > > =3D > > I have 2 question for IDS11.50 SDS > > 1. What is the machanism of Connect Manger to select the dabase serve= r =3D > ? > Round > robin , random ? > > For example : > > SLA CMport=3D3D(dbport1+dbport2+dbport3) > Can we set up the additional rule for CM such as use dbport1 40%, dbp= or=3D > t2 > 30%, > dbport3 30% ? > > The Connection Manager utilizes the SLA as far as order of the groups= , =3D > but > also considers the workload on eash of the nodes within that SLA leve= l.=3D > > This includes the number of CPU cycles that it could have utilized, t= he=3D > > number of threads on the ready queue, the number of sessions alread o= n =3D > that > node, etc. > > 2. When using SDS (2 machine ,1 Primary - 1 SDS). If Primary crash, C= an=3D > > users > access (write/read) SDS without restart database ? Do I have to force= S=3D > DS > to > be primary ? > > You would need to convert one of the other nodes into a primary. > > Best Regards, > Jakkrit A. > > *********************************************************************= **=3D > ******** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > =3D > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ***********************************************************************= ******** > Forum Note: Use "Reply" to post a response in the discussion forum.= >= ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.