IT11357: ONE-TIME CLIENT ACTIONS CAUSE LONG RUNNING SELECT TO THE EVENT TABLE

7.1.4.000-TIV-TSMSRV-WIN
7.1.4.000-TIV-TSMSRV-SolarisSPARC
7.1.4.000-TIV-TSMSRV-Linuxx86_64
7.1.4.000-TIV-TSMSRV-Linuxs390x
7.1.4.000-TIV-TSMSRV-Linuxppc64
7.1.4.000-TIV-TSMSRV-HP-UX
7.1.4.000-TIV-TSMSRV-AIX
IBM Spectrum Protect Server V7.1 Fix Pack 4 (7.1.4.000) Downloads

APAR status

• Closed as program error.

Error description

• For schedules which have PERUNITS=ONETIME and
  DURUNITS=INDEFINITE,
  the corresponding event records will have deadline date of
  2069-10-11.
  Even when the event retention limit is exceeded, one-time
  schedule events are not deleted from the event table.
  When a process or an administrator executes a select from the
  event table and scans what are the events associated with a
  node, the operation can take a significant time.
  The farther away in time the one-time client action was ran in
  the past, the longer the select command can take.
  The 'query event' server command is not affected.
  
  This behaviour was observed to impact the Tivoli Storage
  Manager - Data Protection for VMware GUI.
  When, in that interface, the user attempts to display the
  scheduled backups, the following error seen is due to the above
  problem :
  GVM0005W. The connection with the Tivoli Storage Manager server
  has timed out.
  
  Tivoli Storage Manager Versions Affected: All supported server
  version on all platforms
  
  Initial Impact: Medium
  
  Additional Keywords: zztsm delay long time-out GVM0005W
  

Local fix

• Contact support to correct the problem.
  

Problem summary

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

• R71A PSY

     UP

• R71H PSY

     UP

• R71L PSY

     UP

• R71S PSY

     UP

• R71W PSY

     UP