Logical logs from rootdbs to own logspace
Geezer From The Freezer asked how to make Informix use a new logspace instead of rootdbs for logical logs. Paul Watson said to add logs to the logspace with onparams and then remove the rootdbs logs. Neil Truby gave the steps: quiesce, onparams to add logs, ontape -s to activate them, onmode -l to switch, then onparams to drop the old ones. Andrew Hamm questioned the quiesce. The original poster reported it worked.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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?