Steps to restores a instance.

georgipa · #1 (**permalink**) 12-07-09, 08:27

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.

ARWinner · #2 (**permalink**) 12-07-09, 08:41

If you have backups of your databases, you can just create a new instance and restore the database backups.

Andy

sathyaram_s · #3 (**permalink**) 12-07-09, 08:47

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 ...

georgipa · #4 (**permalink**) 12-07-09, 09:54

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.

sathyaram_s · #5 (**permalink**) 12-07-09, 10:13

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 ????

sathyaram_s · #6 (**permalink**) 12-07-09, 10:13

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 ????

Internet Services

Web Development

Digital Marketing

Consumer Tech