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 > add an existent db to new installation...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-22-10, 13:50
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Question add an existent db to new installation...

Hi,

Linux Opensuse 11.2
DB2 9.7 ESE (time evaluate).

I'm learn DB2 and executing some tests here...
Bellow is the steps I do:
- I Install db2 9.7 (db2_install method)
- created a new instance called "db2note1"
- created the SAMPLE database , executing the "db2sampl" using the default parameters.
- The sample database was created into the default directory : /home/db2note1/db2note1/NODE0000
- I drop the instance and das (db2idrop , dasdrop)
- I uninstall the db2 (db2_deinstall)
- I reinstall the db2 , following the same procedure before...
- Offcourse the DB SAMPLE don't appear. But I can see it using the command :
Code:
db2 list db directory at /home/db2note1
- I catalog the database manually , using the command:
Code:
db2 "catalog db SAMPLE AS SAMPLE AT NODE db2note1 WITH 'db catalogado depois'"
Opening the Control Center , the database don't appear.
Checking with the list db directory, I got this:
Code:
 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = SAMPLE
 Database name                        = SAMPLE
 Node name                            = DB2NOTE1
 Database release level               = d.00
 Comment                              = db catalogado depois
 Directory entry type                 = Remote
 Catalog database partition number    = -1
 Alternate server hostname            =
 Alternate server port number         =
They appear as "remote" type of database.
Well... My guess is, don't appear on the control center because this... but how solve ???? Is possible?
Reply With Quote
  #2 (permalink)  
Old 07-22-10, 14:10
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Your catalog statement was wrong. It should be:

Code:
db2 "catalog db SAMPLE AS SAMPLE ON /home/db2note1/db2note1/ WITH 'db catalogado depois'"
Andy
Reply With Quote
  #3 (permalink)  
Old 07-22-10, 14:20
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
Thank's Andy,

I read the manual for the catalog db syntax but this part "on ..." I don't notice... shame...

Thank again!
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