DYNAMIC_LOGS in ONCONFIG
A DBA asked whether DYNAMIC_LOGS could be used on IDS 10 (HP-UX) so a developer's large table move wouldn't hit long-transaction limits, and where the added logs would live. Answers: dynamically added logical logs are created in ROOTDBS (not /tmp) and are permanent — they survive restarts and must be dropped manually with onparams. Others suggested setting DYNAMIC_LOGS to 1 so the DBA is prompted to add logs, treating it as a last resort, and recommended switching the table to RAW mode during the move (then back to STANDARD with a level 0 backup) to avoid logging altogether.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic logs go to? /tmp ? Thanks for any insight. Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu web: http://www.facebook.com/jonathan.smaby ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
Dynamic logs are added from the ROOTDBS dbspace. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Mon, Oct 5, 2009 at 6:18 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote: > Good afternoon, > > We occasionally have a programmer than needs a large amount of log space to > move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in > the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS > 10.00 > on HPUX? > > Where would the dynamic logs go to? /tmp ? > > Thanks for any insight. > > Jonathan B. Smaby > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > web: http://www.facebook.com/jonathan.smaby > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747360afb6d72047537a144
Thank-you Art. Last question... are these permanent logical logs? Or temporary? Do the dynamically added logical logs go away after a reboot? Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu web: http://www.facebook.com/jonathan.smaby -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Monday, October 05, 2009 3:29 PM To: ids@iiug.org Subject: Re: DYNAMIC_LOGS in ONCONFIG [17350] Dynamic logs are added from the ROOTDBS dbspace. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Mon, Oct 5, 2009 at 6:18 PM, Jonathan Smaby <Jonathan.Smaby@pomona.edu>wrote: > Good afternoon, > > We occasionally have a programmer than needs a large amount of log space to > move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in > the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS > 10.00 > on HPUX? > > Where would the dynamic logs go to? /tmp ? > > Thanks for any insight. > > Jonathan B. Smaby > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > web: http://www.facebook.com/jonathan.smaby > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747360afb6d72047537a144 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.
No, they are permanent. You will have to drop them manually with onparams
if they are no longer needed or you want to replace then with other logs in
a different dbspace.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. 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 Mon, Oct 5, 2009 at 6:45 PM, Jonathan Smaby
<Jonathan.Smaby@pomona.edu>wrote:
> Thank-you Art.
>
> Last question... are these permanent logical logs? Or temporary? Do the
> dynamically added logical logs go away after a reboot?
>
> Jonathan B. Smaby
> Pomona College
> phone: (909) 621-8506
> email: jonathan.smaby@pomona.edu
> web: http://www.facebook.com/jonathan.smaby
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Monday, October 05, 2009 3:29 PM
> To: ids@iiug.org
> Subject: Re: DYNAMIC_LOGS in ONCONFIG [17350]
>
> Dynamic logs are added from the ROOTDBS dbspace.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. 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 Mon, Oct 5, 2009 at 6:18 PM, Jonathan Smaby
> <Jonathan.Smaby@pomona.edu>wrote:
>
> > Good afternoon,
> >
> > We occasionally have a programmer than needs a large amount of log space
> to
> > move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM
> in
> > the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS
> > 10.00
> > on HPUX?
> >
> > Where would the dynamic logs go to? /tmp ?
> >
> > Thanks for any insight.
> >
> > Jonathan B. Smaby
> > Pomona College
> > phone: (909) 621-8506
> > email: jonathan.smaby@pomona.edu
> > web: http://www.facebook.com/jonathan.smaby
> >
> > -------------------------------------------------------------
> > This message has been scanned by Postini anti-virus software.
> >
> >
> >
> >
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00151747360afb6d72047537a144
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--0015173fe52a3d6bb004753872f8
Dynamically added logs are permanent and won't go away unless you delete
them.
- Nilesh -
ids-bounces@iiug.org wrote on 10/05/2009 05:45:22 PM:
> [image removed]
>
> RE: DYNAMIC_LOGS in ONCONFIG [17351]
>
> Jonathan Smaby
>
> to:
>
> ids
>
> 10/05/2009 05:47 PM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Thank-you Art.
>
> Last question... are these permanent logical logs? Or temporary? Do the
> dynamically added logical logs go away after a reboot?
>
> Jonathan B. Smaby
> Pomona College
> phone: (909) 621-8506
> email: jonathan.smaby@pomona.edu
> web: http://www.facebook.com/jonathan.smaby
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Monday, October 05, 2009 3:29 PM
> To: ids@iiug.org
> Subject: Re: DYNAMIC_LOGS in ONCONFIG [17350]
>
> Dynamic logs are added from the ROOTDBS dbspace.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
and
> do not reflect on my employer, Oninit, the IIUG, nor any other
organization
> with which I am associated either explicitly or implicitly. 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 Mon, Oct 5, 2009 at 6:18 PM, Jonathan Smaby
> <Jonathan.Smaby@pomona.edu>wrote:
>
> > Good afternoon,
> >
> > We occasionally have a programmer than needs a large amount of logspace
to
> > move a very large table. Instead of fiddling with the HTXHWM and
LTXEHWM in> > the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS
> > 10.00
> > on HPUX?
> >
> > Where would the dynamic logs go to? /tmp ?
> >
> > Thanks for any insight.
> >
> > Jonathan B. Smaby
> > Pomona College
> > phone: (909) 621-8506
> > email: jonathan.smaby@pomona.edu
> > web: http://www.facebook.com/jonathan.smaby
> >
> > -------------------------------------------------------------
> > This message has been scanned by Postini anti-virus software.
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --00151747360afb6d72047537a144
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Jonathan Smaby wrote: > Good afternoon, > > We occasionally have a programmer than needs a large amount of log space to > move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in > the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 > on HPUX? > > Where would the dynamic logs go to? /tmp ? > > Thanks for any insight. > > Jonathan B. Smaby > Pomona College > phone: (909) 621-8506 > email: jonathan.smaby@pomona.edu > web: http://www.facebook.com/jonathan.smaby > > ------------------------------------------------------------- > This message has been scanned by Postini anti-virus software. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > My recommendation is to have DYNAMIC_LOGS enabled set to 1 (let administrator interact and add logical logs as needed.) Nevertheless , this shoud be a last resort . a Long transaction is a bug in your application that needs get fixed. However, I guess the solution to your developers problem is using raw tables . HTH Tilman
How about having your programmer set the table(s) in question to mode
raw before he moves the data and set it back to standard afterward?
That way you avoid the whole log issue entirely. You just would want to
make a level 0 backup after the tables are set back to standard.
--EEM
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
tilleul17@web.de
Sent: Tuesday, October 06, 2009 3:00 PM
To: ids@iiug.org
Subject: Re: DYNAMIC_LOGS in ONCONFIG [17387]
Jonathan Smaby wrote:
> Good afternoon,
>
> We occasionally have a programmer than needs a large amount of log
space to
> move a very large table. Instead of fiddling with the HTXHWM and
LTXEHWM in> the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS
10.00
> on HPUX?
>
> Where would the dynamic logs go to? /tmp ?
>
> Thanks for any insight.
>
> Jonathan B. Smaby
> Pomona College
> phone: (909) 621-8506
> email: jonathan.smaby@pomona.edu
> web: http://www.facebook.com/jonathan.smaby
>
> -------------------------------------------------------------
> This message has been scanned by Postini anti-virus software.
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
My recommendation is to have DYNAMIC_LOGS enabled set to 1 (let
administrator interact and add logical logs as needed.)
Nevertheless , this shoud be a last resort . a Long transaction is a bug
in your application that needs get fixed.
However, I guess the solution to your developers problem is using raw
tables .
HTH
Tilman
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.