IBM Support

IC73978: DEFAULTS AUTO_REORG ON AND ALLOWREORGTABLE YES SHOULD BE MUTUALLY EXCLUSIVE AND LAST DB REORG DATE NEED TO IN Q DB OUTPUT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A Tivoli Storage Manager DB2 database should not have its
    AUTO_REORG value set ON when the Tivoli Storage Manager server
    option ALLOWREORGTABLE value is set to YES. However these are
    currently the default setting for a 6.x server. The Tivoli
    Storage Manager server code needs to establish the proper
    defaults for these options. Full documentation on what these
    options do, why the given default was chosen and the
    reasons/effects for changing them need to be provided.
    Additionally the "Last Database Reorganization:" field of query
    db f=d output needs to be populated with the reorg activity date
    when TSM intiates the reorg (as done when ALLOWREORGTABLEYES
    is used).
    

Local fix

  • Turn off AUTO_REORG using the following commands run as the DB2
    instance owner:
        db2 connect to tsmdb1
        db2 update db cfg for TSMDB1 using AUTO_REORG OFF
    Recycle the Tivoli Storage Manager server (which will stop and
    restart DB2).
    

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.1.5.0 and 6.2.3.0. Note that    *
    *                 this is subject to change at the             *
    *                 discretion of IBM.                           *
    ****************************************************************
    *
    

Problem conclusion

  • The problem has been corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC73978

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    62A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-19

  • Closed date

    2011-02-21

  • Last modified date

    2011-02-21

  • 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 PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

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

Document Information

Modified date:
21 February 2011