Online Config Changes
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>
<P><FONT SIZE=3D2>Hello all,</FONT>
</P>
<P><FONT SIZE=3D2>Can I dynamically change BUFFERS and RA_THRESHOLD =
without having to bounce the Informix server?</FONT>
</P>
<P><FONT SIZE=3D2>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?</FONT></P>
<P><FONT SIZE=3D2>Our platform is IDS 7.23 UC11X3 on AIX 4.3.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks,</FONT>
</P>
<P><FONT SIZE=3D2>Uday</FONT>
</P>
</BODY>
</HTML>
------ =_NextPart_001_01BEA792.AEE11024--
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>
>
> <P><FONT SIZE=3D2>Hello all,</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Can I dynamically change BUFFERS and RA_THRESHOLD =
> without having to bounce the Informix server?</FONT>
> </P>
>
> <P><FONT SIZE=3D2>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?</FONT></P>
>
> <P><FONT SIZE=3D2>Our platform is IDS 7.23 UC11X3 on AIX 4.3.</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Thanks,</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Uday</FONT>
> </P>
>
> </BODY>
> </HTML>
> ------ =_NextPart_001_01BEA792.AEE11024--
Marichamy, Udaykumar wrote:
> 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.
No you must bounce for all parameters except TAPE* and LTAPE* (if done
using onmonitor).
I would suggest increasing BUFFERS and LRUS and decreasing the RA
parameters to start.
Art S. Kagel