Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002

    Unanswered: UDB DB2 V9 fixpack4 AUTOMATIC STORAGE

    I have a UDB DB2 V9 fixpack4 database. It has automatic storage enabled for its tablespaces. Each tablespace has two containers one conatiner per file system.It is using two file systems. Unfortunately 90% of the data is going to one file system and 10% to other file system.

    What can i do to redistribute my tablespace data across these two file systems equally.

    PS: I think DB was created with one automatic storage path initially and then second storage was added.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    i don't see a rebalance command
    best would be unload table-drop table-reload table
    have you defined different strip set - otherwise ts are auto rebalanced
    see :
    Rebalancing DMS containers
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Jan 2003
    Provided Answers: 1
    koganti, I think one storage path was defined at create database time and new storage path was added later, because DB2 if using automatic storage automatically balance disk space according to defined storage paths. If new storage path is added, then DB2 will not rebalance disk storage, because this would greatly influence performance. DB2 ensures that a rebalance will never take place as part of an auto-resize.

    I think (not 100% sure) the rebalance will be in place if using backup/restore. This can be easily tested. Make a backup and restore database to test computer.

    If I remember correctly "rebalancing DMS container" does not work with automatic storage.

  4. #4
    Join Date
    Jan 2009
    Zoetermeer, Holland
    Quote Originally Posted by grofaty
    If I remember correctly "rebalancing DMS container" does not work with automatic storage.
    Correct: The "rebalance" is triggered by adding/dropping conainers using conventional DMS table spaces.

Posting Permissions

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