rebalancing containers

[hrishy]

Hi

I am reading a book called adavanced db2 dba certification guide by
Thomas Phan..this is the only db2 book available in india..There they
are talking about tablespace reblance when a new container is added to
a tablespace..I am not quite getting it..what does the DBA have to do
manually after her adds a container to a tablespace ..does he he have
to do soemthing manually for rebalance..what if i dont do any
reblalance ? will it effect performance

regards
Hrishy

[Anton Versteeg]

You don't have to do anything.
Just wait till the rebalance completes.

hrishy wrote:

Hi

I am reading a book called adavanced db2 dba certification guide by
Thomas Phan..this is the only db2 book available in india..There they
are talking about tablespace reblance when a new container is added to
a tablespace..I am not quite getting it..what does the DBA have to do
manually after her adds a container to a tablespace ..does he he have
to do soemthing manually for rebalance..what if i dont do any
reblalance ? will it effect performance

regards
Hrishy

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[hrishy]

Hi Anton

Thank you very very much..:-)for clearing my doubt

regards
Hrishy

Anton Versteeg <an************@nnll.ibm.com> wrote in message news:<cc**********@sp15en20.hursley.ibm.com>...

You don't have to do anything.
Just wait till the rebalance completes.

hrishy wrote:

Hi

I am reading a book called adavanced db2 dba certification guide by
Thomas Phan..this is the only db2 book available in india..There they
are talking about tablespace reblance when a new container is added to
a tablespace..I am not quite getting it..what does the DBA have to do
manually after her adds a container to a tablespace ..does he he have
to do soemthing manually for rebalance..what if i dont do any
reblalance ? will it effect performance

regards
Hrishy

[Joerg Ammann]

hr*****@yahoo.co.uk (hrishy) wrote in message news:<4e**************************@posting.google. com>...

Hi Anton

Thank you very very much..:-)for clearing my doubt

regards
Hrishy

Anton Versteeg <an************@nnll.ibm.com> wrote in message news:<cc**********@sp15en20.hursley.ibm.com>...

You don't have to do anything.
Just wait till the rebalance completes.

i think (but be not sure at the moment) that the DB has to be active
(either via ACTIVATE DATABASE or an open connection).
otherwise the rebalancing will not progress (as soon as there is a
connection the rebalancing will continue, nothing special to do for
the DBA)

joerg

[Chuck]

j_******@yahoo.com (Joerg Ammann) wrote in
news:a5**************************@posting.google.c om:

hr*****@yahoo.co.uk (hrishy) wrote in message
news:<4e**************************@posting.google. com>...

Hi Anton

Thank you very very much..:-)for clearing my doubt

regards
Hrishy

Anton Versteeg <an************@nnll.ibm.com> wrote in message
news:<cc**********@sp15en20.hursley.ibm.com>...

> You don't have to do anything.
> Just wait till the rebalance completes.
>

i think (but be not sure at the moment) that the DB has to be active
(either via ACTIVATE DATABASE or an open connection).
otherwise the rebalancing will not progress (as soon as there is a
connection the rebalancing will continue, nothing special to do for
the DBA)

joerg

Is there anything you can do to delay rebalancing until a slow period?

--
Chuck
Remove "_nospam" to reply by email

[Pierre Saint-Jacques]

Either you delay the adding of the container that causes the rebalancing
or, if running at V8, you can use the alter tablespace command with
begin new stripe set option. This will not cause rebalancing to start
but your tblspace structure may not be optimal.
HTH, Pierre.

Chuck wrote:

j_******@yahoo.com (Joerg Ammann) wrote in
news:a5**************************@posting.google.c om:

hr*****@yahoo.co.uk (hrishy) wrote in message
news:<4e**************************@posting.googl e.com>...

Hi Anton

Thank you very very much..:-)for clearing my doubt

regards
Hrishy

Anton Versteeg <an************@nnll.ibm.com> wrote in message
news:<cc**********@sp15en20.hursley.ibm.com>. ..

You don't have to do anything.
Just wait till the rebalance completes.

i think (but be not sure at the moment) that the DB has to be active
(either via ACTIVATE DATABASE or an open connection).
otherwise the rebalancing will not progress (as soon as there is a
connection the rebalancing will continue, nothing special to do for
the DBA)

joerg

Is there anything you can do to delay rebalancing until a slow period?

--
Pierre Saint-Jacques - Reply to: sesconsjunk at attglobaljunk dot com
Reconstruct address: Remove the two junk and replace at and dot by
their symbols.
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

[hrishy]

Hi Folks

How do i monitor and estimate the time remaining for the rebalance operation

regards
Hrishy

Pierre Saint-Jacques <se*****@attglobal.net> wrote in message news:<AB*********************@weber.videotron.net> ...

Either you delay the adding of the container that causes the rebalancing
or, if running at V8, you can use the alter tablespace command with
begin new stripe set option. This will not cause rebalancing to start
but your tblspace structure may not be optimal.
HTH, Pierre.

Chuck wrote:

j_******@yahoo.com (Joerg Ammann) wrote in
news:a5**************************@posting.google.c om:

hr*****@yahoo.co.uk (hrishy) wrote in message
news:<4e**************************@posting.googl e.com>...

Hi Anton

Thank you very very much..:-)for clearing my doubt

regards
Hrishy

Anton Versteeg <an************@nnll.ibm.com> wrote in message
news:<cc**********@sp15en20.hursley.ibm.com>. ..

>You don't have to do anything.
>Just wait till the rebalance completes.
>

i think (but be not sure at the moment) that the DB has to be active
(either via ACTIVATE DATABASE or an open connection).
otherwise the rebalancing will not progress (as soon as there is a
connection the rebalancing will continue, nothing special to do for
the DBA)

joerg

Is there anything you can do to delay rebalancing until a slow period?