IDS V11.50FC5: AUS error.
On IDS 11.50FC5 (HP-UX), the nightly Auto Update Statistics evaluation task failed at 01:00 with errors -242 (could not open informix.aus_work_info) and -154 (lock timeout), so aus_evaluator couldn't run; it happened only on the HDR primary. Art Kagel suggested rebuilding the sysadmin database (unload custom tasks, drop sysadmin, restart the instance, or follow IBM's manual rebuild steps). Davorin Kremenjas suggested editing $INFORMIXDIR/etc/sysadmin/sch_aus.sql to add the ONLINE keyword to CREATE/DROP INDEX statements and add SET LOCK MODE TO WAIT in aus_load_dbs_data, then recreating the routines. The poster said he would try it; no confirmation of success is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
IDS 11.50FC5 for hp-ux 9000 the online.log information out every day 01:00 . the function aus_evaluator exist in database sysadmin . this page had mention the question, but did't give how to check the error, anyone can help? thank you! http://www.cniug.org/uploadfiles/IBM/2009IIUG/D08_Vega_Performance_Stories.pdf ==== online.log =========================================================== 01:00:08 SCHAPI: Error -242 Could not open database table (informix.aus_work_info). 01:00:08 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 01:00:08 SCHAPI: Error -154 ISAM error: Lock Timeout Expired 01:00:08 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 01:00:08 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error Message: Unable to execute function [ aus_evaluator(int eger,integer) ] .
You need to rebuild the sysadmin database. Here are the instructions: First UNLOAD any site specific tasks that you may have created that you cannot otherwise recreate. Next connect to the server in the sysadmin database as 'informix' and drop sysadmin then restart the instance which should automatically rebuild it. If that doesn't work or if you can't bounce the instance for some reason then follow the steps at this link to rebuild it manually: https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/rebuild_ sysadmin_database_manually_without?lang=en_us Art Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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, Jan 4, 2010 at 3:05 AM, NETSKY LIAO <liaosnet@126.com> wrote: > IDS 11.50FC5 for hp-ux 9000 > > the online.log information out every day 01:00 . the function aus_evaluator > exist in database sysadmin . > > this page had mention the question, but did't give how to check the error, > anyone can help? thank you! > > > http://www.cniug.org/uploadfiles/IBM/2009IIUG/D08_Vega_Performance_Stories.pdf > > ==== online.log =========================================================== > 01:00:08 SCHAPI: Error -242 Could not open database table > (informix.aus_work_info). > 01:00:08 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 01:00:08 SCHAPI: Error -154 ISAM error: Lock Timeout Expired > 01:00:08 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, > Location: NULL. > 01:00:08 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Error > Message: Unable to execute function [ aus_evaluator(int > eger,integer) ] . > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517477f1ef559a0047c550dcd
Hi, is the instance you're having issues with in HDR? Davorin
yes, in a HDR system..
only found them in the primary server,the secondary server none.
it only found in the HDR primary server. and there no error found in the IDS install. rebuild sysadmin may can repair this question, but don't know why it occur?
Hi, go to $INFORMIXDIR/etc/sysadmin, there's an SQL script called sch_aus.sql. Change all CREATE INDEX and DROP INDEX statements to include ONLINE as the last keyword and recreate the routines which have those statements. Also, in function "aus_load_dbs_data", SET LOCK MODE TO WAIT <something> and recreate it too. That should fix your problem. HTH Davorin
PLEASE!!!!! When you reply to a post you MUST MUST MUST quote enough of the post to which you are responding so that the rest of us, especially to poster to which you are replying, can know what you are saying and why! Most of the denizens of these forums DO NOT use the IIUG or other web interface to the forums, we use the email gateway and consequently do not have the thread history to refer back to. A reply like "I didn't find it." or "I only found it on HDR..." means nothing to us! Art Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Tue, Jan 5, 2010 at 4:28 AM, NETSKY LIAO <liaosnet@126.com> wrote: > it only found in the HDR primary server. and there no error found in the > IDS > install. > rebuild sysadmin may can repair this question, but don't know why it occur? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517479566869e54047c68aff6
Art Kagel wrote: Kvetch! :o) -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
2010/1/5 Art Kagel <art.kagel@gmail.com>: > PLEASE!!!!! When you reply to a post you MUST MUST MUST quote enough of the > post to which you are responding so that the rest of us, especially to > poster to which you are replying, can know what you are saying and why! > Most of the denizens of these forums DO NOT use the IIUG or other web > interface to the forums, we use the email gateway and consequently do not > have the thread history to refer back to. A reply like "I didn't find it." > or "I only found it on HDR..." means nothing to us! > > Art > > Art S. Kagel > AdvanceDataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf > > 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 Tue, Jan 5, 2010 at 4:28 AM, NETSKY LIAO <liaosnet@126.com> wrote: > >> it only found in the HDR primary server. and there no error found in the >> IDS >> install. >> rebuild sysadmin may can repair this question, but don't know why it occur? >> >> >> >> > ******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > > --001517479566869e54047c68aff6 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > And even if we were using a threaded reader, the message number appended by the forum means each reply has a different subject and won't thread anyway !! Keith
Shmendrik! Art Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Tue, Jan 5, 2010 at 6:08 AM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Art Kagel wrote: > > Kvetch! :o) > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00151747830873b52d047c6ab5ab
Putz! -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Smarmy git. ;^) Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Tue, Jan 5, 2010 at 8:32 AM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Putz! > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bd658e150ad047c6c03e2
Yiddish translator; " there's an app for that " Bob ----- Original Message ----- From: "Art Kagel" <art.kagel@gmail.com> To: ids@iiug.org Sent: Tuesday, January 5, 2010 9:54:39 AM GMT -05:00 US/Canada Eastern Subject: Re: IDS V11.50FC5: AUS error. [18530] Smarmy git. ;^) Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf 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 Tue, Jan 5, 2010 at 8:32 AM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Putz! > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > >
OK,I'll try to do it. Thank you very much. ------------------ liaosnet 2010-01-06 ------------------------------------------------------------- From£ºDAVORIN KREMENJAS Date£º2010-01-05 17:51:19 To£ºliaosnet@126.com Cc£º Subject: Re: IDS V11.50FC5: AUS error. [18524] Hi, go to $INFORMIXDIR/etc/sysadmin, there's an SQL script called sch_aus.sql. Change all CREATE INDEX and DROP INDEX statements to include ONLINE as the last keyword and recreate the routines which have those statements. Also, in function "aus_load_dbs_data", SET LOCK MODE TO WAIT <something> and recreate it too. That should fix your problem. HTH Davorin ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Oh...No.! I'm very very sorry for that. I'll try to use QUOTE next time.. Thank you for your advice. ------------------ NETSKY LIAO 2010-01-06 ------------------------------------------------------------- >PLEASE!!!!! When you reply to a post you MUST MUST MUST quote enough of the >post to which you are responding so that the rest of us, especially to >poster to which you are replying, can know what you are saying and why! >Most of the denizens of these forums DO NOT use the IIUG or other web >interface to the forums, we use the email gateway and consequently do not >have the thread history to refer back to. A reply like "I didn't find it." >or "I only found it on HDR..." means nothing to us! > >Art > >Art S. Kagel >AdvanceDataTools (www.advancedatatools.com) >IIUG Board of Directors (art@iiug.org) > >See you at the 2010 IIUG Informix Conference >April 25-28, 2010 >Overland Park (Kansas City), KS >www.iiug.org/conf > >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 Tue, Jan 5, 2010 at 4:28 AM, NETSKY LIAO <liaosnet@126.com> wrote: > >> it only found in the HDR primary server. and there no error found in the >> IDS >> install. >> rebuild sysadmin may can repair this question, but don't know why it occur? >> >> >> >> >******************************************************************************* >> Forum Note: Use "Reply" to post a response in the discussion forum. >> >> > >--001517479566869e54047c68aff6 > > >******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.