You can’t leave some parts empty but if you are on Db2 12 you
can insert new partitions in the middle so and basically accomplish
Sent from my iPhone
> On Jun 7, 2020, at 6:57 PM, Michael Hannan
<[login to unmask email]> wrote:
> In Reply to Leila Hosseini:
> Table space has 151 parts and last ten parts are so crowded
while first ten parts are almost empty.
> I am wondering to know is there any keyword which says to Db2
after REORG REBALANCE of 10 parts ,just populate data in first 8
parts and leave two parts Empty?
> Or any thoughts which may help us to shift Data into the first
> Not sure what "crowded" means. Not a Db2 term. Crowding could
sound good in some ways, depending on what it means.
> I would not get too obsessed with "Balance". There is no law
that says partitions must be balanced. The main point is whether a
partition has got too large for you to be able to manage. Rebalance
is to redistribute some rows between a set of partitions when some
parts are deemed too big for one reason or another.
> So you have 10 fixed numbers that are distributing rows
currently among 10 partitions. That does not need to stay in a 1 to
1 mapping. The partition limit key could be changed to be more than
just that 1 column, with Reorg required to implement it. So 1 part
could have more than 1 of those 10 fixed values, or a single one of
those fixed values could be spread in more than 1 partition.
> You might need a smart process to calculate what the new
partition range keys should be. Obviously all partitions with a
change key range will have to be reorg repopulated, or whatever
goes into reorg Pending.
> Try it all out of a small test table first. I am not sure how
many changes to partitioning can be achieved with the one
> Michael Hannan,
> DB2 Application Performance Specialist
> Site Links: View post online View mailing list online Start
new thread via email Unsubscribe from this mailing list Manage your
> This email has been sent to: [login to unmask email]
> Try BCV5, the BCV5 Masking Tool, & XDM a rapid
Refresh/Clone/TDM Suite for Db2 z & distributed.
> DBARS -Audit,record,& block Db2 accesses to sensitive data
real-time, NO audit trace or log required
> Use of this email content is governed by the terms of service