Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    1

    Unanswered: Restoration of DB2 on Diff. machine

    Hi

    I hv a backup image of the offline database.(db2 7.2
    Windows o/s)
    I hv installed DB2 7.2 in WinXP. Now i need to restore the
    database from the backup image.

    I tried with command

    restore db smp from
    C:/db2backup/21012005/SMP.0/DB2SMP/NODE0000/CATN0000/20050121
    But resulted in vain.I got the error SQL1403N "An
    unexpected USER was found after continue.

    Also tried with other options like
    restore db smp from
    C:/db2backup/21012005/SMP.0/DB2SMP/NODE0000/CATN0000/20050121
    USER db2admin using <passwd> CONTINUE.

    But resulted in same error.
    Can u pls. help me in this regard


    Regards
    Fayaz

  2. #2
    Join Date
    Jan 2005
    Posts
    30
    Try following as a workaround:

    1) Create a database on Win XP with same database name, codeset as on source Windows machine. Also use the same user to create the database.

    2) Now use the restore command with ‘INTO’ clause.

    Hope this will help you.

    __
    SC

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by fayazullal
    Hi

    I hv a backup image of the offline database.(db2 7.2
    Windows o/s)
    I hv installed DB2 7.2 in WinXP. Now i need to restore the
    database from the backup image.

    I tried with command

    restore db smp from
    C:/db2backup/21012005/SMP.0/DB2SMP/NODE0000/CATN0000/20050121
    But resulted in vain.I got the error SQL1403N "An
    unexpected USER was found after continue.
    u don't hv to spcfy da entire path there. I thnk "restore db smp from C:/db2backup/21012005" shud b suffcnt. I hop dis gonna wkr 4 u.

  4. #4
    Join Date
    Jan 2005
    Posts
    191
    What backup are you restoring? Use the TAKEN AT clause to specify the backup's timestamp.

    Specify the same directory in FROM as you used in the BACKUP ... TO .... "On OS/2 or the Windows operating system, the specified directory must not be a DB2-generated directory." I don't know if the direction of the slashes is significant.

    You can use INTO target-database-alias to create the database during the restore.

    The V7 RESTORE description has the comment "[t]o restore a database that was backed up on a different workstation platform, use db2move - Database Movement Tool." I don't know if you fall into this category.

    James Campbell

Posting Permissions

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