Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Arrow Unanswered: Add container to DMS and rebalance of data

    Does anybody know how one can speculate that how long will it take to rebalance the data if one or more containers are added to exisiting DMS tablespace?

    UDB V8 FP 3 on windows

    dollar

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    I am thinking that this might depend on the volume of data in the table which has the container addition. You could export the data and load it to a new tablespace with additional containers without impacting your users. Ensure the table is in the same schema and name it slightly different, like _new. Then rename the table when you're done loading. For an MPP db this can be done in parallel and can be fairly optimized, again, depending on the volume of data.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Add container to DMS and rebalance of data

    If you have time, read

    http://publib.boulder.ibm.com/infoce...n/c0008087.htm

    this topic may not give a definitive answer on time, but very clearly explains how rebalancing happens ...

    cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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