Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2017
    Posts
    1

    Unanswered: Table partition :- Merging of two partition

    I have two similar table (a_his and a_arc ) both are partitioned by range in same coulum,
    a_his have 1 month partition and a_arc have 3 month partition
    now i want to detach 3 partition from a_his and attach them to a_arc , also at same time i want to merge 3 partition to one partition (without using import/load)
    e.g

    a_his has 3 partition which we have to detach
    1-1-2017 to 1-2-2017
    1-2-2017 to 1-3-2017
    1-3-2017 to 1-4-2017

    a_arc has partition from

    1-1-1016 to 1-4-2016
    1-4-1016 to 1-7-2016
    1-7-1016 to 1-10-2016
    1-10-1016 to 1-1-2017

    now we want to add 3 partition of a_his to a_arc as one partition (1-1-2017 to 1-4-2017) , data in partition are huge so we dont want to use load/import ,
    do we have merge or later range command in db2

    thanks

    Lalit

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    There are no such commands in DB2 for LUW.
    Regards,
    Mark.

Posting Permissions

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