The Home of C&P Software on the Web

Home
Blogs
About us
Why Choose Us?
What Are People saying?
OneClickAway PC Support
Professional Profile
Free Software here!!!
Contact Us
Privacy Notice
Useful Links
NLP

**In Progress** DB2 Move a DB from one OS to anther OS - second edition!!!

Ok in one of my previous post I had the export/import method to move a DB database from one OS to another.  Unfortunately if your DB is over 50GB which most decent DBs are now, this method will take a long time to process.  So I will now present a new improve migration method.  (Thanks to Keven Howie from IBM for helping with this!!!)

  • You need to catalog a “remote” database usign the tcpip method (see my previous post…)
  • connect to the local db
    • “db2 connect to myNewLocalDB”
  • create a wrapper
    • “”
  • create a server
    • “”
  • for all the tables in the DB
    • create an alias
      • “”
    • empty the table using a dummy file and a load from cursor from that file
      • “”
    • declare a cursor that select all the data from the “remote db table”
      • “”
    • use that cursor in a load from cursor (replace) into the local db table
      • “”