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.
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