IC95301: NEED TO DISABLE REORGANIZATION FOR CERTAIN TABLES ON VERY BUSY TIVOLI STORAGE MANAGER SERVERS

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads
IBM Tivoli Storage Manager V7.1 Fix Pack 1 (7.1.1.000) Server Downloads

APAR status

• Closed as program error.

Error description

• Problem Description:
  Currently, reorganization can be enabled or disabled for all
  tables and/or their indices. The capability to have
  reorganization enabled for most tables, but disabled for
  certain large tables is needed. This need has been
  specifically observed on very busy servers running
  deduplication. Some customers have experienced very long time
  periods to run table reorganizations which prevent
  reorganization from running on other tables. Other customers
  have experienced the server halting when the active log
  becomes full while index reorganization is running. Others
  have experienced server applications being canceled while
  reorganization is running to resolve deadlocks (message
  ANR1880W being issued). IC82352 introduced an INDEX REORG
  CLEANUP PAGES ALL reorganization on BF_BITFILE_EXTENTS which
  might cause the server to halt because of the active log
  becoming full. Disabling reorganization on very large tables
  will allow reorganization to run on the other tables while the
  server is operating, prevents server outages from occurring,
  and prevents server applications from being canceled because
  of reorganization activity.
  
  Tivoli Storage Manager Versions Affected:
  All 6.X versions of Tivoli Storage Manager server
  
  Initial Impact:
  Medium
  
  Additional Keywords:
  zz63 TSM table index reorganization IC81261 IC82352
  IC83725 IC90985 IC91964 ANR1880W
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem                                      *
  *                 is currently projected to be fixed           *
  *                 levels 6.3.5 and 7.1.1. Note                 *
  *                 that this is                                 *
  *                 subject to change at the discretion          *
  *                 of IBM.                                      *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  
  Affected platforms: AIX, HP-UX, Solaris, Linux, and Windows.
  
  These new messages are introduced with this APAR:
  
  ANR3496W An invalid value, <option value>, is specified for
  option <option name>. The reason code is <reason code>.
  
  ANR3497W Reorganization is required on table <table name>. The
  reason code is <reason code>.
  
  ANR3498W One-time setting of the server reorganization options
  is performed.
  
  These new server options are introduced with this APAR:
  DISABLEREORGTABLE, DISABLEREORGINDEX, DISABLEREORGCLEANUPINDEX.
  
  See Technote 1452146, section APAR IC95301, for complete
  information on this APAR:
  http://www.ibm.com/support/docview.wss?uid=swg21452146
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R63A PSY

     UP

• R63H PSY

     UP

• R63L PSY

     UP

• R63S PSY

     UP

• R63W PSY

     UP

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP