ondblog change mode

Folks, We are running a big table loading transaction on a UNBUF logging database. The question is, Can we use ondblog to change the database logging mode to NOLOG( the big TX is still running) to stop the big running transaction's using logical log space, so to avoid LONG transaction abort ? IDS10 UC5 AIX 5.3 Thanks, Frank

I don't think so ... however, have you considered altering the tables being loaded to "raw"... alter table table_nametype (raw); and then back to standard when done ... alter table table_nametype (standard); I've used this and it works very well. PDL "FRANK" <yunyaoqu@gmail.com> Sent by: ids-bounces@iiug.org 02/20/2007 12:29 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject ondblog change mode [8450] Folks, We are running a big table loading transaction on a UNBUF logging database. The question is, Can we use ondblog to change the database logging mode to NOLOG( the big TX is still running) to stop the big running transaction's using logical log space, so to avoid LONG transaction abort ? IDS10 UC5 AIX 5.3 Thanks, Frank ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Not while it's running, no. Nor can you ALTER the table to RAW while a session has the table opened. Art S. Kagel ----- Original Message ----- From: Frank <ids@iiug.org> At: 2/20 12:30:04 Folks, We are running a big table loading transaction on a UNBUF logging database. The question is, Can we use ondblog to change the database logging mode to NOLOG( the big TX is still running) to stop the big running transaction's using logical log space, so to avoid LONG transaction abort ? IDS10 UC5 AIX 5.3 Thanks, Frank ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Peter, The major drawback of RAW is that constraints or index is not allowed, so We are go to change to UNLOG db to finish it. Thanks, Frank On 2/20/07, Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> wrote: > > I don't think so ... however, have you considered altering the tables > being loaded to "raw"... > > alter table table_name> type (raw); > > and then back to standard when done ... > > alter table table_name> type (standard); > > I've used this and it works very well. > > PDL > > "FRANK" <yunyaoqu@gmail.com> > Sent by: ids-bounces@iiug.org > 02/20/2007 12:29 PM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > ondblog change mode [8450] > > Folks, > > We are running a big table loading transaction on a UNBUF logging > database. > > The question is, > > Can we use ondblog to change the database logging mode to NOLOG( the big > TX is still running) to stop the big running transaction's using logical > log space, so to avoid LONG transaction abort ? > > IDS10 UC5 AIX 5.3 > > Thanks, > Frank > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

actually on v10 you can leave the indexes ... "FRANK" <yunyaoqu@gmail.com> Sent by: ids-bounces@iiug.org 02/20/2007 03:32 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject Re: ondblog change mode [8455] Peter, The major drawback of RAW is that constraints or index is not allowed, so We are go to change to UNLOG db to finish it. Thanks, Frank On 2/20/07, Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> wrote: > > I don't think so ... however, have you considered altering the tables > being loaded to "raw"... > > alter table table_name> type (raw); > > and then back to standard when done ... > > alter table table_name> type (standard); > > I've used this and it works very well. > > PDL > > "FRANK" <yunyaoqu@gmail.com> > Sent by: ids-bounces@iiug.org > 02/20/2007 12:29 PM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > ondblog change mode [8450] > > Folks, > > We are running a big table loading transaction on a UNBUF logging > database. > > The question is, > > Can we use ondblog to change the database logging mode to NOLOG( the big > TX is still running) to stop the big running transaction's using logical > log space, so to avoid LONG transaction abort ? > > IDS10 UC5 AIX 5.3 > > Thanks, > Frank > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

With IDS v10 what we can do for a table that has constraint and index: 0. dbschema to get details of the table's index/constraint. 1. Drop constraint constraint_name. 2. set indexes for table_name disabled. 3. alter table table_name type (raw). 4. load data onto table. 5. alter table table_name type (standard). 6. set indexes for table_name enabled. 7. alter table table_name add constraint... Long N =========================================================================== "Peter_Logan@spartan stores.com" To: ids@iiug.org <Peter_Logan cc: Sent by: Subject: Re: ondblog change mode [8456] ids-bounces@iiug.org 21/02/2007 07:38 AM Please respond to ids actually on v10 you can leave the indexes ... "FRANK" <yunyaoqu@gmail.com> Sent by: ids-bounces@iiug.org 02/20/2007 03:32 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject Re: ondblog change mode [8455] Peter, The major drawback of RAW is that constraints or index is not allowed, so We are go to change to UNLOG db to finish it. Thanks, Frank On 2/20/07, Peter_Logan@spartanstores.com <Peter_Logan@spartanstores.com> wrote: > > I don't think so ... however, have you considered altering the tables > being loaded to "raw"... > > alter table table_name> type (raw); > > and then back to standard when done ... > > alter table table_name> type (standard); > > I've used this and it works very well. > > PDL > > "FRANK" <yunyaoqu@gmail.com> > Sent by: ids-bounces@iiug.org > 02/20/2007 12:29 PM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > ondblog change mode [8450] > > Folks, > > We are running a big table loading transaction on a UNBUF logging > database. > > The question is, > > Can we use ondblog to change the database logging mode to NOLOG( the big > TX is still running) to stop the big running transaction's using logical > log space, so to avoid LONG transaction abort ? > > IDS10 UC5 AIX 5.3 > > Thanks, > Frank > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.