If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Migrate from DB2 7.1.0 AIX to new Linux DB2 installation

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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 ?
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 732
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On