reduce large container to small container with same size

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

infodbms@gmail.com - 29 Oct 2007 21:19 GMT

Hello,

I have a big DMS tablespace with large container span across 3
filesystem on DB2 v8.2/AIX5.2. Each container is of different size on
each of the filesystem. Looking for some suggestion/advice on how to
remove large container and create new one with the same size as the
rest of them without DB2 doing rebalancing?

Thanks,
Samy

Reply to this Message

Roger - 31 Oct 2007 03:12 GMT

On Oct 29, 3:19 pm, infod...@gmail.com wrote:

> Hello,
>
[quoted text clipped - 6 lines]
> Thanks,
> Sam

Don't think you can avoid rebalancing in this case.

Roger

Reply to this Message