Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Location
    Atlanta
    Posts
    2

    Unanswered: DB2 Restore Database Problem

    Command :

    Two ways >>>

    1.

    Restore database mser from d:\\db2bufromstageServer\\MSER.0 TAKEN AT 20020213123156 WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING


    Error :

    SQL2542N No match for database image file was found based on the source database alias and timestamp provoided

    2.

    Restore database mser user clan using thunderdome from d:\\db2bufromstageServer\\MSER.0 TAKEN AT 20020213123156 WITH 2 BUFFERS BUFFER 1024 WITHOUT PROMPTING

    Error :

    SQL2041N The buffer size parameter specfied is not valid . The buffer size must be specfied as 0 or be between 0 and 16384 inclusive

    thanks,
    sudhanshu
    Atlanta

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

    Re: DB2 Restore Database Problem

    Try using d:\db2bufromstageServer in the 'FROM' clause .

    Hope this helps

    Cheers

    Sathyaram

Posting Permissions

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