Results 1 to 4 of 4

Thread: Sql5035n

  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: Sql5035n

    Hi,

    Working on v8.1.0.36 on Windows 2000 Advanced Server Version 5.0.2195 Service Pack 2.

    Had installed v7.2 earlier and wanted to migrate to v8.1. Ran the 8.1 installation and during the installation ran the DB2CKMIG unitlity which I believed would take care of migration prodecures.

    After installing the new version am not able to connect to or open database. Gives the following error:

    [IBM][CLI Driver] SQL5035N The database requires migration to
    the current release. SQLSTATE=55001

    Also tried to restore the backup which was taken before the new version installation. Get the error as follows:

    SQL0104N An unexpected token "PROMPTING;" was found following
    "WITHOUT". Expected tokens may include: "ROLLING".

    Any ideas on how I can start using my DB?

    Thanks.

  2. #2
    Join Date
    Apr 2003
    Posts
    191

    Re: Sql5035n

    Hi,

    DB2CKMIG only checks if a "db2 migrate db" command would presumably be successfull. You should read up on this command first.

    Johann

    Originally posted by pankan
    Hi,

    Working on v8.1.0.36 on Windows 2000 Advanced Server Version 5.0.2195 Service Pack 2.

    Had installed v7.2 earlier and wanted to migrate to v8.1. Ran the 8.1 installation and during the installation ran the DB2CKMIG unitlity which I believed would take care of migration prodecures.

    After installing the new version am not able to connect to or open database. Gives the following error:

    [IBM][CLI Driver] SQL5035N The database requires migration to
    the current release. SQLSTATE=55001

    Also tried to restore the backup which was taken before the new version installation. Get the error as follows:

    SQL0104N An unexpected token "PROMPTING;" was found following
    "WITHOUT". Expected tokens may include: "ROLLING".

    Any ideas on how I can start using my DB?

    Thanks.

  3. #3
    Join Date
    Nov 2003
    Posts
    6

    Re: Sql5035n

    Hi,

    Thanx Johann. Any ideas on how I can start my DB? Desperate now.


    Originally posted by jsander
    Hi,

    DB2CKMIG only checks if a "db2 migrate db" command would presumably be successfull. You should read up on this command first.

    Johann

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

    Re: Sql5035n

    See if the following infomration helps :

    C:\Documents and Settings\Sathyaram>db2 ? sql5035n


    SQL5035N The database requires migration to the current
    release.

    Explanation:

    The database was created on a lower level system release. The
    Migrate Database command must be used to convert the database to
    the current release level.

    The command cannot be processed.

    User Response:

    Perform the Migrate Database command before attempting to use the
    database with the current system release.

    If this message is received during a restore, drop the existing
    database before proceeding.

    sqlcode : -5035

    sqlstate : 55001


    C:\Documents and Settings\Sathyaram>db2 ? migrate
    MIGRATE DATABASE database-alias [USER username [USING password]]

    NOTE: From the operating system prompt, prefix commands with 'db2'.
    Special characters MAY require an escape sequence (\), for example:
    db2 \? change database
    db2 ? change database xxx comment with \"text\"
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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