Online Reorgs and logging

[daiesy.ember]

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

[Shashi Mannepalli]

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