IBM Support

IT07505: ANR3497W REORGANIZATION REQUIRED MESSAGE NEEDS CLARIFICATION/UPDATING OF REQUIRED USER ACTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Problem Description:
    Exactly what to do in response to receiving an ANR3497W
    reorganization required message needs clarification.
    Understanding the return code in the message is key to taking
    the appropriate action. Recently the on line index
    reorganization, controlled by the server option ALLOWREORGINDEX,
    has been updated to specify the cleanup only option. The cleanup
    only option does not completely rebuild the indexes and does not
    exhibit deadlocks and excessive database log consumption. It is
    not anticipated that the cleanup only index reorganization will
    be disabled. The prior cleanup only reorganization on the
    BF_BITFILES_EXTENTS functionality is no longer required since
    the cleanup reorganization is now performed on all tables
    including BF_BITFILES_EXTENTS. Therefore the only anticipated
    reason code remaining is reason code 1 which relates to table
    reorganization. The required user action will be specific to
    table reorganization.
    

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 in levels 7.1.1.200 and 7.1.3. Note    *
    * that this is subject to change at the discretion of IBM.     *
    ****************************************************************
    

Problem conclusion

  • new message ID ANR3706W
    
    Reorganization is required on table <table name>, which is
    excluded from online reorganization.
    
    explanation
    
    The specified table was excluded from online reorganization by
    the DISABLEREORGTABLE server option.
    
    system action
    
    Server operation continues.
    
    user response
    
    A failure to reorganize tables when necessary can lead to
    database growth and server performance degradation over time. If
    you experience either of these symptoms, consider running an
    offline reorganization of the specified table. For instructions,
    see the section about offline table reorganization in Technote
    1452146:
    http://www.ibm.com/support/docview.wss?uid=swg21452146#offline_t
    able_reorg
    
    This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07505

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-03-04

  • Closed date

    2015-03-06

  • Last modified date

    2015-03-06

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71W PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"71A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
06 March 2015