Oninit cdi / Archive
Talk to an expert →

ontape Archive failed - Error changing logging sta

Posted in 2007

Summary

Frank's attempt to switch a database to unbuffered logging during a level-0 backup (ontape -s -L 0 -U noaa) failed with "Error changing logging status... iserrno 107" while users were connected; it worked after he killed the user sessions. Respondents explained the cause: changing logging status requires an exclusive lock on the database, so any session attached to or locking it blocks the change (ISAM 107 = record/table locked). Suggested workarounds: identify holders via onstat -g sql or an SMI lock query, take the server to single-user/quiescent mode (onmode -j/-s/-u, then -m), restart the instance, or use ondblog followed by a level-0 backup.

Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.

Topics: Backup & Restore, Platform-Specific Issues, Internationalization & Character Sets

FRANK — — source: IIUG Forums & Mailing Lists

Hi, Got this error when tried to ontape, informix@dolly $ ontape -s -L 0 -U noaa Archive failed - Error changing logging status - 'noaa'. iserrno 107. It could be done when I killed the user sessions. any idea? Thanks, Frank Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8

↪ replying to FRANK
Joseph_Jurcazak@aotx.uscourts.gov — — source: IIUG Forums & Mailing Lists

if you do 'onstat -g sql | grep noaa' do you get anything back? "FRANK" <yunyaoqu@gmail.com> Sent by: ids-bounces@iiug.org 08/06/2007 11:48 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject ontape Archive failed - Error changing logging.... [9705] Hi, Got this error when tried to ontape, informix@dolly $ ontape -s -L 0 -U noaa Archive failed - Error changing logging status - 'noaa'. iserrno 107. It could be done when I killed the user sessions. any idea? Thanks, Frank Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Joseph_Jurcazak@aotx.uscourts.gov
FRANK — — source: IIUG Forums & Mailing Lists

Unfortunately, I already finished "ontape -s -L 0 -U noaa" by killing all the user sessions. So, onstat -g sql | grep noaa' will not give the expected result. My question is , what is the reason for error? The command is to change db logging mode from nolog to unbuf when there is active user sessions there. Thanks, Frank On 8/6/07, Joseph_Jurcazak@aotx.uscourts.gov < Joseph_Jurcazak@aotx.uscourts.gov> wrote: > > if you do 'onstat -g sql | grep noaa' do you get anything back? > > "FRANK" <yunyaoqu@gmail.com> > Sent by: ids-bounces@iiug.org > 08/06/2007 11:48 AM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > ontape Archive failed - Error changing logging.... [9705] > > Hi, > > Got this error when tried to ontape, > > informix@dolly $ ontape -s -L 0 -U noaa > Archive failed - Error changing logging status - 'noaa'. iserrno 107. > > It could be done when I killed the user sessions. > > any idea? > > Thanks, > Frank > > Program Name: onstat > Build Version: 10.00.UC5 > Build Number: N202 > Build Host: ibm6c1b > Build OS: AIX 5.2 > Build Date: Thu May 18 00:09:08 CDT 2006 > GLS Version: glslib-4.00.UC8 > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to FRANK
Robert — — source: IIUG Forums & Mailing Lists

Probably requires that no user sessions are attached to a database to change it's logging status. Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Monday, August 06, 2007 1:05 PM To: ids@iiug.org Subject: Re: ontape Archive failed - Error changing log.... [9707] Unfortunately, I already finished "ontape -s -L 0 -U noaa" by killing all the user sessions. So, onstat -g sql | grep noaa' will not give the expected result. My question is , what is the reason for error? The command is to change db logging mode from nolog to unbuf when there is active user sessions there. Thanks, Frank On 8/6/07, Joseph_Jurcazak@aotx.uscourts.gov < Joseph_Jurcazak@aotx.uscourts.gov> wrote: > > if you do 'onstat -g sql | grep noaa' do you get anything back? > > "FRANK" <yunyaoqu@gmail.com> > Sent by: ids-bounces@iiug.org > 08/06/2007 11:48 AM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > ontape Archive failed - Error changing logging.... [9705] > > Hi, > > Got this error when tried to ontape, > > informix@dolly $ ontape -s -L 0 -U noaa > Archive failed - Error changing logging status - 'noaa'. iserrno 107. > > It could be done when I killed the user sessions. > > any idea? > > Thanks, > Frank > > Program Name: onstat > Build Version: 10.00.UC5 > Build Number: N202 > Build Host: ibm6c1b > Build OS: AIX 5.2 > Build Date: Thu May 18 00:09:08 CDT 2006 > GLS Version: glslib-4.00.UC8 > > > > ************************************************************************ ******* > > 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.

↪ replying to FRANK
Knox, Ernest — — source: IIUG Forums & Mailing Lists

You need to remove all locking sessions against the database before turning on logging. That's what I've come to realize when I perform this function. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of FRANK Sent: Monday, August 06, 2007 11:48 AM To: ids@iiug.org Subject: ontape Archive failed - Error changing logging.... [9705] Hi, Got this error when tried to ontape, informix@dolly $ ontape -s -L 0 -U noaa Archive failed - Error changing logging status - 'noaa'. iserrno 107. It could be done when I killed the user sessions. any idea? Thanks, Frank Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to FRANK
Veronica — — source: IIUG Forums & Mailing Lists

Hi, While the logging status of a DB is being changed, the server places an exclusive lock on the DB to prevent other users from accessing it, and frees the lock when the change is complete. Maybe the SMI query in the following article (how to get the locked objects within a database, when isam 107 is returned by dbexport utility), returns something to you, related to the locked object, so you can take actions based on this? dbexport reports SQL error -425 ISAM error -107 http://www-1.ibm.com/support/docview.wss?uid=swg21221129 Other options you could consider: - go to single user mode (onmode -j) or quiescent (onmode -s/-u) and issue the ontape, and go to multi-user mode later (onmode -m) afterwards, if you can disconnect other users. - run the ondblog and then perform a level-0 backup. Regards, Veronica. ----Original Message Follows---- From: "FRANK" <yunyaoqu@gmail.com> Reply-To: ids@iiug.org To: ids@iiug.org Subject: Re: ontape Archive failed - Error changing log.... [9707] Date: Mon, 6 Aug 2007 13:04:52 -0400 (EDT) Unfortunately, I already finished "ontape -s -L 0 -U noaa" by killing all the user sessions. So, onstat -g sql | grep noaa' will not give the expected result. My question is , what is the reason for error? The command is to change db logging mode from nolog to unbuf when there is active user sessions there. Thanks, Frank On 8/6/07, Joseph_Jurcazak@aotx.uscourts.gov < Joseph_Jurcazak@aotx.uscourts.gov> wrote: > > if you do 'onstat -g sql | grep noaa' do you get anything back? > > "FRANK" <yunyaoqu@gmail.com> > Sent by: ids-bounces@iiug.org > 08/06/2007 11:48 AM > Please respond to > ids@iiug.org > > To > ids@iiug.org > cc > > Subject > ontape Archive failed - Error changing logging.... [9705] > > Hi, > > Got this error when tried to ontape, > > informix@dolly $ ontape -s -L 0 -U noaa > Archive failed - Error changing logging status - 'noaa'. iserrno 107. > > It could be done when I killed the user sessions. > > any idea? > > Thanks, > Frank > > Program Name: onstat > Build Version: 10.00.UC5 > Build Number: N202 > Build Host: ibm6c1b > Build OS: AIX 5.2 > Build Date: Thu May 18 00:09:08 CDT 2006 > GLS Version: glslib-4.00.UC8 > > > > ******************************************************************************* > > 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. _________________________________________________________________ Visita MSN Latino Entretenimiento: ¡música, cine, chismes, TV y más...! http://latino.msn.com/entretenimiento/

↪ replying to Joseph_Jurcazak@aotx.uscourts.gov
Varricchio, — — source: IIUG Forums & Mailing Lists

If possible, Shutdown and restart the database .. then run ontape. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Joseph_Jurcazak@aotx.uscourts.gov Sent: Monday, August 06, 2007 12:51 PM To: ids@iiug.org Subject: Re: ontape Archive failed - Error changing log.... [9706] if you do 'onstat -g sql | grep noaa' do you get anything back? "FRANK" <yunyaoqu@gmail.com> Sent by: ids-bounces@iiug.org 08/06/2007 11:48 AM Please respond to ids@iiug.org To ids@iiug.org cc Subject ontape Archive failed - Error changing logging.... [9705] Hi, Got this error when tried to ontape, informix@dolly $ ontape -s -L 0 -U noaa Archive failed - Error changing logging status - 'noaa'. iserrno 107. It could be done when I killed the user sessions. any idea? Thanks, Frank Program Name: onstat Build Version: 10.00.UC5 Build Number: N202 Build Host: ibm6c1b Build OS: AIX 5.2 Build Date: Thu May 18 00:09:08 CDT 2006 GLS Version: glslib-4.00.UC8 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Related threads

Glossary