470,826 Members | 1,916 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,826 developers. It's quick & easy.

Online Reorgs and logging

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
1 2683
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.

Similar topics

3 posts views Thread by datapro01 | last post: by
4 posts views Thread by GB | last post: by
16 posts views Thread by andy.standley | last post: by
2 posts views Thread by datapro01 | last post: by
1 post views Thread by David Beardsley | last post: by
3 posts views Thread by rdudejr | last post: by
reply views Thread by mmcsbell | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.