IC74025: HIGH TM LOCK WAIT CAN CAUSE API APPLICATION SLOW PERFORMANCE.

APAR status

• Closed as program error.

Error description

• An application using Tivoli Storage Manager api client sending
  data to a Tivoli Storage Manager Server,
  can experience slower than expected performance, when there are
  multiple sessions opened/closed
  at high frequency.
  
  
  
  L2/customer diagnostics;
  
  Run a server instrumentation trace and check the Content Manager
  session.
  
  Thread 33026 psSessionThread parent=37
  15:37:29.500-->15:50:30.862
    Session ID 3356 ECMEMAILPROD (ICMRM)
  Operation       Count  Tottime  Avgtime  Mintime  Maxtime
  InstTput  Total KB
  ----------------------------------------------------------------
  ------------
  Network Recv     4349  305.895    0.070    0.000  154.509
  47.6     14570
  Network Send     3228    0.062    0.000    0.000    0.002
  4480.0       281
  DB2 Fetch Prep   1006    0.975    0.001    0.000    0.020
  DB2 MFtch Prep      4    0.009    0.002    0.000    0.004
  DB2 Inser Prep      3    0.007    0.003    0.001    0.004
  DB2 Updat Prep    809    0.644    0.001    0.000    0.060
  DB2 Fetch Exec  21584    1.735    0.000    0.000    0.025
  DB2 MFtch Exec   1610    2.520    0.002    0.000    0.022
  DB2 Inser Exec   1005    0.461    0.000    0.000    0.028
  DB2 Updat Exec   1811    0.950    0.001    0.000    0.027
  DB2 Fetch       21584    0.108    0.000    0.000    0.000
  DB2 MFetch       2817    0.026    0.000    0.000    0.007
  DB2 Commit       1614    5.904    0.004    0.000    0.115
  DB2 Reg Prep      201    0.044    0.000    0.000    0.002
  DB2 Reg Exec      201    0.020    0.000    0.000    0.001
  DB2 Reg Fetch     201    0.000    0.000    0.000    0.000
  DB2 Connect         4    0.021    0.005    0.003    0.007
  Tm Lock Wait     3794  452.369    0.119    0.000    2.323
  Acquire Latch       2    0.000    0.000    0.000    0.000
  Acquire XLatch      1    0.000    0.000    0.000    0.000
  Sleep               7    7.000    1.000    1.000    1.000
  Thread Wait      1434    0.192    0.000    0.000    0.004
  Unknown                  2.407
  ----------------------------------------------------------------
  ------------
  Total                  781.361
  19.0     14852
  
  
  Tm Lock Wait is higher than expected and is the main indicator.
  
  Tivoli Storage Manager Versions Affected:
  
  Tivoli Storage Manager Server 6.1 and 6.2 for all platforms
  
  Initial Impact:
  
  Low
  
  Additional Keywords:
  
  zz61 zz62 65285 cm8 cm performance perf api sessions
  

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

Problem conclusion

• The described problem has been resolved.
  

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

• 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