IBM Support

IT07535: SLOW STARTUP PERFORMANCE OF THE 7.1 SERVER ON WINDOWS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • It is possible to see the server startup take significantly
    longer to start up than is expected.  This is due to DB2 APAR
    IT07434.  This is experienced when the DB2 DB_MEM_THRESH value
    is set to 100 and there are large bufferpools.  This only is
    seen on Windows that have newly installed 7.1.0.000.  Upgrading
    to 7.1.0.00 or higher from an existing level does not show this
    behavior since the DB_MEM_THRESH value is not changed to 100.
    This does not affect normal server operations, only startup.
    
    Tivoli Storage Manager Versions Affected: 7.1
    
    Customer/L2 Diagnostics: The following commands can be run on a
    DB2 command line to verify the setting for DB_MEM_THRESH.
    
    db2 connect to TSMDB1
    db2 get db cfg for TSMDB1 | find "DB_MEM_THRESH"
    
    Output should be similar to the following.
    
    C:\Program Files\Tivoli\TSM\db2\BIN>db2 get db cfg for TSMDB1 |
    find
    "DB_MEM_THRESH"
     Database memory threshold               (DB_MEM_THRESH) = 100
    
    If you see DB_MEM_THRESH set to 100, then this APAR
    
    Initial Impact: Medium
    
    Additional Keywords: startup start mem perf slow start up
    performance
    

Local fix

  • The DB_MEM_THRESH value can be changed to the previous default
    of 10 by issuing the following DB2 commands.
    
    db2 connect to TSMDB1
    db2 update db cfg for TSMDB1 using DB_MEM_THRESH 10
    
    The output should look similar to the following.
    
    C:\Program Files\Tivoli\TSM\db2\BIN>db2 update db cfg for TSMDB1
    using
    DB_MEM_THRESH 10
    DB20000I  The UPDATE DATABASE CONFIGURATION command completed
    successfully.
    

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

Problem conclusion

  • This problem was fixed.
    Affected platforms:  Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT07535

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-03-09

  • Closed date

    2015-04-14

  • Last modified date

    2015-04-14

  • 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

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 71W

Reference #: IT07535

Modified date: 14 April 2015