Results 1 to 12 of 12
  1. #1
    Join Date
    May 2010
    Posts
    88

    Unanswered: URGENT-please help for restore

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What DB2 version and OS are you using?

    Andy

  3. #3
    Join Date
    May 2010
    Posts
    88
    db2 V9.1 FP7 and OS AIX 5.3

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Does the abc database exist?

    Andy

  5. #5
    Join Date
    Jan 2010
    Posts
    335
    You want to generate a script???
    Try without "without rolling forward". It's not needed for script generation.

  6. #6
    Join Date
    May 2010
    Posts
    88
    abc database exist...
    specifying without rolling forward as its coldbackup image

  7. #7
    Join Date
    May 2010
    Posts
    88
    tried without "without rolling forward" also, same error

  8. #8
    Join Date
    May 2010
    Posts
    88
    source database and target database are on same server but different instance and file system, so need to generate script

  9. #9
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try adding these clauses: "REPLACE EXISTING" and "WITHOUT PROMPTING".

    Andy

  10. #10
    Join Date
    May 2010
    Posts
    88
    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.

  11. #11
    Join Date
    Mar 2006
    Location
    Bogota, Colombia
    Posts
    21
    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.
    AngocA

  12. #12
    Join Date
    Nov 2011
    Location
    Shen Zhen,China
    Posts
    37
    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.

Posting Permissions

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