Alert in OAT
A user on IDS 11.50.FC6 (SLES 11) saw a daily OAT alert from the Auto Update Statistics Refresh task: "ERROR -206 The specified table (aus_work_dist) is not in the database" plus ISAM -111. The AUS Evaluation task ran fine, but the aus_work_dist table was missing. Respondents concluded the sysadmin database was incomplete/out of sync with the engine's AUS routines, and recommended rebuilding it: drop sysadmin, then run db_create.sql, db_install.sql, sch_tasks.sql, sch_aus.sql, sch_sqlcap.sql and start.sql from $INFORMIXDIR/etc/sysadmin (saving any custom tasks first); restarting the engine also rebuilds it if absent. An IBM support link was also posted. No confirmation from the poster that it worked is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I have seen this show up every day after the update statistics refresh task runs. TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The specified table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no record found. We don't have that table in our database (nor should we for our applications). So how do I tell the statistics program to stop looking for it? Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> ============================== SLES 11x64 & IDS 11.50.FC6 "Don't document the problem, fix it." - Atli Björgvin Oddsson
The AUS Refresh task depends on the AUS Evaluation task execution. It will run "nothing" if the first task could not choose any tables to update the stats. I recommend you to check the Evaluation task results, and if it´s running before ok? Best regards. Em 30/07/2010 13:09, Wyza, Jonathon escreveu: > I have seen this show up every day after the update statistics refresh task > runs. > > TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The specified > table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no record > found. > > We don't have that table in our database (nor should we for our applications). > So how do I tell the statistics program to stop looking for it? > > Jonathon Wyza > CX& CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> > ============================== > SLES 11x64& IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Björgvin Oddsson > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11
AUS Eval runs from 1:00 to 1:10 daily.
AUS Refresh runs from 1:11 to 5:00 daily.
I just ran Refresh Evaluation and it seems to have run fine, showing 1300
tables that need to be refreshed.
I don't think that's the problem though. It seems that the table aus_work_dist
doesn't exist at all, and I'm guessing its required for aus to function
properly.
Jonathon Wyza
CX & CBORD System Administrator
CX Programmer/Analyst
Administrative Computing
Bethel College
(574)-257-3381
AIM: Iamwyza
jonathon.wyza@bethelcollege.edu
==============================
SLES 11x64 & IDS 11.50.FC6
"Don't document the problem, fix it."
- Atli Björgvin Oddsson
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Alexandre Marini
Sent: Friday, July 30, 2010 1:19 PM
To: ids@iiug.org
Subject: Re: Alert in OAT [20714]
The AUS Refresh task depends on the AUS Evaluation task execution.
It will run "nothing" if the first task could not choose any tables to update
the stats.
I recommend you to check the Evaluation task results, and if it´s running
before ok?
Best regards.
Em 30/07/2010 13:09, Wyza, Jonathon escreveu:
> I have seen this show up every day after the update statistics refresh
> task runs.
>
> TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The
> specified table (aus_work_dist) is not in the database. ERROR -111
> ISAM error: norecord
> found.
>
> We don't have that table in our database (nor should we for our
applications).
> So how do I tell the statistics program to stop looking for it?
>
> Jonathon Wyza
> CX& CBORD System Administrator
> CX Programmer/Analyst
> Administrative Computing
> Bethel College
> (574)-257-3381
> AIM: Iamwyza
> jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu
> >
> ==============================
> SLES 11x64& IDS 11.50.FC6
>
> "Don't document the problem, fix it."
> - Atli Björgvin Oddsson
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Did you upgrade recently? It's possible that the sysadmin data base didn't get properly updated and you are running with versions of the schema and UDRs that are out-of-sync. The engine upgrade would have installed a new version of the shared library containing the C routines that actually implement AUS. If the database schema wasn't updated that's why you are getting this error. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, 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 Fri, Jul 30, 2010 at 1:09 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote: > I have seen this show up every day after the update statistics refresh task > runs. > > TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The specified > table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no > record > found. > > We don't have that table in our database (nor should we for our > applications). > So how do I tell the statistics program to stop looking for it? > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> > ============================== > SLES 11x64 & IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Björgvin Oddsson > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e65ae5a0af6102048c9e857b
Ok, please check you sysadmin construction files
on $INFORMIXDIR/etc/sysadmin
I did a grep here and found the specified table on my sch_aus.sql file.
If it is located there on your file, I suggest you to rebuild your
sysadmin database for fixing the database, ok?
Em 30/07/2010 13:41, Wyza, Jonathon escreveu:
> AUS Eval runs from 1:00 to 1:10 daily.
> AUS Refresh runs from 1:11 to 5:00 daily.
>
> I just ran Refresh Evaluation and it seems to have run fine, showing 1300
> tables that need to be refreshed.
>
> I don't think that's the problem though. It seems that the table
aus_work_dist
> doesn't exist at all, and I'm guessing its required for aus to function
> properly.
>
> Jonathon Wyza
> CX& CBORD System Administrator
> CX Programmer/Analyst
> Administrative Computing
> Bethel College
> (574)-257-3381
> AIM: Iamwyza
> jonathon.wyza@bethelcollege.edu
> ==============================
> SLES 11x64& IDS 11.50.FC6
>
> "Don't document the problem, fix it."
> - Atli Björgvin Oddsson
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Alexandre Marini
> Sent: Friday, July 30, 2010 1:19 PM
> To: ids@iiug.org
> Subject: Re: Alert in OAT [20714]
>
> The AUS Refresh task depends on the AUS Evaluation task execution.
> It will run "nothing" if the first task could not choose any tables to update
> the stats.
> I recommend you to check the Evaluation task results, and if it´s running
> before ok?
>
> Best regards.
>
> Em 30/07/2010 13:09, Wyza, Jonathon escreveu:
>> I have seen this show up every day after the update statistics refresh
>> task runs.
>>
>> TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The
>> specified table (aus_work_dist) is not in the database. ERROR -111
>> ISAM error: no> record
>> found.
>>
>> We don't have that table in our database (nor should we for our
> applications).
>> So how do I tell the statistics program to stop looking for it?
>>
>> Jonathon Wyza
>> CX& CBORD System Administrator
>> CX Programmer/Analyst
>> Administrative Computing
>> Bethel College
>> (574)-257-3381
>> AIM: Iamwyza
>> jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu
>> ==============================
>> SLES 11x64& IDS 11.50.FC6
>>
>> "Don't document the problem, fix it."
>> - Atli Björgvin Oddsson
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
--
Alexandre Marini
Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix
Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg>
IBM Informix Dynamic Server Certified Professional V10 / V11
We "upgraded" to IDS 11.5 last month, but really it was a fresh install (fresh OS install too) and just copying data over. When we did that the only thing I copied over were our application dbspaces. I let the installer build the new sysmaster db. I didn't do anything special, just install and configure onconf. Jonathon Wyza CX & CBORD System Administrator CX Programmer/Analyst Administrative Computing Bethel College (574)-257-3381 AIM: Iamwyza jonathon.wyza@bethelcollege.edu ============================== SLES 11x64 & IDS 11.50.FC6 "Don't document the problem, fix it." - Atli Björgvin Oddsson -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Friday, July 30, 2010 1:53 PM To: ids@iiug.org Subject: Re: Alert in OAT [20716] Did you upgrade recently? It's possible that the sysadmin data base didn't get properly updated and you are running with versions of the schema and UDRs that are out-of-sync. The engine upgrade would have installed a new version of the shared library containing the C routines that actually implement AUS. If the database schema wasn't updated that's why you are getting this error. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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, 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 Fri, Jul 30, 2010 at 1:09 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote: > I have seen this show up every day after the update statistics refresh task > runs. > > TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The specified > table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no > record > found. > > We don't have that table in our database (nor should we for our > applications). > So how do I tell the statistics program to stop looking for it? > > Jonathon Wyza > CX & CBORD System Administrator > CX Programmer/Analyst > Administrative Computing > Bethel College > (574)-257-3381 > AIM: Iamwyza > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu> > ============================== > SLES 11x64 & IDS 11.50.FC6 > > "Don't document the problem, fix it." > - Atli Björgvin Oddsson > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e65ae5a0af6102048c9e857b ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Try rebuilding the sysadmin database. It can't hurt. If you have any site
specific tasks or scripts you have created, save them before dropping the
database. There's a link w/instructions for doing that, the build fails in
certain of the 11.50 releases. Let's see if I can find the link for you.
.... OK Here are the instructions:
Here is an example of rebuild sysadmin database manually:
1. echo "drop database sysadmin;" | dbaccess sysmaster -
2. cd $INFORMIXDIR/etc/sysadmin
3. dbaccess - - db_create.sql
4. dbaccess sysadmin db_install.sql
5. dbaccess sysadmin sch_tasks.sql
6. dbaccess sysadmin sch_aus.sql
7. dbaccess sysadmin sch_sqlcap.sql
8. dbaccess sysadmin start.sql
If you encountered any problem during above mentioned process, restarting
IDS automatically rebuilds the sysadmin database if it doesn't exist and as
long as the '$INFORMIXDIR/etc/sysadmin/stop' file is not exist.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.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, 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 Fri, Jul 30, 2010 at 1:59 PM, Wyza, Jonathon <wyzaj@bethelcollege.edu>wrote:
> We "upgraded" to IDS 11.5 last month, but really it was a fresh install
> (fresh
> OS install too) and just copying data over. When we did that the only thing
> I
> copied over were our application dbspaces. I let the installer build the
> new
> sysmaster db. I didn't do anything special, just install and configure
> onconf.
>
> Jonathon Wyza
> CX & CBORD System Administrator
> CX Programmer/Analyst
> Administrative Computing
> Bethel College
> (574)-257-3381
> AIM: Iamwyza
> jonathon.wyza@bethelcollege.edu
> ==============================
> SLES 11x64 & IDS 11.50.FC6
>
> "Don't document the problem, fix it."
> - Atli Björgvin Oddsson
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Friday, July 30, 2010 1:53 PM
> To: ids@iiug.org
> Subject: Re: Alert in OAT [20716]
>
> Did you upgrade recently? It's possible that the sysadmin data base didn't
> get
> properly updated and you are running with versions of the schema and UDRs
> that
> are out-of-sync. The engine upgrade would have installed a new version of
> the
> shared library containing the C routines that actually implement AUS. If
> the
> database schema wasn't updated that's why you are getting this error.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.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, 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 Fri, Jul 30, 2010 at 1:09 PM, Wyza, Jonathon
> <wyzaj@bethelcollege.edu>wrote:
>
> > I have seen this show up every day after the update statistics refresh
> task
> > runs.
> >
> > TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The
> specified
> > table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no
> > record
> > found.
> >
> > We don't have that table in our database (nor should we for our
> > applications).
> > So how do I tell the statistics program to stop looking for it?
> >
> > Jonathon Wyza
> > CX & CBORD System Administrator
> > CX Programmer/Analyst
> > Administrative Computing
> > Bethel College
> > (574)-257-3381
> > AIM: Iamwyza
> > jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu>
> > ==============================
> > SLES 11x64 & IDS 11.50.FC6
> >
> > "Don't document the problem, fix it."
> > - Atli Björgvin Oddsson
> >
> >
> >
> >
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --0016e65ae5a0af6102048c9e857b
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--e0cb4e88781188fbcd048c9f3786
Here is the link I think Art is looking for. I have had to do this a few
times. http://www-01.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=S
SZ2HS&context=SSP6X2&context=SSVHPS&context=SSHPYE&q1=sysadmin&uid=swg21266296&l
oc=en_US&cs=utf-8&lang=en
John A. Chauvin
Sr. Technical Consultant
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> Kagel
> Sent: Friday, July 30, 2010 13:43
> To: ids@iiug.org
> Subject: Re: Alert in OAT [20719]
>
> Try rebuilding the sysadmin database. It can't hurt. If you have any site
> specific tasks or scripts you have created, save them before dropping the
> database. There's a link w/instructions for doing that, the build fails in
> certain of the 11.50 releases. Let's see if I can find the link for you.
> ..... OK Here are the instructions:
>
> Here is an example of rebuild sysadmin database manually:
>
> 1. echo "drop database sysadmin;" | dbaccess sysmaster -
>
> 2. cd $INFORMIXDIR/etc/sysadmin
>
> 3. dbaccess - - db_create.sql
>
> 4. dbaccess sysadmin db_install.sql
>
> 5. dbaccess sysadmin sch_tasks.sql
>
> 6. dbaccess sysadmin sch_aus.sql
>
> 7. dbaccess sysadmin sch_sqlcap.sql
>
> 8. dbaccess sysadmin start.sql
>
> If you encountered any problem during above mentioned process, restarting
> IDS automatically rebuilds the sysadmin database if it doesn't exist and as
> long as the '$INFORMIXDIR/etc/sysadmin/stop' file is not exist.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.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, 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 Fri, Jul 30, 2010 at 1:59 PM, Wyza, Jonathon
> <wyzaj@bethelcollege.edu>wrote:
>
> > We "upgraded" to IDS 11.5 last month, but really it was a fresh install
> > (fresh
> > OS install too) and just copying data over. When we did that the only thing
> > I
> > copied over were our application dbspaces. I let the installer build the
> > new
> > sysmaster db. I didn't do anything special, just install and configure
> > onconf.
> >
> > Jonathon Wyza
> > CX & CBORD System Administrator
> > CX Programmer/Analyst
> > Administrative Computing
> > Bethel College
> > (574)-257-3381
> > AIM: Iamwyza
> > jonathon.wyza@bethelcollege.edu
> > ==============================
> > SLES 11x64 & IDS 11.50.FC6
> >
> > "Don't document the problem, fix it."
> > - Atli Björgvin Oddsson
> >
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art
> > Kagel
> > Sent: Friday, July 30, 2010 1:53 PM
> > To: ids@iiug.org
> > Subject: Re: Alert in OAT [20716]
> >
> > Did you upgrade recently? It's possible that the sysadmin data base didn't
> > get
> > properly updated and you are running with versions of the schema and UDRs
> > that
> > are out-of-sync. The engine upgrade would have installed a new version of
> > the
> > shared library containing the C routines that actually implement AUS. If
> > the
> > database schema wasn't updated that's why you are getting this error.
> >
> > Art
> >
> > Art S. Kagel
> > Advanced DataTools (www.advancedatatools.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, 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 Fri, Jul 30, 2010 at 1:09 PM, Wyza, Jonathon
> > <wyzaj@bethelcollege.edu>wrote:
> >
> > > I have seen this show up every day after the update statistics refresh
> > task
> > > runs.
> > >
> > > TASK NAME Auto Update Statistics Refresh LOCATION ERROR -206 The
> > specified
> > > table (aus_work_dist) is not in the database. ERROR -111 ISAM error: no
> > > record
> > > found.
> > >
> > > We don't have that table in our database (nor should we for our
> > > applications).
> > > So how do I tell the statistics program to stop looking for it?
> > >
> > > Jonathon Wyza
> > > CX & CBORD System Administrator
> > > CX Programmer/Analyst
> > > Administrative Computing
> > > Bethel College
> > > (574)-257-3381
> > > AIM: Iamwyza
> > >
> jonathon.wyza@bethelcollege.edu<mailto:jonathon.wyza@bethelcollege.edu>
> > > ==============================
> > > SLES 11x64 & IDS 11.50.FC6
> > >
> > > "Don't document the problem, fix it."
> > > - Atli Björgvin Oddsson
> > >
> > >
> > >
> > >
> >
> >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --0016e65ae5a0af6102048c9e857b
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --e0cb4e88781188fbcd048c9f3786
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>