IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IC95301

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-27

  • Closed date

    2013-12-12

  • Last modified date

    2013-12-12

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 63A

Reference #: IC95301

Modified date: 12 December 2013