IT07535: SLOW STARTUP PERFORMANCE OF THE 7.1 SERVER ON WINDOWS

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