Re: change log size

LAM Chi-fung wrote: > > Hello, I would like to ask how can I change the log size of Informix ? > (point me which manual to read is o.k. :> ) > Since I perform a lot of search, comparing and the log 'full' very > quick. I don't want to do 'ontape -a' in the middle of my job. (Our DBA > is out town so I don't have anyone to ask) Thanks a lot. > > Regds > LAM Chi-fung For version 7 manuals. Not a simple operation as this involves re-initialising the instance. A simpler option is to add more logs. This is documented in Admin Guide 2 , page 23 -5 or type "onparams -" for help. Alternatively if you do not need to log the load, Make the note of the logging, you will get this from onmonitor - Status - databases, turn logging of the database with "ontape -s -N <database>", but set the tape parameter in the config file to /dev/null first, then load the info, then turn the logging back on to whatever it was before using ontape again. then reset you tape parameter in the onconfig file. Section in manual for modifying logging is 21-7. For version 5. I don't have the manuals but ontape is tbtape and onmonitor is tbmonitor -- Gillian Earl Motorola ECID 16 Euroway E-Mail: earlg@ecid.cig.mot.com Swindon SN5 8YQ UK