Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2008
    Posts
    1

    Unanswered: Migrate DB2 8.1 Tables to DB2 9.5 with partitioning

    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

  2. #2
    Join Date
    Apr 2008
    Posts
    51
    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.
    db2topgun.com

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    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.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by dr_te_z
    Sound familiar? It's basically what "db2move" does.
    No, it is not what db2move does.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by n_i
    No, it is not what db2move does.
    Okay, but I was inspired by "db2move".

Posting Permissions

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