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

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

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.

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