v6.2.3 released - DB2 reorg fixes

[rore]

https://www-304.ibm.com/support/docv...id=swg27021363

Do you have experiences to share regarding the DB2 reorg?. Hopefully this will improve DB performance and slow down the growing rate. Planning to update.

Edit: I never saw the field 'Last Database Reorganization' populated on the q db f=d. Do you have a value on that field on your TSM 6.2 servers? This fixpack should resolve that.

[terlisimo]

Hello,

I've had some issues with DB2 reorgs slowing down server operations with large deduplicated storage pools.

It seems to me that reclamation/migration of deduplicated volumes makes a lot of changes to AF_AGGREGATED_BITFILES so a reorg would be triggered while process is still running... and this would really slow down everything, including backup operations. I did manual reorgs and runstats until now, these two options should prevent reorg from running in inappropriate time.

[nenifled]

I upgraded 4 instances (Running on one AIX) to 6.2.3 yesterday - and for the first time we start getting, these in the act-log:

08/25/2011 06:43:12 ANR0293I Reorganization for table ADMIN_EMAILS started.
08/25/2011 06:48:12 ANR0294I Reorganization for table ADMIN_EMAILS ended.
08/25/2011 06:58:13 ANR0293I Reorganization for table ACTIVITY_LOG started.
08/25/2011 07:03:13 ANR0294I Reorganization for table ACTIVITY_LOG ended.


In total, eight tables were reorganized in three hours.

Does anyone know how many tables need to be reoganized in total? My guess is 265, since I get 265 tables from this command:

list tables for schema tsmdb1

Did I understand it correct, that all tables (265??) need to be reorganized before the index-reorganization begins? I dont have any ANR0317I in my act-log.