RE: Online Config Changes

Posted in 1999

Topics: Server Administration, Platform-Specific Issues, Versions, Editions & End-of-Life

Marichamy, Udaykumar — Wed, 26 May 1999 13:10:37 -0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BEA7A3.0E752F34 Content-Type: text/plain Quoting from page# 6 of 'Informix-OnLine Dynamic Server Handbook' (1997) by Carlton Doe, "Most of the configuration parameters can be reconfigured while the engine is online and functioning.". Is this in direct contradiction to what you are saying Carlson? Thanks, Uday -----Original Message----- From: Carlson@WHSmith [mailto:carlson1@bellsouth.net] Sent: Wednesday, May 26, 1999 12:11 PM To: informix-list@iiug.org Subject: Re: Online Config Changes Afraid that you'll need to reset the ONCONFIG variables, then bounce Informix. One of the only parameters that doesn't require a bounce is TAPEDEV. John Carlson Informix DBA WHSmith USA Marichamy, Udaykumar wrote: > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------ =_NextPart_001_01BEA792.AEE11024 > Content-Type: text/plain > > Hello all, > > Can I dynamically change BUFFERS and RA_THRESHOLD without having to bounce > the Informix server? > > I am doing this because the onstat -p output shows that bufwaits is > increasing and ovbuffs has 143. Also, RA-pagesused is much less that total > pages read-ahead. Any ideas? > > Our platform is IDS 7.23 UC11X3 on AIX 4.3. > > Thanks, > > Uday > > ------ =_NextPart_001_01BEA792.AEE11024 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3DUS-ASCII"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.0.1460.9"> > <TITLE>Online Config Changes </TITLE> > </HEAD> > <BODY> > > Hello all, > > > Can I dynamically change BUFFERS and RA_THRESHOLD = > without having to bounce the Informix server? > > > I am doing this because the onstat -p output shows = > that bufwaits is increasing and ovbuffs has 143. Also, RA-pagesused is = > much less that total pages read-ahead. Any ideas? > > Our platform is IDS 7.23 UC11X3 on AIX 4.3. > > > Thanks, > > > Uday > > > </BODY> > </HTML> > ------ =_NextPart_001_01BEA792.AEE11024-- ------ =_NextPart_001_01BEA7A3.0E752F34 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.0.1460.9"> <TITLE>RE: Online Config Changes</TITLE> </HEAD> <BODY> Quoting from page# 6 of 'Informix-OnLine Dynamic = Server Handbook' (1997) by Carlton Doe, "Most of the configuration = parameters can be reconfigured while the engine is online and = functioning.". Is this in direct contradiction to what you are = saying Carlson? Thanks, Uday -----Original Message----- From: Carlson@WHSmith [<A = HREF=3D"mailto:carlson1@bellsouth.net" = TARGET=3D"_blank">mailto:carlson1@bellsouth.net</A>] Sent: Wednesday, May 26, 1999 12:11 PM To: informix-list@iiug.org Subject: Re: Online Config Changes Afraid that you'll need to reset the ONCONFIG = variables, then bounce Informix.  One of the only parameters that = doesn't require a bounce is TAPEDEV. John Carlson Informix DBA WHSmith USA Marichamy, Udaykumar wrote: > > This message is in MIME format. Since your mail = reader does not understand > this format, some or all of this message may = not be legible. > > ------ = =3D_NextPart_001_01BEA792.AEE11024 > Content-Type: text/plain > > Hello all, > > Can I dynamically change BUFFERS and = RA_THRESHOLD without having to bounce > the Informix server? > > I am doing this because the onstat -p output = shows that bufwaits is > increasing and ovbuffs has 143. Also, = RA-pagesused is much less that total > pages read-ahead. Any ideas? > > Our platform is IDS 7.23 UC11X3 on AIX = 4.3. > > Thanks, > > Uday > > ------ = =3D_NextPart_001_01BEA792.AEE11024 > Content-Type: text/html > Content-Transfer-Encoding: = quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML = 3.2//EN"> > <HTML> > <HEAD> > <META = HTTP-EQUIV=3D3D"Content-Type" CONTENT=3D3D"text/html; = =3D > charset=3D3DUS-ASCII"> > <META NAME=3D3D"Generator" = CONTENT=3D3D"MS Exchange Server version =3D > 5.0.1460.9"> > <TITLE>Online Config Changes = </TITLE> > </HEAD> > <BODY> > > Hello = all, > > > Can I = dynamically change BUFFERS and RA_THRESHOLD =3D > without having to bounce the Informix = server? > > @@NL

↪ replying to Marichamy, Udaykumar

Carlson@WHSmith — Wed, 26 May 1999 15:30:24 -0400 — source: Informix-list mailing list archive (1991-1998)

Not necessarily. The variables can be reconfigured within the ONCONFIG file while the engine is up; they won't take effect until the engine is bounced. Six of one, half-dozen of another John Carlson Informix DBA WHSmith USA Marichamy, Udaykumar wrote: > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------ =_NextPart_001_01BEA7A3.0E752F34 > Content-Type: text/plain > > Quoting from page# 6 of 'Informix-OnLine Dynamic Server Handbook' (1997) by > Carlton Doe, "Most of the configuration parameters can be reconfigured while > the engine is online and functioning.". Is this in direct contradiction to > what you are saying Carlson? > > Thanks, > > Uday > > -----Original Message----- > From: Carlson@WHSmith [mailto:carlson1@bellsouth.net] > Sent: Wednesday, May 26, 1999 12:11 PM > To: informix-list@iiug.org > Subject: Re: Online Config Changes > > Afraid that you'll need to reset the ONCONFIG variables, then bounce > Informix. One of the only parameters that doesn't require a bounce is > TAPEDEV. > > John Carlson > Informix DBA > WHSmith USA > > Marichamy, Udaykumar wrote: > > > > This message is in MIME format. Since your mail reader does not understand > > this format, some or all of this message may not be legible. > > > > ------ =_NextPart_001_01BEA792.AEE11024 > > Content-Type: text/plain > > > > Hello all, > > > > Can I dynamically change BUFFERS and RA_THRESHOLD without having to bounce > > the Informix server? > > > > I am doing this because the onstat -p output shows that bufwaits is > > increasing and ovbuffs has 143. Also, RA-pagesused is much less that total > > pages read-ahead. Any ideas? > > > > Our platform is IDS 7.23 UC11X3 on AIX 4.3. > > > > Thanks, > > > > Uday > > > > ------ =_NextPart_001_01BEA792.AEE11024 > > Content-Type: text/html > > Content-Transfer-Encoding: quoted-printable > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > > <HTML> > > <HEAD> > > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > > charset=3DUS-ASCII"> > > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > > 5.0.1460.9"> > > <TITLE>Online Config Changes </TITLE> > > </HEAD> > > <BODY> > > > > Hello all, > > > > > > Can I dynamically change BUFFERS and RA_THRESHOLD = > > without having to bounce the Informix server? > > > > > > I am doing this because the onstat -p output shows = > > that bufwaits is increasing and ovbuffs has 143. Also, RA-pagesused is = > > much less that total pages read-ahead. Any ideas? > > > > Our platform is IDS 7.23 UC11X3 on AIX 4.3. > > > > > > Thanks, > > > > > > Uday > > > > > > </BODY> > > </HTML> > > ------ =_NextPart_001_01BEA792.AEE11024-- > > ------ =_NextPart_001_01BEA7A3.0E752F34 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3DUS-ASCII"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.0.1460.9"> > <TITLE>RE: Online Config Changes</TITLE> > </HEAD> > <BODY> > > Quoting from page# 6 of 'Informix-OnLine Dynamic = > Server Handbook' (1997) by Carlton Doe, "Most of the configuration = > parameters can be reconfigured while the engine is online and = > functioning.". Is this in direct contradiction to what you are = > saying Carlson? > > Thanks, > > > Uday > > > -----Original Message----- > From: Carlson@WHSmith [<A = > HREF=3D"mailto:carlson1@bellsouth.net" = > TARGET=3D"_blank">mailto:carlson1@bellsouth.net</A>] > Sent: Wednesday, May 26, 1999 12:11 PM > To: informix-list@iiug.org > Subject: Re: Online Config Changes > > > > Afraid that you'll need to reset the ONCONFIG = > variables, then bounce > Informix.  One of the only parameters that = > doesn't require a bounce is > TAPEDEV. > > > > John Carlson > Informix DBA > WHSmith USA > > > > Marichamy, Udaykumar wrote: > > > > This message is in MIME format. Since your mail = > reader does not understand > > this format, some or all of this message may = > not be legible. > > > > ------ = > =3D_NextPart_001_01BEA792.AEE11024 > > Content-Type: text/plain > > > > Hello all, > > > > Can I dynamically change BUFFERS and = > RA_THRESHOLD without having to bounce > > the Informix server? > > > > I am doing this because the onstat -p output = > shows that bufwaits is > > increasing and ovbuffs has 143. Also, = > RA-pagesused is much less that total > > pages read-ahead. Any ideas? > > > > Our platform is IDS 7.23 UC11X3 on AIX = > 4.3. > > > > Thanks, > > > > Uday > > > > ------ = > =3D_NextPart_001_01BEA792.AEE11024 > > Content-Type: text/html > > Content-Transfer-Encoding: = > quoted-printable > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML = > 3.2//EN"> > > <HTML> > > <HEAD> > > <META = > HTTP-EQUIV=3D3D"Content-Type" CONTENT=3D3D"text/html; = > =3D > > charset=3D3DUS-ASCII"> > > <META NAME=3D3D"Generator" = > CONTENT=3D3D"MS Exchange Server version =3D > > 5.0.1460.9"> > > <TITLE>Online

RE: Online Config Changes

Related threads

Glossary

Your privacy choices