Recovery after Crash

Burkhard,

The e:\db2 is your database path.

When I had this type of problem, I was able to drop the DB2 instance
(db2idrop db2) and then create it again (db2icrt db2).

Dropping the instance does not affect any databases under the instance.
However, you will have to catalog the database entry again after you
re-create the DB2 instance: db2 catalog database xxxxx as yyyyyy on e:

"Burkhard Schultheis" <schultheis@tde-online.de> wrote in message
news:bvlsgo$to8fm$1@ID-100086.news.uni-berlin.de...[color=blue]
> I had a crash on my w2k machine. I installed w2k in a new directory.
> Then I installed DB2 V8.1 in the same directory as before. Now DB2 is
> not able to start. It tells me that the environment is inconsistent,
> because the instance is not valid. DB2INSTANCE is DB2, and the old
> instance is e:\db2. DB2 is installed on drive E:, too.
>
> What can I do to get the old data (no, I don't have a backup of all
> data, only of the most important table).
>
> Regards,
> --
> Burkhard Schultheis
> Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
> Email: Join Bytes!
> Phone: +49-7245-9287-21, Fax: +49-7245-9287-30[/color]

change diaglevel to 4
try to restart DB2
see db2diag.log

DB2 LIST DATABASE DIRECTORY [ON drive]
(e: in your case, you should see the db's that were there before.)

check
DBM CFG dftdbpath

those could help
re-catalog nodes
re-catalog databases

PM

"Burkhard Schultheis" <schultheis@tde-online.de> a écrit dans le message de
news:bvlsgo$to8fm$1@ID-100086.news.uni-berlin.de...[color=blue]
> I had a crash on my w2k machine. I installed w2k in a new directory.
> Then I installed DB2 V8.1 in the same directory as before. Now DB2 is
> not able to start. It tells me that the environment is inconsistent,
> because the instance is not valid. DB2INSTANCE is DB2, and the old
> instance is e:\db2. DB2 is installed on drive E:, too.
>
> What can I do to get the old data (no, I don't have a backup of all
> data, only of the most important table).
>
> Regards,
> --
> Burkhard Schultheis
> Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
> Email: Join Bytes!
> Phone: +49-7245-9287-21, Fax: +49-7245-9287-30[/color]

Burkhard Schultheis schrieb:[color=blue]
> I had a crash on my w2k machine. I installed w2k in a new directory.
> Then I installed DB2 V8.1 in the same directory as before. Now DB2 is
> not able to start. It tells me that the environment is inconsistent,
> because the instance is not valid. DB2INSTANCE is DB2, and the old
> instance is e:\db2. DB2 is installed on drive E:, too.
>
> What can I do to get the old data (no, I don't have a backup of all
> data, only of the most important table).
>[/color]

After some thinking overnight I solved the problem like I did it on AIX
some times ago: I deinstalled DB2, renamed DB2 to DB2.old, installed DB2
with all fixpaks, created the sample database (that created the instance
DB2), created an empty database with the correct name, dropped the
sample database, stopped db2, renamed DB2.old to DB2, started DB2, and
all was OK.

Then I made an offline backup :-)

Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: Join Bytes!
Phone: +49-7245-9287-21, Fax: +49-7245-9287-30