If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Error SQL1013N trying to access a database.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-30-04, 13:14
francis01 francis01 is offline
Registered User
 
Join Date: Jul 2004
Posts: 65
Unhappy 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.
Reply With Quote
  #2 (permalink)  
Old 08-31-04, 03:20
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
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.
Reply With Quote
  #3 (permalink)  
Old 08-31-04, 09:21
francis01 francis01 is offline
Registered User
 
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
-----------------------------------------------------------
Reply With Quote
  #4 (permalink)  
Old 08-31-04, 09:49
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
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.
Reply With Quote
  #5 (permalink)  
Old 08-31-04, 10:33
francis01 francis01 is offline
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On