I face the following error when I am moving sysadmin db from root dbs to another using
execute function sysadmin:task("reset sysadmin", "physdbs");
08:23:36 SCHAPI: thread dbWorker2 task mb_upd_replicate(19-2402638) shutting down
08:23:36 SCHAPI: thread dbWorker1 task mb_ins_replicate(18-2342228) shutting down
08:23:36 SCHAPI: thread dbScheduler task mb_upd_replicate(0-2402639) shutting down
08:23:36 SCHAPI: 'sysadmin' database will be moved to 'physdbs'. See online message log.
08:23:36 Building 'sysadmin' database ...
08:25:31 Checkpoint Completed: duration was 0 seconds.
08:25:31 Thu May 6 - loguniq 8850429, logpos 0xf0f018, timestamp: 0x37bdb68c Interval: 204501
08:25:31 Maximum server connections 4
08:25:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 16, Llog used 9
08:27:31 Checkpoint Completed: duration was 0 seconds.
08:27:31 Thu May 6 - loguniq 8850429, logpos 0xf11018, timestamp: 0x37bdb6e2 Interval: 204502
08:27:31 Maximum server connections 4
08:27:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 2
08:28:36 SCHAPI: SQL Error -349, ISAM Error -101 in file /usr/informix/etc/sysadmin/db_install.sql at line 28
08:28:36 Error building 'sysadmin' database.
08:29:32 Checkpoint Completed: duration was 0 seconds.
08:29:32 Thu May 6 - loguniq 8850429, logpos 0xf14018, timestamp: 0x37bdb754 Interval: 204503A
I am using Informix Dynamic Server Version 11.50.UC4WE on Linux 4.
This topic has been locked.
2 replies Latest Post - 2010-07-09T20:49:05Z by WaldemarZnoinski
Pinned topic Problem when move sysadmin db in IDS 11.5. how to do?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2010-07-09T20:49:05Z at 2010-07-09T20:49:05Z by WaldemarZnoinski
WaldemarZnoinski 27000382F51 PostACCEPTED ANSWER
Re: Problem when move sysadmin db in IDS 11.5. how to do?2010-07-09T20:49:05Z in response to NareshKKhuranahey there,
it depends what you have at line 28 in /usr/informix/etc/sysadmin/db_install.sql
$INFORMIXDIR/etc/sysadmin/*.sql files are used to build sysadmin db