IC88407: SLOW NODE IMPORT PERFORMANCE WITH V6 TIVOLI STORAGE MANAGER SERVERS

APAR status

• Closed as program error.

Error description

• V6 Tivoli Storage Manager server process to import node data is
  unexpected slow compared to the time it takes to export the same
  data.
  
  A server instrumentation trace for the import session thread
  (XiSessionThread) will show numbers like the following:
  
   Thread 19617 XiSessionThread parent=19616
  08:31:24.576-->08:46:50.923
     Session ID 11584 ADMIN (Server)
   Operation       Count  Tottime  Avgtime  Mintime  Maxtime
  InstTput  Total KB
   ---------------------------------------------------------------
  -------------
   DB2 Fetch Prep     95    0.026    0.000    0.000    0.002
   DB2 MFtch Prep      4    0.014    0.004    0.000    0.010
   DB2 Inser Prep      4    0.017    0.004    0.000    0.012
   DB2 Delet Prep      2    0.002    0.001    0.000    0.001
   DB2 Updat Prep      2    0.002    0.001    0.001    0.001
   DB2 Fetch Exec 193760  393.210    0.002    0.000    1.272
   DB2 MFtch Exec     13    0.001    0.000    0.000    0.000
   DB2 Inser Exec 193676   10.237    0.000    0.000    0.006
   DB2 Delet Exec 193616  388.691    0.002    0.000    0.021
   DB2 Updat Exec     46    0.007    0.000    0.000    0.001
   DB2 Fetch      193760    0.690    0.0000    0.000    0.000
   DB2 MFetch         25    0.001    0.000    0.000    0.000
   DB2 Commit         56    0.025    0.000    0.000    0.003
   DB2 Connect         3    0.036    0.012    0.011    0.012
   Acquire XLatch      1    0.000    0.000    0.000    0.000
   Thread Wait        59    0.227    0.004    0.000    0.158
   Unknown                133.155
   ---------------------------------------------------------------
  -------------
   Total                  926.347
  
  If you see about the same count numbers for "DB2 Delet Exec" and
  "DB2 Inser Exec", you are affected by this APAR.
  
    Tivoli Storage Manager Versions Affected: all V6
    Initial Impact: Medium
    Additional Keywords: ZZ61 ZZ62 ZZ63 export DBSTMT
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users of   *
  *                 the IMPORT NODE command.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in levels 6.2.6 and 6.3.4. 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.
  

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

• 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