Re: mon_page_usage Error in Logs
Go into the sysadmin database as user informix and recompile all of the
stored procedures with:
update statistics for procedure;
That will stop those messages. The query plan stored with one of the
procedures/functions used by the monitors has become invalid, probably
because AUS (Auto Update Statistics) ran on the tables in sysadmin but did
not recompile the procedures.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
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 Tue, Feb 14, 2012 at 11:44 AM, Rubinstein, James
<JRUBIN@midwestern.edu>wrote:
> I’m running IDS 11.50.FC6 on HPUX 11.31. Yesterday, I had the following
> message in the online logs:****
>
> ** **
>
> 14:55:29 SCHAPI: [mon_page_usage 28-1] Error -710 Table
> (informix.mon_page_usage) has been dropped, altered or renamed.****>
> ** **
>
> I don’t see any mention of mon_page_usage in the IDS documentation or in
> the $INFORMIXDIR/etc/sysadmin scripts. ****
>
> ** **
>
> We do have mon_page_usage in the sysadmin database with the following
> fields:****
>
> ** **
>
> Column name Type Nulls****
>
> ** **
>
> id integer yes****
>
> dbsnum smallint yes****
>
> type char(1) yes****
>
> partnum integer yes****
>
> lockid integer yes****
>
> nextns smallint yes****
>
> nrows integer yes****
>
> nptotal integer yes****
>
> npused integer yes****
>
> free integer yes****
>
> partly_used integer yes****
>
> mostly_used integer yes****
>
> very_full integer yes****
>
> run_time datetime year to second yes****
>
> ** **
>
> We also have 11,010 records in this table all with a run_time = 2012-02-13
> 14:59:07. ****
>
> ** **
>
> Do I have to worry about or act on this this message?****
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>