Results 1 to 5 of 5

Thread: DB2 Restore

  1. #1
    Join Date
    Dec 2003
    Posts
    4

    Unanswered: DB2 Restore

    Hi,
    I tried to restore a database from a customer in AIX with teh restore command. "RESTORE DATABASE BLABLA from /PATH" and my system always says that the databasename and the timestamp does not match.

    any ideas ??

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: DB2 Restore

    Hola lurchi.

    Hablas español?
    Debes darnos más información. Por ejemplo, que versión de OS y Db2 tiene y el código de error que te apacere.

    Saludos,
    Abel.

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    are there more that one backup in that directory, if there is you need to specify the timestamp so it know which one to get. You should specify the timestamp anyway, you can get it from the list history command

  4. #4
    Join Date
    Dec 2003
    Posts
    4
    Originally posted by quigleyd
    are there more that one backup in that directory, if there is you need to specify the timestamp so it know which one to get. You should specify the timestamp anyway, you can get it from the list history command
    Hi and thanks I will try it again.

  5. #5
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Command

    The restore database command is like this

    restore database database name from <path> taken at <timestamp>

    Here the timestamp is the important part.

    What is suggest is you use the control centre to do the same.

    Nitin

Posting Permissions

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