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

manual rebalancing

P: n/a
Hi all,

I have certain questions for which I am not able to get any answers.

1. Can I manually rebalance a tablespace? The problem is that I have a
18 hr live production environment. If a tablespace gets full during
this time, I can use "BEGIN NEW STRIPE SET" option to add a container
without rebalance and continue my transactions. At the end of the day,
I want to rebalance the data. So is there any way to manually
rebalance the tablespace.

2. Can I read already committed data?. I have certain records which
are getting updated. So there is a IX lock on those records. Can I
read the column's previous value?

Please help me out in solving this.

Saurabh

Mar 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
spider007 wrote:
2. Can I read already committed data?.
You can _only_ read committed data, unless you use the UR isolation level
(UR = uncommitted read).
I have certain records which
are getting updated. So there is a IX lock on those records. Can I
read the column's previous value?
No. You will have to maintain the before image yourself somehow yourself.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 22 '07 #2

P: n/a
Ian
spider007 wrote:
1. Can I manually rebalance a tablespace? The problem is that I have a
18 hr live production environment. If a tablespace gets full during
this time, I can use "BEGIN NEW STRIPE SET" option to add a container
without rebalance and continue my transactions. At the end of the day,
I want to rebalance the data. So is there any way to manually
rebalance the tablespace.

No. Once you've started a new stripe set, the old one is frozen.

However, why don't you just extend your existing containers (i.e.,
"alter tablespace ... extend ... ")?

That saves you from having to rebalance at all.
Mar 23 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.