IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    IT11357

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-22

  • Closed date

    2015-10-05

  • Last modified date

    2015-10-05

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT11357

Modified date: 05 October 2015