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 > Using a old database in new db2 installation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-24-11, 06:58
caracol caracol is offline
Registered User
 
Join Date: Sep 2011
Posts: 2
Using a old database in new db2 installation

Hi all,
I was using a DB2 trial installation during 90 days on Windows. With this installation I created a database (CARS-CLIENTS) and stored a big amount of data on it (I didn't make any backup :-(.
Now my trial licence is over.
I uninstall the previous DB2 version and installed a new on DB2 Express.

The question is, HOW CAN I RETRIEVE THE DATA FROM THE OLD DB2 installation (it is in the old DB2 directorate of the previous DB2 installation)?

I would be VERY GRATEFULL if any one could help me.
Best regards,
Reply With Quote
  #2 (permalink)  
Old 09-24-11, 14:17
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Reply With Quote
  #3 (permalink)  
Old 09-24-11, 14:46
caracol caracol is offline
Registered User
 
Join Date: Sep 2011
Posts: 2
Is this?

Is this what you suggested?:

I'd try copying the files to the target system using exactly the same directory structure as in the old system. Assuming you have installed DB2 and created a new instance using all the same parameters as before, issuing CATALOG DB whatever ON C: might just work.

...I tried it but it didnīt worked...
Reply With Quote
  #4 (permalink)  
Old 09-24-11, 16:09
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
What exactly did you copy and what error did you receive when you tried connecting to the db after copying directories/files?
Reply With Quote
  #5 (permalink)  
Old 09-25-11, 09:04
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
I failed to realize that you uninstalled and reinstalled on the same server.

Did you reinstall db2 on the same drive? I suppose the instance called "DB2" got created during installation. Check the local db directory using:
db2 list db directory on <drive>

where <drive> is the drive where you originally created your db


If found, catalog the db in the system db directory and then try connecting to it.
Reply With Quote
Reply

Tags
db2, new installation, old database, restore

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