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

    Unhappy Unanswered: Error SQL1013N trying to access a database.

    Hi all:
    Here is my scenario:
    -Windows 2000
    -DB2 Personal Edition 8.1.3

    Here are steps I performed:

    1) I uninstall db2 then reinstall it. (I saved my old "c:\DB2" directory as "c:\db2bkp", cause I wanted to recover the database called "datges")
    2) My databases after step 1 were: TOOLSDB and SAMPLE
    3) I moved the database directory I want to recover to the c:\DB2.
    4) Form Command Centre I ran the command:
    "catalog db datges on c:"
    5) The "list db directory" shows me the new entry, but when i try to connect
    to datges (from CC or Command Centre), I get SQL1013N.

    Is there something I didn't do?...any idea/tip/guide?.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    what does

    db2 list db directory on C:\

    give you

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2004
    Posts
    65

    Unhappy

    Hi:
    That command doesn't show me the new entry:
    -----------------------------------------------------------
    Número de entradas en directorio = 2

    Entrada 1 de base de datos:
    Alias de base de datos = TOOLSDB
    Nombre de base de datos = TOOLSDB
    Directorio base datos = SQL00001
    Nivel release de base de datos = a.00
    Comentario =
    Tipo de entrada del directorio = Inicial
    Número partición base datos catálogo = 0
    Número de partición de base de datos = 0

    Entrada 2 de base de datos:
    Alias de base de datos = SAMPLE
    Nombre de base de datos = SAMPLE
    Directorio base datos = SQL00002
    Nivel release de base de datos = a.00
    Comentario =
    Tipo de entrada del directorio = Inicial
    Número partición base datos catálogo = 0
    Número de partición de base de datos = 0
    -----------------------------------------------------------

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Clearly datges is not present in the instance ...

    I guess you want to create the database

    db2 create database datges ...

    Refer command reference

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jul 2004
    Posts
    65
    I see.
    Im going to try with Create but I don't know if Create lets you create a DB from an existing DB.
    Tnx.

Posting Permissions

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