Logical logs from rootdbs to own logspace
Posted in 2004
Topics: Storage & Space Management, Logging & Checkpoints
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?
use onparams to add some more logs to the logspace and then use
onparams to remove the logs in rootdbs
Geezer From The Freezer wrote:
>
> I want to set-up a logspace dbspace - easy enough. But how do I tell informix
> to use this logspace dbspace instead of rootdbs?
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
Paul Watson wrote:
>
> use onparams to add some more logs to the logspace and then use
> onparams to remove the logs in rootdbs
>
> Geezer From The Freezer wrote:
> >
> > I want to set-up a logspace dbspace - easy enough. But how do I tell informix
> > to use this logspace dbspace instead of rootdbs?
Paul,
Of course - I should've known that. Anyway - worked a treat!
Ta
"Geezer From The Freezer" <Geezer@Freezer.com> wrote in message
news:40E135DB.477DB7E9@Freezer.com...
> I want to set-up a logspace dbspace - easy enough. But how do I tell
informix
> to use this logspace dbspace instead of rootdbs?
RTFOVFM.
Quiesce the database
onparamas to add the new logs
ontape -s to activate them
onmode -l to make one of the new ones the active oneonparams to drop the old ones from the root dbspace
Neil Truby wrote: > > RTFOVFM. OVF? zzzzzzt pass > Quiesce the database Since when?