Crash recovery for LUW on Linux

[Will Honea]

Running Express-C 9.5 on Suse and I made the gross error of deciding to look
at Vista. Making a long story short, Vista managed to trash the partitions
on the drive containing Linux. I have managed to recover to partiton
containing the DB2 instance I want to resurrect but the root partition is a
lost cause so it's rebuild time - as far from Vista as I can get - but I
would really like to recovery the databases on that trashed drive if
feasible. Is there any way to import the instance info once I re-install
Linux and DB2?

I can recover all but a day's transactions from backups but it would save a
lot of hassle if I could import the apparently intact databases directly
from the old storage location. Any suggestions?

--
Will Honea
wh****@yahoo.com
** Posted from http://www.teranews.com **

[Mark A]

"Will Honea" <wh****@yahoo.comwrote in message
news:b3******************@news.teranews.com...

Running Express-C 9.5 on Suse and I made the gross error of deciding to
look
at Vista. Making a long story short, Vista managed to trash the
partitions
on the drive containing Linux. I have managed to recover to partiton
containing the DB2 instance I want to resurrect but the root partition is
a
lost cause so it's rebuild time - as far from Vista as I can get - but I
would really like to recovery the databases on that trashed drive if
feasible. Is there any way to import the instance info once I re-install
Linux and DB2?

I can recover all but a day's transactions from backups but it would save
a
lot of hassle if I could import the apparently intact databases directly
from the old storage location. Any suggestions?

--
Will Honea

You should be able reinstall DB2, create a new instance, and catalog the
existing database. You just need to know the path on which the database
resides to specify that path in the catalog database command.

[Will Honea]

Mark A wrote:

"Will Honea" <wh****@yahoo.comwrote in message
news:b3******************@news.teranews.com...

>Running Express-C 9.5 on Suse and I made the gross error of deciding to
look
at Vista. Making a long story short, Vista managed to trash the
partitions
on the drive containing Linux. I have managed to recover to partiton
containing the DB2 instance I want to resurrect but the root partition is
a
lost cause so it's rebuild time - as far from Vista as I can get - but I
would really like to recovery the databases on that trashed drive if
feasible. Is there any way to import the instance info once I re-install
Linux and DB2?

I can recover all but a day's transactions from backups but it would save
a
lot of hassle if I could import the apparently intact databases directly
from the old storage location. Any suggestions?

--
Will Honea

You should be able reinstall DB2, create a new instance, and catalog the
existing database. You just need to know the path on which the database
resides to specify that path in the catalog database command.

I was concerned about the database manager that served the "lost" instance.
Are you saying that the newly installed DB2 code should be able to pick up
an existing instance which consists of only the old instance directories?
I had hoped that to be the case but Murphy visits here often enough to make
me wary.

Will try this shortly - thanks.

--
Will Honea
wh****@yahoo.com
** Posted from http://www.teranews.com **

[Mark A]

"Will Honea" <wh****@yahoo.comwrote in message
news:7d******************@news.teranews.com...

I was concerned about the database manager that served the "lost"
instance.
Are you saying that the newly installed DB2 code should be able to pick up
an existing instance which consists of only the old instance directories?
I had hoped that to be the case but Murphy visits here often enough to
make
me wary.

Will try this shortly - thanks.
--
Will Honea

You cannot (or at least should not) try to recover the instance after you
reinstall DB2. If you DB2 install is hosed, your instance is also hosed.

You should reinstall DB2, create a new instance, and then catalog the
database (which should still be there) to the new instance. You need to
specify the path of the database in the catalog statement (I am assuming you
will at the Command Reference manual for details).

[Will Honea]

Mark A wrote:

"Will Honea" <wh****@yahoo.comwrote in message
news:7d******************@news.teranews.com...

>I was concerned about the database manager that served the "lost"
instance.
Are you saying that the newly installed DB2 code should be able to pick
up an existing instance which consists of only the old instance
directories? I had hoped that to be the case but Murphy visits here often
enough to make
me wary.

Will try this shortly - thanks.
--
Will Honea

You cannot (or at least should not) try to recover the instance after you
reinstall DB2. If you DB2 install is hosed, your instance is also hosed.

You should reinstall DB2, create a new instance, and then catalog the
database (which should still be there) to the new instance. You need to
specify the path of the database in the catalog statement (I am assuming
you will at the Command Reference manual for details).

OK, that should keep me out of trouble. Thanks for the help - it even gets
me to the point of RTFM.

--
Will Honea
wh****@yahoo.com
** Posted from http://www.teranews.com **