db2 "restore database xyz from Path_to_BackupDirectory into abc redirect generate script xyz.clp without rolling forward"
SQL2032N The "restore_mode" parameter is not valid. SQLSTATE=55039

What DB2 version and OS are you using?

Andy

db2 V9.1 FP7 and OS AIX 5.3

Does the abc database exist?

Andy

You want to generate a script???
Try without "without rolling forward". It's not needed for script generation.

abc database exist...
specifying without rolling forward as its coldbackup image

tried without "without rolling forward" also, same error

source database and target database are on same server but different instance and file system, so need to generate script

Try adding these clauses: "REPLACE EXISTING" and "WITHOUT PROMPTING".

Andy

Thanks for all your replies friendz but nothing worked. I tried other alternative and that helped.

1. db2 " restore database xyz (skip into part) redirect generate script scriptname.clp without rolling forward"
2. modified the database name into which restored needs to be done in the script and that way it worked but it was not ready to take "INTO DBNAME' in the command itself.

Don't know what was wrong in that.

I had the same problem. In my case, there was an existing database with the same name in the machine (another version of the database)
The only way to solve the problem was to drop the old database.
But I have to admit that it is very weird, because you could probably want to create a second database based on the first one.

db2 "restore database xyz from Path_to_BackupDirectory into abc redirect generate script xyz.clp without rolling forward"

changing to :

db2 "restore database abc from Path_to_BackupDirectory redirect generate script xyz.clp"

then it will work.