messages at online.log

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

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

Yes. It is an upgrade from 9.40. So. In any case, Is it safe to reconstruct sysadmin in a running productive environment? or should I take any special care? Thanks Art. --Nestor El lun, 26-04-2010 a las 23:41 -0400, Art Kagel escribió: > 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 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

From the session that Lester Knutson did at the conference, it's just a bunch of SQL files in the folder $INFORMIXDIR/etc/sysadmin. The create script for the database could be modified to move the sysadmin database out of rootdbs (where it is created by default), but read the link Art provided. -Simon

Yes, it is safe. 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 Tue, Apr 27, 2010 at 11:02 AM, nestor gomez munoz < nestorgm@prodigy.net.mx> wrote: > Yes. It is an upgrade from 9.40. > So. In any case, Is it safe to reconstruct sysadmin in a running > productive environment? or should I take any special care? > > Thanks Art. > > --Nestor > > El lun, 26-04-2010 a las 23:41 -0400, Art Kagel escribió: > > 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 > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd2e05c809bb0048563aa53