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

db2 inplace reorg and log space

P: n/a
I changed my classic reorgs to inplace reorg on my siebel database
last weekend and ran into the log space getting full issue . This is
one of the command on my script :

reorg table SIEBEL.ASSET index SIEBEL.XASSET1 inplace;

I have two questions :

1. On the classic reorg, i know the indexes get rebuild. When I issue
the above command, will any of the indexes get rebuild ? If none of
the indexes are rebuild, then is the ASSET table be reorged in the
sequence of the fragmented XASSET1 index ?

2. Should I reorg all the indexes right after the reorg table is done
or can i do it in parrallel ?

3. If I have a huge table, does the reorg commit the changes often or
does 1 commit after the whole reorg. I ran out of all the Primary and
Sec. log. So am wondering how the logging in INPLACE reorg work

I will appreciate if anybody can give me some input to these
Thanks

Roger

Jun 19 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.