Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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?
per finderr -710 this occurs when an object changes and a query plan has to be
re-optimized.
This error may have stopped occuring since the query plan has since been
reoptimized but if it continues to occur try this : (if it still continues
after this then contact tech support).
dbaccess sysadmin -
update statistiscs for procedure;
Mark
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.