Re: Resizing Logical Logs

In article <5jfrq1$nn4@cssun.mathcs.emory.edu>, ennis@ssax.com (Bill Ennis) wrote: >Hi, > >Sizes for logical logs is done when the engine is initialized. >Therefore, you'de have to reinit the engine to change their size; >unless this has been changed recently - anyone? In Version 7, you can add logs of a size different from LOGSIZE by using the onparams utility. e.g onparams -a [-d dbspace] [-s size(in Kb)] Its fairly simple to change the size of all your logs. 1. drop all your existing logs (except 3). 2. add the new logs with the new size (using onparams) 3. do a L 0 backup to make these logs available 4. use onmode -l to switch to the new logs 5. drop the 'old' logs If LOGSMAX is a limitation, change in in ONCONFIG and restart online. > >> >> Can anyone provide a procedural how-to to increase the size and number >> of logical logs. >> >> The majority of my experience is in Oracle, and I have an urgent need to >> increase beyond the defaults. I am struggling with the manuals to get >> this done. >> >> Thanks for any help. >> >> bobw. >> HTH. ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------