Results 1 to 9 of 9
  1. #1
    Senior Member rore's Avatar
    Join Date
    Nov 2005
    Location
    Montreal, CA
    Posts
    637
    Thanks
    0
    Thanked 4 Times in 4 Posts

    Default v6.2.3 released - DB2 reorg fixes

    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.
    Last edited by rore; 08-04-2011 at 09:04 AM.

  2. #2
    Member
    Join Date
    Mar 2009
    Location
    Zagreb, Croatia
    Posts
    65
    Thanks
    0
    Thanked 7 Times in 3 Posts

    Default

    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.

  3. #3
    Member
    Join Date
    Feb 2008
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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.

  4. #4
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    Quote Originally Posted by rore View Post
    [URL]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.
    I was going to ask that question and ran across this post. Four days ago, I upgraded my Dev server to 6.3.4.0. The reorg options have been set for 4 days, but "Last Database Reorganization" is blank.

  5. #5
    Member
    Join Date
    Feb 2008
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I have a date in LAST_REORG field on my 16 TSM-servers. They are running version 6.3.3.7. I think that this field will be filled with a date, when all tables have been reorged once.

    You could check in your act-log and see if these msgno are comming:

    q act msgno=0293 begind=-30

    07/15/2013 04:16:48,ANR0293I Reorganization for table SERVER_CONNECT_INFO started.

    ...when all tables have been reorged, you will have a date in the field LAST_REORG....(Thats my guess)

    But reorg will not run on the tables, if reorg is not needed!

  6. #6
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    Ahhh that makes sense. I thought it would report any reorg attempt whether needed or not. I guess not. Thank you.

    I have seen mention of doing a reorg "once a month." But how is that done? If that referring to a reorg using DB2 commands outside of TSM? Because in TSM it is a daily value.

  7. #7
    Member
    Join Date
    Apr 2009
    Posts
    63
    Thanks
    0
    Thanked 10 Times in 10 Posts

    Default

    Quote Originally Posted by GregE View Post
    Ahhh that makes sense. I thought it would report any reorg attempt whether needed or not. I guess not. Thank you.

    I have seen mention of doing a reorg "once a month." But how is that done? If that referring to a reorg using DB2 commands outside of TSM? Because in TSM it is a daily value.
    You can do offline DB2 reorgs, but that's another topic entirely. Hopefully you'll never get to a point of needing that

    The TSM options just enable a window in which reorgs can occur. Not every table is hit every day...and some of the larger tables/indexes can take longer than a day. Generally if a table has been reorged, theres a timer where it won't be selected for reorg for another 20 days or something like that....maybe thats the "once a month" thing you've heard about.

    Here's the big kahuna reorg technote: http://www-01.ibm.com/support/docvie...id=swg21452146

    -rgg

  8. #8
    Senior Member
    Join Date
    Dec 2007
    Posts
    330
    Thanks
    1
    Thanked 19 Times in 19 Posts

    Default

    20 days after upgrade I got the re-org stuff
    tsm: TSM2>q db f=d

    Database Name: TSMDB1
    Total Size of File System (MB): 800,000
    Space Used by Database(MB): 270,272
    Free Space Available (MB): 529,599
    Total Pages: 15,886,352
    Usable Pages: 15,885,552
    Used Pages: 14,252,748
    Free Pages: 1,632,804
    Buffer Pool Hit Ratio: 99.2
    Total Buffer Requests: 1,778,975,956
    Sort Overflows: 0
    Package Cache Hit Ratio: 99.7
    Last Database Reorganization: 08/13/13 11:07:21
    Full Device Class Name: LTO4
    Number of Database Backup Streams: 1
    Incrementals Since Last Full: 0
    Last Complete Backup Date/Time: 08/13/13 05:00:20

  9. #9
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    Ok, mine reorg'ed the first time, 3 days after the upgrade.

Similar Threads

  1. Fixes and Patches
    By jaguar in forum TSM Server
    Replies: 1
    Last Post: 10-06-2008, 05:38 AM
  2. 5.5.1.1 just released
    By tenpin in forum TSM Server
    Replies: 0
    Last Post: 09-25-2008, 10:52 AM
  3. TSM 5.5 released
    By nezih in forum News & Announcements
    Replies: 15
    Last Post: 12-18-2007, 02:07 PM
  4. TDP for Domino (Linux) - installing fixes???
    By j0nnyhb in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 02-27-2007, 11:29 AM
  5. Has version 5.2 been released yet?
    By dbthomson in forum TSM Server
    Replies: 3
    Last Post: 06-07-2003, 11:13 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •