Results 1 to 4 of 4

Thread: db2 rebalance

  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: db2 rebalance

    I have a DMS tablespace with 11 containers, each about 4.2 GB. The last time I added a container the rebalance took about 10 hours to complete. The tablespace pagesize is 4096. Could anyone suggest methods to speed up the rebalance?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Not right off hand, but why do you have so many containers? It seems unlikely that you have enough I/O channel bandwidth on your disk controller(s) to exploit that many containers. If you just need more space (and cannot extend the existing containers) you can add a new stripe set so that no rebalancing will be necessary.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Do you think adding a new stripe set can affect read / prefetching or write performance?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by BELLO4KA View Post
    Do you think adding a new stripe set can affect read / prefetching or write performance?
    Yes, it could theorectically, but sometimes necessary in 24x7 apps if that is the only way to allocate more space (if current containers cannot be enlarged). More likely to affect a data warehouse doing table scans than an OLTP system.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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