IC69506: AUTOMATIC INDEX REORGS OF THE TIVOLI STORAGE MANAGER DATABASE DOES NOT OCCUR

APAR status

• Closed as program error.

Error description

• The TSM Server will invoke DB2 to perform reorgs of database
  tables, however, this functionality is not available for online
  reorg for the table indexes. By default, the DB2 policy
  definitions do not allow for automatic, online reorgs of
  database table indexes.
  
  
  
  Platforms affected:
  All TSM 6.1.x and 6.2.x Servers
  
  
  
  
  
  Additional Keywords:
  reorganization reorgck db2reorgchk reorg indexes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Consult Tivoli Storage Manager Server        *
  *                 Technote 1452146, titled "Tivoli Storage     *
  *                 Manager V6 Server Database Size, Database    *
  *                 Reorganization, and Performance              *
  *                 Considerations" at                           *
  *                 http://www.ibm.com/support/                  *
  *                 docview.wss?uid=swg21452146                  *
  *                 for additional details.                      *
  *                                                              *
  *                 Apply fixing level when available. This      *
  *                 problem is currently projected to be         *
  *                 fixed in levels 6.1.5.0 and 6.2.3.0. Note    *
  *                 that this is subject to change at the        *
  *                 discretion of IBM.                           *
  ****************************************************************
  *  Table reorganization was also fixed to properly detect and
  *  reorganize all candidate tables.
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux, and
  Windows.
  

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

• R61A PSN

     UP

• R61H PSN

     UP

• R61L PSN

     UP

• R61S PSN

     UP

• R61W PSN

     UP

• R62A PSN

     UP

• R62H PSN

     UP

• R62L PSN

     UP

• R62S PSN

     UP

• R62W PSN

     UP