I'd say the odds are against you. Issues you will have to address
include, but are not limited to:
1. On the source system; were there multiple databases? If so, which one
do you want to restore?
2. Was the Database open when the file backups were taken? If so; a
recovery from files is almost guraanteed to fail.
3. did your database use SMS, DMS, or a mix for storage?
4. Is any documentation available for the original database?
If you have all of the files; perhaps you have an entire system backup.
If so; you could restore the entire system, boot it, start UDB then
generate a regular backup which can be restored to a different system.
I've successfully (once) used files to recover a single SMS table but
never tried to do an entire database. This should be attempted only as a
last resort when you've exhausted all other possibilities, have no
option other than to recover the database, and have management willing
to "spend" an inordinate amount of time, effort, and money on a task
that has a very very limited chance of success.
Good Luck!
Phil Sherman
db2inst2 wrote:
Hi all,
I am in a situation to restore a DB just from the Files (No Backup
Image) I have got all the files of NODE0000 directory.
Platform WIN 2000 pro And db2 8.1 fp 2
Is it possible to restore the DB.
How do i do it?
Thanks