sysadmin setup incomplete in IDS 11.5 Windows XP

When running IDS 11.5 on Windows XP Professional I am getting following error in online.log. Initially when database is installed, sysadmin setup gets completed but later on I am observing sysadmin database setup failed problem. Also I am not able to access sysadmin database through dbaccess. I get no connect permission but I am able to create, alter databases in informix server. Also please convey if possible how to take logical log backups in Windows if you do not have tape drive attached to laptop. 09:29:29 On-Line Mode 09:29:30 SCHAPI: Started dbScheduler thread. 09:29:34 SCHAPI: SQL Error -673, ISAM Error 0 in file D:\\\\IBM\\\\Informix/etc/sysadmin/low_memory_mgr.sql at line 21 09:29:34 SCHAPI: 'sysadmin' database setup is incomplete. 09:29:34 SCHAPI: SQL Error -625, ISAM Error 0 in file D:\\\\IBM\\\\Informix/etc/sysadmin/upgrade_ph_task.sql at line 20 09:29:35 SCHAPI: 'sysadmin' database setup is incomplete. 09:29:35 Booting Language <spl> from module <> 09:29:35 Loading Module <SPLNULL> 09:29:35 SCHAPI: [NULL 0-0] Error -1263 A field in a datetime or interval value is incorrect or an illegal operation specified on datetime field. 09:29:35 SCHAPI: Failed to setup dbScheduler thread. 09:29:35 SCHAPI: thread dbScheduler(47) shutting down

Hello. You could just make sure your scheduller threads are not running: onstat -g ath |grep dbScheduler And then, you could rebuild your sysadmin, maybe some upgrade failed and is now causing troubles. Check this link: https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/rebuild_ sysadmin_database_manually_without?lang=en Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator > To: ids@iiug.org > From: prajakta_s_c@yahoo.co.in > Subject: sysadmin setup incomplete in IDS 11.5 Windows XP [27225] > Date: Fri, 25 May 2012 00:44:43 -0400 > > When running IDS 11.5 on Windows XP Professional I am getting following error > in online.log. Initially when database is installed, sysadmin setup gets > completed but later on I am observing sysadmin database setup failed problem. > > Also I am not able to access sysadmin database through dbaccess. I get no > connect permission but I am able to create, alter databases in informix > server. > > Also please convey if possible how to take logical log backups in Windows if > you do not have tape drive attached to laptop. > > 09:29:29 On-Line Mode > 09:29:30 SCHAPI: Started dbScheduler thread. > 09:29:34 SCHAPI: SQL Error -673, ISAM Error 0 in file > D:\\\\IBM\\\\Informix/etc/sysadmin/low_memory_mgr.sql at line 21 > 09:29:34 SCHAPI: 'sysadmin' database setup is incomplete. > 09:29:34 SCHAPI: SQL Error -625, ISAM Error 0 in file > D:\\\\IBM\\\\Informix/etc/sysadmin/upgrade_ph_task.sql at line 20 > 09:29:35 SCHAPI: 'sysadmin' database setup is incomplete. > 09:29:35 Booting Language <spl> from module <> > 09:29:35 Loading Module <SPLNULL> > 09:29:35 SCHAPI: [NULL 0-0] Error -1263 A field in a datetime or interval > value is incorrect or an illegal operation > specified on datetime field. > > 09:29:35 SCHAPI: Failed to setup dbScheduler thread. > 09:29:35 SCHAPI: thread dbScheduler(47) shutting down > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

This is the output of onstat -g ath onstat -g ath | grep dbScheduler gives no output IBM Informix Dynamic Server Version 11.50.TC9DE -- On-Line -- Up 00:42:22 --78208 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 103da970 0 1 IO Idle 3lio* lio vp 0 3 103f4210 0 1 IO Idle 4pio* pio vp 0 4 1040e210 0 1 IO Idle 5aio* aio vp 0 5 10428210 0 1 IO Idle 6msc* msc vp 0 6 1045e210 0 1 IO Idle 7fifo* fifo vp 0 7 10478468 1025f018 3 sleeping secs: 1 1cpu* main_loop() 8 103f4d60 0 1 running 8soc* soctcppoll 9 1040e588 0 1 running 9soc* soctcpio 10 1040e888 0 2 sleeping forever 1cpu* soctcplst 11 1040ee48 1025f610 1 sleeping secs: 1 1cpu* flush_sub(0) 12 10428518 1025fc08 1 sleeping secs: 1 1cpu* flush_sub(1) 13 10428728 10260200 1 sleeping secs: 1 1cpu* flush_sub(2) 14 10428938 102607f8 1 sleeping secs: 1 1cpu* flush_sub(3) 15 10428b48 10260df0 1 sleeping secs: 1 1cpu* flush_sub(4) 16 10428d58 102613e8 1 sleeping secs: 1 1cpu* flush_sub(5) 17 1045e498 102619e0 1 sleeping secs: 1 1cpu* flush_sub(6) 18 1045e628 10261fd8 1 sleeping secs: 1 1cpu* flush_sub(7) 19 106074b8 0 3 IO Idle 1cpu* kaio 20 10607b80 102625d0 2 sleeping secs: 1 1cpu* aslogflush 21 1083a630 10262bc8 1 sleeping secs: 136 1cpu* btscanner_0 22 1083aac0 102631c0 3 sleeping secs: 1 1cpu* onmode_mon 23 1087a018 102637b8 3 sleeping secs: 1 1cpu* periodic 33 10a635d0 102643a8 1 cond wait bp_cond 1cpu* bf_priosweep() Will be trying rebuild sysadmin database manually shortly.