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 > db2 backup file

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-22-10, 12:32
Pryach Pryach is offline
Registered User
 
Join Date: Jun 2010
Posts: 9
db2 backup file

We have a server at my work that uses a db2 database. There's some data in there that I would like to be able to access and run reports against. However, I don't know anything about db2 and I would be hesitant to mess around with the work server.

Every day the db2 server makes a backup of the database, we copy this to tape and take it offsite. Is there any way I can take this db2 backup file and convert it so I can import it into a MySQL DB (which I'm more familiar with and already have reporting tools I can modify)?

The db2 version is 9.1. The filename of the backup is:
DBNAME.0.DB2.NODE0000.CATN0000.20100613001501.001

Again, I know very little about db2, so I have no idea if these backup files are written in some kind of proprietary format, I'm just looking for a jumping off point.
Reply With Quote
  #2 (permalink)  
Old 06-22-10, 14:09
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
As long as you know SQL you can use db2.
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #3 (permalink)  
Old 06-22-10, 15:11
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by Pryach View Post
Is there any way I can take this db2 backup file and convert it so I can import it into a MySQL DB (which I'm more familiar with and already have reporting tools I can modify)?
No, there isn't.

There is, however, a freely available version of DB2 that you can install on your own machine - DB2 Express-C. You will then be able to restore the work backup to it, provided it has been made on the same platform (e.g. Windows).
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