The Home of C&P Software on the Web

**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
  • • “”