Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Migration the Instance

    Hello,

    I have a problem with migration of db2 instance. There are 2 databases; ISK and ADMISK. After "db2stop force" both databases are consistent, but the result of command "db2ckmig -e" is: "Database ISKADM is in an inconsistent state and it must be restarted." Based on OSS note 553963 I deactivated the database ADMISK and executed the command "db2ckmig ADMISK". The db2ckmig was successful.
    Afterwards I stopped the db and executed the command "db2imigr -u db2isk db2isk" (as root), but the migration terminated with error: "Database ISKADM is in an inconsistent state and it must be restarted."

    How can i migrate the instance in this case ?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Migration the Instance

    Never do a 'force' ... Always stop you applications gracefully ... If you do this way, you will not get inconsistent state error

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    Re:

    Hello Sathyaram,

    I dropped the database ADMISK, and the migration finished successfully. Later I will recreate the database with command "sddb6ins -i".

    Thanks for reply.


    Best Regards

    Zsolt Csonka

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •