Crash recovery for LUW on Linux

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
Join Bytes!
** Posted from http://www.teranews.com **

Mark A

Guest

n/a Posts

August 3rd, 2008
06:05 AM
#2

Re: Crash recovery for LUW on Linux

"Will Honea" <whonea@yahoo.comwrote in message
news:b39f8$48952d11$28049@news.teranews.com...

Quote:

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

Guest

n/a Posts

August 3rd, 2008
09:15 PM
#3

Re: Crash recovery for LUW on Linux

Mark A wrote:

Quote:

"Will Honea" <whonea@yahoo.comwrote in message
news:b39f8$48952d11$28049@news.teranews.com...

Quote:

>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
Join Bytes!
** Posted from http://www.teranews.com **

Mark A

Guest

n/a Posts

August 3rd, 2008
11:05 PM
#4

Re: Crash recovery for LUW on Linux

"Will Honea" <whonea@yahoo.comwrote in message
news:7dd77$48961f7e$15262@news.teranews.com...

Quote:

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

Guest

n/a Posts

August 4th, 2008
03:35 AM
#5

Re: Crash recovery for LUW on Linux

Mark A wrote:

Quote:

"Will Honea" <whonea@yahoo.comwrote in message
news:7dd77$48961f7e$15262@news.teranews.com...

Quote:

>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
Join Bytes!
** Posted from http://www.teranews.com **