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]

Re: rebalancing containers

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

hrishy wrote:[color=blue]
> 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[/color]

--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands

[hrishy]

Re: rebalancing containers

Hi Anton

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

regards
Hrishy

Anton Versteeg <anton_versteeg @nnll.ibm.com> wrote in message news:<ccjgut$rh 8$1@sp15en20.hu rsley.ibm.com>. ..[color=blue]
> You don't have to do anything.
> Just wait till the rebalance completes.
>
> hrishy wrote:[color=green]
> > 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[/color][/color]

[Joerg Ammann]

Re: rebalancing containers

hrishys@yahoo.c o.uk (hrishy) wrote in message news:<4ef2a838. 0407081808.246e 7696@posting.go ogle.com>...[color=blue]
> Hi Anton
>
> Thank you very very much..:-)for clearing my doubt
>
> regards
> Hrishy
>
> Anton Versteeg <anton_versteeg @nnll.ibm.com> wrote in message news:<ccjgut$rh 8$1@sp15en20.hu rsley.ibm.com>. ..[color=green]
> > You don't have to do anything.
> > Just wait till the rebalance completes.
> >[/color][/color]

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]

Re: rebalancing containers

j_ammann@yahoo. com (Joerg Ammann) wrote in
news:a5fbda48.0 407140026.5e916 91d@posting.goo gle.com:
[color=blue]
> hrishys@yahoo.c o.uk (hrishy) wrote in message
> news:<4ef2a838. 0407081808.246e 7696@posting.go ogle.com>...[color=green]
>> Hi Anton
>>
>> Thank you very very much..:-)for clearing my doubt
>>
>> regards
>> Hrishy
>>
>> Anton Versteeg <anton_versteeg @nnll.ibm.com> wrote in message
>> news:<ccjgut$rh 8$1@sp15en20.hu rsley.ibm.com>. ..[color=darkred]
>> > You don't have to do anything.
>> > Just wait till the rebalance completes.
>> >[/color][/color]
>
> 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
>[/color]

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

--
Chuck
Remove "_nospam" to reply by email

[Pierre Saint-Jacques]

Re: rebalancing containers

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:[color=blue]
> j_ammann@yahoo. com (Joerg Ammann) wrote in
> news:a5fbda48.0 407140026.5e916 91d@posting.goo gle.com:
>
>[color=green]
>>hrishys@yahoo .co.uk (hrishy) wrote in message
>>news:<4ef2a83 8.0407081808.24 6e7696@posting. google.com>...
>>[color=darkred]
>>>Hi Anton
>>>
>>>Thank you very very much..:-)for clearing my doubt
>>>
>>>regards
>>>Hrishy
>>>
>>>Anton Versteeg <anton_versteeg @nnll.ibm.com> wrote in message
>>>news:<ccjgut $rh8$1@sp15en20 .hursley.ibm.co m>...
>>>
>>>>You don't have to do anything.
>>>>Just wait till the rebalance completes.
>>>>[/color]
>>
>>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
>>[/color]
>
>
> Is there anything you can do to delay rebalancing until a slow period?
>[/color]

--
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]

Re: rebalancing containers

Hi Folks

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

regards
Hrishy

Pierre Saint-Jacques <sescons@attglo bal.net> wrote in message news:<ABhKc.439 34$mU1.1629985@ weber.videotron .net>...[color=blue]
> 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:[color=green]
> > j_ammann@yahoo. com (Joerg Ammann) wrote in
> > news:a5fbda48.0 407140026.5e916 91d@posting.goo gle.com:
> >
> >[color=darkred]
> >>hrishys@yahoo .co.uk (hrishy) wrote in message
> >>news:<4ef2a83 8.0407081808.24 6e7696@posting. google.com>...
> >>
> >>>Hi Anton
> >>>
> >>>Thank you very very much..:-)for clearing my doubt
> >>>
> >>>regards
> >>>Hrishy
> >>>
> >>>Anton Versteeg <anton_versteeg @nnll.ibm.com> wrote in message
> >>>news:<ccjgut $rh8$1@sp15en20 .hursley.ibm.co m>...
> >>>
> >>>>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
> >>[/color]
> >
> >
> > Is there anything you can do to delay rebalancing until a slow period?
> >[/color][/color]