IDS Forum

Re: messages at online.log

Posted By: Art Kagel
Date: Monday, 26 April 2010, at 11:41 p.m.

In Response To: messages at online.log (nestor gomez munoz)

Is this a recent upgrade to 11.50 from an earlier release? It sounds like
the sysadmin data was not created correctly which sometimes happens during
upgrades. Here's a link that explains who to rebuild sysadmin:

https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/tags/sysadmin?lang=en

Art

Art S. Kagel
Advanced DataTools (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, 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 Mon, Apr 26, 2010 at 11:08 PM, nestor gomez munoz <
nestorgm@prodigy.net.mx> wrote:

> Hello
>
> We have Informix IDS 11.50FC5 on Solaris 10 Spark.
>
> I can see this messages at the online.log file but I can't realize how
> bad can it be that situation. Could anybody tell me some tips about what
> should I check on our system?
>
> Thanks in advance
>
> --Nestor
>
> 01:00:01 SCHAPI: Error -214 Cannot remove file for table
> (informix.aus_command).
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,
> Location: NULL.
> 01:00:01 SCHAPI: Error -106 ISAM error: non-exclusive access.
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,
> Location: NULL.
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation,
> Error Message: Unable to execute function [ aus_evaluator(int
> eger,integer) ] .
> 01:00:01 SCHAPI: Error -710 Table (informix.aus_command) has been
> dropped, altered or renamed.
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Location: NULL.
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Error Message: Unable to execute function [ aus_refresh_stats(in
> teger,integer) ] .
> 01:00:01 SCHAPI: Error -710 Table (informix.aus_command) has been
> dropped, altered or renamed.
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Location: NULL.
> 01:00:01 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Error Message: Unable to execute function [ aus_refresh_stats(in
> teger,integer) ] .
> 01:00:37 Checkpoint Completed: duration was 0 seconds.
> 01:00:37 Sat Apr 24 - loguniq 37252, logpos 0x5ad4018, timestamp:
> 0x80b77685 Interval: 26443
>
> 01:00:37 Maximum server connections 77
> 01:00:37 Checkpoint Statistics - Avg. Txn Block Time 0.002, # Txns
> blocked 1, Plog used 456, Llog used 5197
>
> 01:00:50 Logical Log 37252 Complete, timestamp: 0x80b79d86.
> 01:03:50 Logical Log 37253 Complete, timestamp: 0x80ba5cc4.
> 01:08:13 SCHAPI: thread dbWorker1 task post_alarm_message(15-1687)
> shutting down
> 01:08:13 SCHAPI: Error -213 Statement interrupted by user.
> 01:08:13 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Location: NULL.
> 01:08:13 SCHAPI: thread dbWorker2 task post_alarm_message(15-1688)
> shutting down
> 01:08:13 SCHAPI: Error -213 Statement interrupted by user.
> 01:08:13 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Location: NULL.
> 01:08:13 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Error Message: Unable to execute function [ aus_refresh_stats(in
> teger,integer) ] .
> 01:08:13 SCHAPI: Error -213 Statement interrupted by user.
> 01:08:13 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Location: NULL.
> 01:08:13 SCHAPI: Error -213 Statement interrupted by user.
> 01:08:13 SCHAPI: Type: TASK, Name: Auto Update Statistics Refresh,
> Location: NULL.
> 01:10:42 Checkpoint Completed: duration was 6 seconds.
> 01:10:42 Sat Apr 24 - loguniq 37254, logpos 0x10fc018, timestamp:
> 0x80bb0ae5 Interval: 26444
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--000e0cd480b033c9c704852fab56

Messages In This Thread

• messages at online.log
  nestor gomez munoz -- Monday, 26 April 2010, at 11:08 p.m.
  • Re: messages at online.log
    Art Kagel -- Monday, 26 April 2010, at 11:41 p.m.
    • Re: messages at online.log
      nestor gomez munoz -- Tuesday, 27 April 2010, at 11:02 a.m.
      • Re: messages at online.log
        SIMON COYNE -- Thursday, 29 April 2010, at 10:03 a.m.
      • Re: messages at online.log
        Art Kagel -- Thursday, 29 April 2010, at 1:43 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.