Re: config of online
Art S. Kagel wrote:
>
> Marichamy, Udaykumar wrote:
> >
> > In fact, I would be interested in the answer very much. A complete list
of
> > all Informix config params indicating which ones can be tuned
dynamically,
> > which ones cannot, will be extremely helpful indeed. Any one?
>
> This is an easy one. The following parameters can be changed manually
> in the ONCONFIG file and take immediate effect:
>
> TAPEDEV
> TAPESIZE
> TAPEBLK>
> The following can be changed using onmonitor to take immediate effect
> but changing directly in the ONCONFIG file has no immediate effect):
>
> LTAPEDEV
> LTAPESIZE
> LTAPEBLK>
> The following can be modified online for immediate effect by an onmode
> or other utility command:
>
> NUMCPUVPS - onmode -p +/-n cpu (where n is number of VPs)
> NUMAIOVPS - onmode -p +/-n aio (where n is number of VPs)
> RESIDENT - onmode -r/-n
> ONDBSPACEDOWN - onmode -O
> DS_MAX_QUERIES - onmode -Q
> DS_MAX_SCANS - onmode -S
MAX_PDQPRIORITY - onmode -D
DS_TOTAL_MEMORY - onmode -M
Art,
sure it's just influence of medications :-)
>
> LOGFILES - onparams
> PHYSFILE - onparams> PHYSDBS - onparams
>
> The onparams commands modify the ONCONFIG file appropriately as well as
> making the operational change. However, changes made using onmode are
> temporary and the equivalent change to the ONCONFIG file must be made
> by hand.
>
> > Do i have to shut down and restart the DB engine if i make changes to
'Max #
> > no of buffers'
> > in Shared memory parameters ? (Sorry, This seems a very simple question
as
> > i am a new entrant in DBA area)
>
> You do for the change to take immediate effect but it is likewise safe
> to make the change and wait for the next scheduled bounce/boot for the
> change to take effect.
>
> Art S. Kagel
>
Regards
Vardan Aroustamian
--
vaar@geocities.com