• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

backup & restore of db2 database

 
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
How big are the files? You could put them on CD, transfer them through FTP, etc. Essentially, they are just like any other file.
 
srinivas anigani
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
As you have asked that you want to restore your db2 database of different version on from Windows XP to Windows 2000 then you must need to know the guides mentioned here - http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ha.doc/doc/c0005960.html?lang=en


If you want to know more about DB2 Backup and recovery then you must also read this - DB2 Basics: Backups of Data and Recovery
 
reply
    Bookmark Topic Watch Topic
  • New Topic