Hi all:

- DB2 ESE V.8.1 FP 4a.
- Windows 2000

Is there a way to recover (or restore) a DB when I only have the
physical directory where it resides, and the containers it uses.?
i.e. (I have this DB from a previous DB2 installation in my PC, and have
no a recent backup).

- Directory c:\db2\NODE000\SQL00007
- Containers: c:\db2\con_d01 and c:\db2\con_d02

Any guide.?
Please...
tnx

Try issuing the following command :

db2 catalog database <dbname> on C:\

I guess you should be able to connect then

Cheers
Sathyaram

The command: "catalog database datges on c:" ran succesfully,
-------------------------------------------------------------------------
DB20000I El mandato CATALOG DATABASE ha finalizado satisfactoriamente.
DB21056W Los cambios en el directorio no serán efectivos hasta que la
antememoria del directorio no se renueve.
-------------------------------------------------------------------------
but I can't connect to the database.
the listing from "list db directory" doesn't match to the one from "list db directory on c:"
Any idea...?

Tnx.

Another info:
I have noticed that the new entry showed by "list db directory", has a
"-1" in Partition Number (see the last line), but all the other Databases
have this value in "0".

Alias de base de datos = DATGES
Nombre de base de datos = DATGES
Unidad base de datos = C:\DB2
Nivel release de base de datos = a.00
Comentario =
Tipo de entrada del directorio = Indirecto
Número partición base datos catálogo = -1