Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    65

    Red face Unanswered: How to recover/restore a DB from C:\DB2 Directory.?

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Try issuing the following command :

    db2 catalog database <dbname> on C:\

    I guess you should be able to connect then

    Cheers
    Sathyaram

  3. #3
    Join Date
    Jul 2004
    Posts
    65

    Unhappy

    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.

  4. #4
    Join Date
    Jul 2004
    Posts
    65
    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •