Should online reorgs create Active Logs?

[Former Member]

Hello all,

We are implementing SAP on DB2 V9.1 and are running in to a problem when trying to perform the online reorg. We are seeing an extremely large number of logs being written to the Active Logs in DB2. This eventually fills all our log space and DB2 stops until we can free up more space for logs.

Has anyone else done online reorgs with DB2 V9.1? Have you seen a large amount of logs being written durring the reorgs?

Thanks

Andy

[Former Member]

Thomas,

Thanks for the update. I have also been working with Susanne from SAP support on this issue.

I do see in my job output the lines you referred to and indeed they say that the number of logs written is = 0.

However, we are still seeing a large amount of logging in our DB2 system around the reorgs. I reorged only 34 tablespaces in one of our systems and it drove the DB2 active logs from 4% utilized to 16% utilized. We have 3 active logs; each of them being 1000 cylinders.

I am at a loss as to why the logs grow so much when the only thing happening on the system is reorgs. No users are on this system other than myself.

Thanks

Andy

[thomas_vogt]

Andy,

According to the IBM docs LOG YES is not allowed when using SHRLEVEL CHANGE. I have tested in a V9 as well (upload + execution and direct start using SPs), the output shows

..

DSNU386I 317 13:48:23.18 DSNURLGD - LOG PHASE STATISTICS. NUMBER OF ITERATIONS = 1, NUMBER OF LOG RECORDS = 0

..

Regards,

Thomas