Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    5

    Unanswered: DB2 Range Partition deletions/truncations

    Hi people,

    I have tables that are making use of the Range Partition. We have 5 range partitions 1 - 5 representing each work day (Mon - Fri)

    Now the load process after each day, should would by truncating the relevant partition and then inserting the fresh data. So Monday's load should truncate partition 1 and reload the fresh Mondays sales data.

    I am unclear on how the truncate would work - i cannot see a command on the Internet - all I can see is the attach/detach partitions which does not seem to work with the above truncate/load approach. Anyone have any suggestions?

    Thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    detach - load replace - attach
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2007
    Posts
    5
    Quote Originally Posted by n_i
    detach - load replace - attach
    Does each partition needs to be in its own separate tablespace ? or can they be in the same one ? What are the pro's/con's of each ??

    thanks :-)

Posting Permissions

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