Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007
    Posts
    11

    Unanswered: Avaid Tablespace rebalancing

    Hi,

    I am working on DB2 Version 8.1 Fixpack 15. My O/S is Solaris.

    Whenever we add or delete a container the Tablespace will got to rebalancing state? Is there any way to avoid this?

    Nambi

  2. #2
    Join Date
    Sep 2006
    Posts
    97
    REbalancing a simple concet If you add/delete a container. It's going take some time to evenlt spreding the data/moving all the data into one contaner.

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Why do you want to avoid rebalancing?

    What you could consider in your case is to use an SMS or automatic storage table space and just add more storage to your logical volume/file system. Using DMS and then not wanting rebalancing defeats slightly the purpose of DMS.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I think you can also avoid rebalancing if you BEGIN NEW STRIPE SET prior to adding new the container(s). See the description of ALTER TABLESPACE for details.
    ---
    "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
  •