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

Subscribe

You can track all active APARs for this component.

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 number

    IC69506

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-28

  • Closed date

    2010-11-29

  • Last modified date

    2011-03-15

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager

Software version:

61A

Reference #:

IC69506

Modified date:

2011-03-15

Translate my page

Machine Translation

Content navigation