Results 1 to 3 of 3
08-04-2011, 08:48 AM #1
- Join Date
- Nov 2005
- Montreal, CA
- Thanked 4 Times in 4 Posts
v6.2.3 released - DB2 reorg fixes
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.
Last edited by rore; 08-04-2011 at 09:04 AM.
08-13-2011, 07:38 AM #2
- Join Date
- Mar 2009
- Zagreb, Croatia
- Thanked 6 Times in 3 Posts
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.
08-25-2011, 05:25 AM #3
- Join Date
- Feb 2008
- Thanked 0 Times in 0 Posts
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.
By jaguar in forum TSM ServerReplies: 1Last Post: 10-06-2008, 05:38 AM
By tenpin in forum TSM ServerReplies: 0Last Post: 09-25-2008, 10:52 AM
By nezih in forum News & AnnouncementsReplies: 15Last Post: 12-18-2007, 02:07 PM
By j0nnyhb in forum TDP/Application Layer BackupReplies: 1Last Post: 02-27-2007, 11:29 AM
By dbthomson in forum TSM ServerReplies: 3Last Post: 06-07-2003, 11:13 PM