Migrate DB2 8.1 Tables to DB2 9.5 with partitioning

thereapman · #1 (**permalink**) 12-12-08, 06:29

Hello!

I want to migrate an ERP-Database to DB2 v9.5 and want to use the new "Table Partitioning" feature of 9.5 for some Tables.

Is it possible to use partitioning without recreating these tables from scratch?
When not: Is there a Solution to do this with less handwork.

Greets,
Markus

SuperKuper · #2 (**permalink**) 02-03-09, 23:59

Assuming that you are talking about RANGE partitioning, I do not believe it is possible to alter tables to make them range partitioned. However, there may be a way around this. You could create a new empty range-partitioned table and then ATTACH to it your existing table as one of the ranges.

dr_te_z · #3 (**permalink**) 02-04-09, 03:33

You'd probably want new/extra tablespaces to enable rollin/rollout so recreating tables can not be avoided.

Just punch your DDL with db2look
edit the "db2look.out" (nice name ain't it?) to add your new stuff
split the "db2look.out" in 2 parts:
- the upper part which contains the create table & indices
- the lower part which conains all the foreign key contraints

execute the upper part of your db2look.out in you new database
do a "load from cursor" for each table
execute the lower part of your db2Look.out in you new database

and here is your new database with the new features enabeled!
Sound familiar? It's basically what "db2move" does.