IBM Support

IT03125: CS DELETE EVENT THREAD HOLDS CS.UNIVERSE LOCK LONGER THAN NECESSARY WHEN EVENTS TABLE IS LARGE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Observed errors will resemble:
    
    05/06/14 01:00:23 ANR2705E cscmdsch.c(374) Scheduler lock
    failed: -1.
    05/06/14 01:00:23 ANR2599W The central scheduler is unable to
    obtain a
    required lock and will retry in 60 seconds.
    
    Inspection of threads and transactions at the time of the error
    will show that events deletion thread is holding CS.Universe and
    that we are waiting on DB2 translation to complete.
    
    slot -> 1260:
    LockDesc: Type=53001(cs universe), NameSpace=0,
    SummMode=sixLock, Key=''
      Holder: (csutil.c:496 Thread 281) Tsn=0:16394704, Mode=sixLock
      Waiter: (csutil.c:496 Thread 281) Tsn=0:16429519, Mode=sLock
      Waiter: (csutil.c:496 Thread 504657) Tsn=0:16433363,
    Mode=ixLock
      Waiter: (csutil.c:496 Thread 504658) Tsn=0:16433461,
    Mode=ixLock
      Waiter: (csutil.c:496 Thread 277) Tsn=0:16433547, Mode=sixLock
    
    Tsn=0:16394704, Resurrected=False, InFlight=True,
    Distributed=False, Persistent=True, Addr 12edb4d08
      Start ThreadId=504469, Timestamp=05/28/14 00:04:55,
    Creator=csmgr.c(2222)
      Last known in use by ThreadId=504469
      Participants=2, summaryVote=ReadOnly
      EndInFlight False, endThreadId 0, tmidx 0 0, processBatchCount
    0, mustAbort False.
        Participant DB: voteReceived=False, ackReceived=False
          DB: Txn 112bc81e8, ReadOnly(YES), connP=131efaba8,
    applHandle=15656, openTbls=3:
          DB: --> OpenP=12a99a968 for table=Schedule.Event.
          DB: --> OpenP=14e3711a8 for table=Schedules.
          DB: --> OpenP=12faf41a8 for table=Global.Attributes.
        Participant CS: voteReceived=False, ackReceived=False
      Locks held by Tsn=0:16394704 :
        Type=53001(cs universe), NameSpace=0, SummMode=sixLock,
    Mode=sixLock, Key=''
    
    Thread 504469, Parent 277: CsEventDeletionThread, Storage
    127304, AllocCnt 836717 HighWaterAmt 174880
     tid=3e95, ptid=4015, det=1, zomb=0, join=0, result=0, sess=0
      Holding mutex txnP->mutex (0x114c8a8a8), acquired at
    tbcli.c(1638)
      Stack trace:
        0x0900000000250140 semop
        0x090000000127342c sqloSSemP
        0x0900000001272de4 .sqlccrecv.fdpr.clone.102
        0x0000000000000000 *UNKNOWN*
        0x09000000012726ac sqljcReceive__FP10sqljCmnMgr
        0x090000000127edd8
    sqljrDrdaArOpen__FP14db2UCinterfaceP15db2UCCursorInfo
        0x0900000001248aac
    csmOpen__FP14db2UCinterfaceP15db2UCCursorInfo
        0x0900000001532690
    CLI_sqlOpen__FP17CLI_STATEMENTINFOP19CLI_ERRORHEADERINFO
        0x09000000015859bc
    SQLExecute2__FP17CLI_STATEMENTINFOP19CLI_ERRORHEADERINFO
        0x0900000001597fd8 SQLExecute
        0x000000010012e41c RdbPrepareAndExecuteStmt
        0x000000010012b9ac tbCliMRFetch
        0x0000000100b1a94c CsDelEventRecords
        0x0000000100b26080 CsEventDeletionThread
        0x000000010000c264 StartThread
    

Local fix

  • Apply fixing level and/or reduce the size of the events table.
    

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.3.5 and 7.1.1. 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

    IT03125

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-15

  • Closed date

    2014-07-21

  • Last modified date

    2014-07-21

  • 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

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
21 July 2014