Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: rebalance tbspace

    hi all

    db2 V 8 on aix
    i have dms tablespaces with 25 containers size of 50 gb (tablespacesize)
    there is no much data it would be of abt 10 gb
    when i droping the containers its going into rebalancing
    is there a way to avoid it
    regds
    Paul

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    When you drop 1 or more containers it goes into rebalance (gotta move the data out first, right?)
    When you shrink the sizes of all containers no rebalance tales place. Mind the HWM when you determine the new size.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    If you drop all containers that need to be dropped at once, using a single ALTER TABLESPACE command, there will be only one rebalance operation.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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