Add more logical logs in IDS 9.4
Jack Papa planned to resize logical logs on IDS 9.4 and asked if quiescent mode is required. Art Kagel said logs can be added online, but at least three logs must exist, so drop most old logs, add new ones, switch with onmode -l, checkpoint with onmode -c, then drop the rest. Madison Pruet advised a level 0 backup. Cliff Burton confirmed online is fine.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All,
I'll be performing adding logical logs into our existing DB. My question are
the following:
1. Do the DB needs to be in quiescent state? i believe, there's no need at all.
Once i have added the new dbspaces to be used by the logical logs, i will drop
the existing ones and recreate a new set of logical logs out of those deleted
logical logs. (resizing).
I will perform a onmode -c and onmode -l for the switch log and force
checkpoint.
let me know your thoughts.
Thank you,
level 0 backup...
From: "JACK PAPA" <informix2009@gmail.com>
To: ids@iiug.org,
Date: 12/04/2012 10:29 PM
Subject: Add more logical logs in IDS 9.4 [29014]
Sent by: ids-bounces@iiug.org
Hi All,
I'll be performing adding logical logs into our existing DB. My questio=
n
are
the following:
1. Do the DB needs to be in quiescent state? i believe, there's no need=
at
all.
Once i have added the new dbspaces to be used by the logical logs, i wi=
ll
drop
the existing ones and recreate a new set of logical logs out of those
deleted
logical logs. (resizing).
I will perform a onmode -c and onmode -l for the switch log and force
checkpoint.
let me know your thoughts.
Thank you,
***********************************************************************=
********
Forum Note: Use "Reply" to post a response in the discussion forum.
=
Mostly correct. You can indeed add logs while the server is in "online"
mode and being actively accessed. However, you must have at least three
logical logs minimum, so you will have to drop only most of the existing
logs first, then create the new ones, use onmode -l to switch to one of the
new logs, onmode -c to move the checkpoint to the new log, then you can
drop the last few of the old logs.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.
On Tue, Dec 4, 2012 at 11:28 PM, JACK PAPA <informix2009@gmail.com> wrote:
> Hi All,
>
> I'll be performing adding logical logs into our existing DB. My question
> are
> the following:
>
> 1. Do the DB needs to be in quiescent state? i believe, there's no need at
> all.
>
> Once i have added the new dbspaces to be used by the logical logs, i will
> drop
> the existing ones and recreate a new set of logical logs out of those
> deleted
> logical logs. (resizing).
>
> I will perform a onmode -c and onmode -l for the switch log and force
> checkpoint.
>
> let me know your thoughts.
>
> Thank you,
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e89a8f838b95370b1904d0147d7f
That's correct. level 0 backup after changing anything. But does the DB needs to be in quiescent mode?
No, as Art mentioned, it can be online. Sent from my iPhone On 05/12/2012, at 4:49 PM, "JACK PAPA" <informix2009@gmail.com> wrote: > That's correct. level 0 backup after changing anything. > > But does the DB needs to be in quiescent mode? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >