By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,967 Members | 815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,967 IT Pros & Developers. It's quick & easy.

Question about table space rebalance

P: n/a
I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not insert new
data into tables who belong to a rebalanced table space. Is the any
way to avoid this?

Thanks

James

Jun 6 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On 6 Cze, 07:30, James <huyu...@gmail.comwrote:
I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not insert new
data into tables who belong to a rebalanced table space. Is the any
way to avoid this?

Thanks

James
James,

Rebalancing is not restricting users from modifying data in the
rebalanced tablespace, but it can excessively load your system.
Excessively in extreme cases means that nobody can work on the system
because of 100% IO wait, or poor response time (eg. rebalancing on
peak load with undersized storage).
But you can add new containers with new stripe set, which means no
reballancing will occur:

ALTER TABLESPACE space1 BEGIN NEW STRIPE SET (FILE 'file1'' 4 G)

Of course, the natural way of adding a new space is just extending
existing containers.

-- Artur Wronski

Jun 6 '07 #2

P: n/a
On Jun 6, 2:41 pm, Artur <artur.wron...@gmail.comwrote:
On 6 Cze, 07:30, James <huyu...@gmail.comwrote:
I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not insert new
data into tables who belong to a rebalanced table space. Is the any
way to avoid this?
Thanks
James

James,

Rebalancing is not restricting users from modifying data in the
rebalanced tablespace, but it can excessively load your system.
Excessively in extreme cases means that nobody can work on the system
because of 100% IO wait, or poor response time (eg. rebalancing on
peak load with undersized storage).

But you can add new containers with new stripe set, which means no
reballancing will occur:

ALTER TABLESPACE space1 BEGIN NEW STRIPE SET (FILE 'file1'' 4 G)

Of course, the natural way of adding a new space is just extending
existing containers.

-- Artur Wronski
After I added a new container and this table space was rebalancing, I
found that the total page increased, but free page of this table space
was still zero. When would new value of free page be shown, after
rebalance?

Thanks.

Jun 6 '07 #3

P: n/a
On Jun 6, 11:41 am, Artur <artur.wron...@gmail.comwrote:
On 6 Cze, 07:30, James <huyu...@gmail.comwrote:
I am not sure whether users can access data or insert new data into
tables who belong to a rebalanced table space after new containers are
added? (DB2 version is 8.x) What I know is user can not insert new
data into tables who belong to a rebalanced table space. Is the any
way to avoid this?
Thanks
James

James,

Rebalancing is not restricting users from modifying data in the
rebalanced tablespace, but it can excessively load your system.
Excessively in extreme cases means that nobody can work on the system
because of 100% IO wait, or poor response time (eg. rebalancing on
peak load with undersized storage).

But you can add new containers with new stripe set, which means no
reballancing will occur:

ALTER TABLESPACE space1 BEGIN NEW STRIPE SET (FILE 'file1'' 4 G)

Of course, the natural way of adding a new space is just extending
existing containers.

-- Artur Wronski
Artur,

If we add new containers with new strip set, all the new data would go
in that stripe set and will not be spread across the other containers.
Moreover, there is no way we can distribute the data once a new stripe
set is defined as adding one more container would add on the new
stripe set. So, the entire motive of distribution data goes for a
toss. So we cannot rebalance the tablespace. Correct me if I am
wrong.!

Saurabh

Jun 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.