Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2010-07-09T20:49:05Z by WaldemarZnoinski
NareshKKhurana
NareshKKhurana
3 Posts
ACCEPTED ANSWER

Pinned topic Problem when move sysadmin db in IDS 11.5. how to do?

‏2010-05-06T05:45:03Z |
I face the following error when I am moving sysadmin db from root dbs to another using
execute function sysadmin:task("reset sysadmin", "physdbs");
Command.

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.
Updated on 2010-07-09T20:49:05Z at 2010-07-09T20:49:05Z by WaldemarZnoinski
  • SystemAdmin
    SystemAdmin
    228 Posts
    ACCEPTED ANSWER

    Re: Problem when move sysadmin db in IDS 11.5. how to do?

    ‏2010-07-09T14:21:07Z  in response to NareshKKhurana
    It seems that you have not closed sysadmin db in the session where the "reset sysadmin" task was issued.
  • WaldemarZnoinski
    WaldemarZnoinski
    1 Post
    ACCEPTED ANSWER

    Re: Problem when move sysadmin db in IDS 11.5. how to do?

    ‏2010-07-09T20:49:05Z  in response to NareshKKhurana
    hey 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