Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2013
    Posts
    5

    Question Migrate from DB2 7.1.0 AIX to new Linux DB2 installation

    Which procedure is the best to acomplish this ?

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    From V7 to V10?
    db2look to punch the DDL. Do not use the old tablespace config. Go for automatic storage so you'll have to do some editing.
    db2move to unload & load the tables using workflles.

    sequence:
    Code:
    OLD - punch db2look 
    DBA - edit & split db2look file 
    OLD - db2move export data
    DBA - copy files to new server
    NEW - import 1st half of db2look (create table/index, do not include FK constraints here)
    NEW - db2move load 
    NEW - import 2nd half of db2look (from FK constraints down)
    OLD - power off
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •