IC92109: COPY ACTIVEDATA COMMAND IS SLOW FOR COMPLEX GROUPED OBJECTS

IBM Tivoli Storage Manager V6.3 Fix Pack 5 (6.3.5.000) Server Downloads

APAR status

• Closed as program error.

Error description

• The Tivoli Storage manager COPY ACTIVEDATA command might look
  hung when processing complex grouped objects.
  
  Complex grouped objects typically do exist for systemstate
  objects or for various virtual environment megablock versions,
  so if you do systemstate backups or back up virtual environments
  you are exposed to this APAR.
  
  A trace with traceflag DBCLI will show excessive usage and
  processing of result sets for:
  12:52:27.409 ﾎ1036ﾚﾎtbcli.cﾚﾎ6622ﾚﾎBuildStmtﾚ:EXITING rc=0 with
  stmt
  'SELECT NODEID,FSID,LEADERID,GROUPTYPE,MEMBERID,MEMBEROBJTYPE
  FROM
  "TSMDB1"."GROUP_LEADERS"  WHERE (NODEID=? AND FSID=? AND
  MEMBERID=?) ORDER
  BY LEADERID, GROUPTYPE FOR READ ONLY OPTIMIZE FOR 10 ROWS WITH
  UR --1036'.
  
  In addition, a server instrumentation trace will show the
  majority of time spent in
  DB2 MFtch Exec for the AfCopyActiveDataThread:
  
   Thread 13530 AfCopyActiveDataThread parent=13528
  14:59:29.668-->15:19:33.636
   Operation       Count  Tottime  Avgtime  Mintime  Maxtime
  InstTput Total KB
   ---------------------------------------------------------------
  -------------
   DB2 MFtch Prep 147711   18.550    0.000    0.000    0.001
   DB2 Fetch Exec  98474    9.785    0.000    0.000    0.001
   DB2 MFtch Exec 8715018  969.237    0.000    0.000    0.361
   DB2 Fetch       98474    0.787    0.000    0.000    0.000
   DB2 MFetch     15017404   69.441    0.000    0.000    0.001
   Unknown                136.165
   ---------------------------------------------------------------
  -------------
   Total                 1203.968
  
  
    Tivoli Storage Manager Versions Affected: all V6
    Initial Impact: Medium
    Additional Keywords: TSM active inactive state
  

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

Problem conclusion

• This problem was fixed.
  

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