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

Online Reorgs and logging

P: n/a
I'm working on implementing online reorgs(V8 FP11 on AIX), and am
seeing a lot of transaction logging during the reorgs. My problem is
that the archive logs are filling up the active log path before they
can all be archived off to TSM. I don't have unlimited disk space. Is
there any way I can estimate the total log space that will be used by
an online reorg so I can allocate the right amount of space? I'm also
looking into speeding up archiving to TSM, but wanted to approach this
from both perspectives.

Thanks,
Ember Crooks
IBM Certified Advanced Database Administrator
-DB2 UDB V8.1 for Linux, UNIX, and Windows

Oct 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
At what stage you are getting this error. If that is the stage of
INDEX rebuild use this
formula

Log space required for index rebuilding during the reorganization:
2 * (10500 + ((number of index pages / extent size) * 110) +
(number of index pages * 45) +
((number of index pages / 16000) * 64) )

cheers...
Shashi Mannepalli

da**********@gmail.com wrote:
I'm working on implementing online reorgs(V8 FP11 on AIX), and am
seeing a lot of transaction logging during the reorgs. My problem is
that the archive logs are filling up the active log path before they
can all be archived off to TSM. I don't have unlimited disk space. Is
there any way I can estimate the total log space that will be used by
an online reorg so I can allocate the right amount of space? I'm also
looking into speeding up archiving to TSM, but wanted to approach this
from both perspectives.

Thanks,
Ember Crooks
IBM Certified Advanced Database Administrator
-DB2 UDB V8.1 for Linux, UNIX, and Windows
Oct 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.