Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: Steps to restores a instance.

    Hi Gurus,

    I have filesystem and this it is had broken, within filesystem I have an instance with several data bases. What is the procedure to recover the instance?

    Thank you for you help.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If you have backups of your databases, you can just create a new instance and restore the database backups.

    Andy

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    As far as I know, the only supported recovery option is to use a db2 database backup and associated transaction logs.

    But, if the 'broken' filesystem had all the database files, then restoring the filesystem (assuming that the repair has failed) to a previous backup may restore the data upto the backup time. You will loose all data changes since ... Even if you restore the filesystem, there is chance your database connection fails .. In this case, IBM will be able to reset the database to a normal state, but unlikely to gurantee the consistency of data ...
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Thank you for your contributions, I have a backup of all database. ¿What is the procedure for restore all databases?.
    ¿the command restore since where will be execute?

    greetings.

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Please search for terms backup , restore , rollforward in the information centre

    DB2 Database for Linux, UNIX, and Windows

    Also, the developerworks should give information :
    IBM developerWorks : Information Management

    There is not enough information in your post to give specific suggestions
    What is the backup characteristics ? - Database, tablespace ?? full, incremental ??? online,offline ?
    Where does the backup go ? disk, tsm, another vendor device ???
    where do the archive logs reside ??? disk, tsm, another vendor device ????
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Please search for terms backup , restore , rollforward in the information centre

    DB2 Database for Linux, UNIX, and Windows

    Also, the developerworks should give information :
    IBM developerWorks : Information Management

    There is not enough information in your post to give specific suggestions
    What is the backup characteristics ? - Database, tablespace ?? full, incremental ??? online,offline ?
    Where does the backup go ? disk, tsm, another vendor device ???
    where do the archive logs reside ??? disk, tsm, another vendor device ????
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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