IBM Support

IC82352: AUTOMATIC REORGS OF TABLE INDEXES NOT TRIGGERED FOR ALL REORG CONDITIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager Server does not currently take into
    consideration the number of empty leaf pages and/or deleted
    record ids when determining if reorg is required for a table
    index.  This can affect the performance of the TSM Server as the
    amount of time required to scan the table indexes is increased
    as a result of the deleted/empty records.
    
    Platforms affected:
    All TSM 6.x Servers
    
    Customer/L2 Diagnostics:
    The following DB2 'reorgchk' command can be issued to determine
    if a reorg of the table indexes is required:
    
       db2 reorgchk current statistics on table all
    
    Affected users will see from this output that the reorg of a
    table index is required due to the results for formula F7
    (deleted record ids) and/or formula F8 (empty leaf pages) being
    outside of the specified boundaries.
    
    Additional Keywords:
    reorganization reorgck db2reorgchk indices
    

Local fix

  • Contact support for assistance in performing required
    reorg/runstats operations against the affected table index.
    

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 6.2.5 and 6.3.3. 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.
    
    
    
    If the output of Formula 7 or Formula 8 is true when the DB2
    REORGCHK command is run on the BF_BITFILE_EXTENTS table, this
    APAR initiates an index reorganization of type CLEANUP ONLY
    ALL for the table. The settings of the ALLOWREORGINDEX,
    REORGBEGINTIME, and REORGDURATION server options are not
    considered when starting this type of reorganization.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82352

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    62H

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-29

  • Closed date

    2013-09-24

  • Last modified date

    2013-09-24

  • 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

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W 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":"62H","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
24 September 2013