change log size -Reply 
Author Message
 change log size -Reply

     Thuc,

     You don't need to save any of the old ones the onconfig is updated
     during the onparams processing to include the new number of logs.

     Regards

     David

______________________________ Reply Separator _________________________________
Subject: Re[2]: change log size -Reply

Date:    18/12/97 9:10 AM

So we can delete ALL old ones with onparams -d? What about saving 3
old ones as required when initalizing?

thuc

     Gillian,

     Instead of reinitialising you could use onparams to add the new logs
     and delete the old ones with "onparams -d". You may have to use
     "onmode -l" to force the logical logsa in to the new group of logs
     first.

     Regards

     David

______________________________ Reply Separator
_________________________________
Subject: Re: change log size

Date:    15/12/97 6:02 PM

Quote:

> 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                    

Swindon                                    
SN5 8YQ                      
UK



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Ontape won't change logging -Reply

2. Change of Logging Status: Implications? -Reply

3. Size of transaction log have not been changed

4. Changing data/log file size thru SQLDMO

5. Change in log size

6. how changing the size of the transaction log that is already exist

7. Changing redo log file size

8. changing size of logs

9. change log size

10. change log size

11. Change the size of the TDS packet size

12. Backup image size changes with different buffer sizes


 
Powered by phpBB® Forum Software