Re: Dumb question

> > Dumb question: > > Is it safe to edit my onconfig file when the database is live ? Yes, but changing almost all parameters takes effect only when shared memory is initialized. Duiring next initialisation OnLine will compare your onconfig file with the copy of configuration file in PAGE_CONFIG reserved page and write in the online.log something like: 12:20:46 Onconfig parameter RESIDENT modified from 0 to 1. 12:20:46 Onconfig parameter SINGLE_CPU_VP modified from 0 to 1. The several parameters you can change without shared memory reinitialized. Full list of such parameters you can find in OnLine Administrator's guide. In one situation OnLine will update your onconfig file (for example, changing LOGFILES by onparams), in other situation it willn't update the onconfig (for example, DS_MAX_QUERIES by onmode) and you'll have to edit the onconfig by hand. > Or should I stop database with onmode, edit onconfig and then > restart database with oninit ? > Actually I have an edited onconfig.new file ready and I was about > to backup onfig to say oncongig.old and replace it with my new > onconfig. > > But then I had a moment of doubt. > > Can anyobody give me an answer (if not I'll go the safe way and > do onmode first). Both ways are possible, but for taking effect you must shutdown OnLine and initialize shared memory again. -- Best Regards, Oleg V. Checherin Tel: (416) 469-3962 Fax: (530) 687-6794 E-mail: ovc@mpei.ac.ru