Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Unanswered: migration (v8.1 to v.91)

    Hi,
    m using db2 v9.1 ESE on windows
    i am trying to migrate databases on v8.1 to v9.1 using the backup image of those databases but it is throwing this error:

    SQL1704N Database migration failed. Reason code "3". LINE NUMBER=0.

    what ibm suggested is, increase the logfile size of the database you are trying to migrate. but in order to do that i need to first connect to the database but trying to do that throws the following error:

    SQL5035N The database requires migration to the current release.
    SQLSTATE=55001

    what is the next step i can try doing now?

  2. #2
    Join Date
    Nov 2007
    Posts
    72
    what process you are following to migrate ? explain in detail

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    No, you don't need to connect to the database. You only need to attach to the instance in order to change DB CFG parameters. Exactly which statements do you try to execute?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jul 2008
    Posts
    131
    hey thanks, i have successfully migrated the databases...
    i have increased the logfile size, then gave the migrate database command and have again reset the default logfilesize...

Posting Permissions

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