Container Operations Through a Roll Forward.

[Pierre Saint-Jacques]

I'm wondering how DB2 UDB treats this situation.
Recent Backup Available.
Alter DMSTLSP ... ADD container ---- Presume this causes a rebalancing of the containers.
Time flows on.
Restore Tablespace from Backup
Roll Forward thru the alter DMSTBLSP

When the alter command is met in the logs:
A) Will there be a rebalancing - I think yes.
B) How is it done? :
a) Asynchronously and other trans. not affecting the DMSTBLSP will be processed?
b) Does the RF "stop", rebalances, and then resumes ???

Thanks for any clarification, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

[Keith]

Pierre Saint-Jacques wrote:

I'm wondering how DB2 UDB treats this situation.
Recent Backup Available.
Alter DMSTLSP ... ADD container ---- Presume this causes a rebalancing of the containers. Time flows on.
Restore Tablespace from Backup
Roll Forward thru the alter DMSTBLSP

When the alter command is met in the logs:
A) Will there be a rebalancing - I think yes.
Yes
B) How is it done? :
a) Asynchronously and other trans. not affecting the DMSTBLSP will be processed? b) Does the RF "stop", rebalances, and then resumes ???

B is correct -- well, sort of. RF is not really "stopped."
Rebalance first then continue with RF -- At this point rebalance really
a part of RF since alter tablespace is logged.
BTW, if you perform a redirected restore, however, you can use "ignore
rollforward container operations" option in "set tablespace
containers...." command to avoid rebancing during rollforward.

HTH

Keith Ponnapalli
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for
Linux, UNIX, and Windows
INFORMIX Certified Database Administrator

Thanks for any clarification, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

[Pierre Saint-Jacques]

Thanks a binch for the speed of reply.
Guess what? I needed the answer tomorrow as I'm working with people to whom
I want to give back the answer.
Merci, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Keith" <pr***@yahoo.com> a écrit dans le message de
news:11**********************@f14g2000cwb.googlegr oups.com...

Pierre Saint-Jacques wrote:

I'm wondering how DB2 UDB treats this situation.
Recent Backup Available.
Alter DMSTLSP ... ADD container ---- Presume this causes a

rebalancing of the containers.

Time flows on.
Restore Tablespace from Backup
Roll Forward thru the alter DMSTBLSP

When the alter command is met in the logs:
A) Will there be a rebalancing - I think yes.

Yes

B) How is it done? :
a) Asynchronously and other trans. not affecting the DMSTBLSP

will be processed?

b) Does the RF "stop", rebalances, and then resumes ???

B is correct -- well, sort of. RF is not really "stopped."
Rebalance first then continue with RF -- At this point rebalance really
a part of RF since alter tablespace is logged.
BTW, if you perform a redirected restore, however, you can use "ignore
rollforward container operations" option in "set tablespace
containers...." command to avoid rebancing during rollforward.

HTH

Keith Ponnapalli
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for
Linux, UNIX, and Windows
INFORMIX Certified Database Administrator

Thanks for any clarification, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515