aspose file tools*
The moose likes JDBC and the fly likes backup  & restore of db2 database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "backup  & restore of db2 database" Watch "backup  & restore of db2 database" New topic
Author

backup & restore of db2 database

srinivas anigani
Greenhorn

Joined: Aug 28, 2005
Posts: 7
Hi,
I want to take backup of db2 database v 7.2.2 residing on windows XP and restore it onto db2 v 8.1 on windows 2000.
I have created the tables on windows 2000 machine.How to move data from
XP to 2000 machine.

Thanks in advance
anigani
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30938
    
158

How big are the files? You could put them on CD, transfer them through FTP, etc. Essentially, they are just like any other file.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
srinivas anigani
Greenhorn

Joined: Aug 28, 2005
Posts: 7
thanks.
I took database backup on XP and tried to restore it on win 2000,but I am not able to restore it.
Can u give me the procedure to do this.Also how to use Generate DDL.
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30938
    
158

Originally posted by srinivas anigani:
thanks.
I took database backup on XP and tried to restore it on win 2000,but I am not able to restore it.

What error message do you get?

Can u give me the procedure to do this.Also how to use Generate DDL.

Take a look at the db2 infocenter. It will walk you through the process.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: backup & restore of db2 database