IC89083: ANR2033E LOCK CONFLICT,ANR1696E AND ANR2705E ERRORS FOR SCHEDULE UPDATE CONFLICT WITH SQL AGAINST"CLIENT_SCHEDULE" TABLE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • An update/delete/copy of a Tivoli Storage Manager schedule such
    as the "delete schedule" command may fail reporting the
    following error into the Activity Log when an SQL statement is
    running at the same time against the "client_schedule" table:
    
    
    23.05.12 09:10:11 CEST ANR2033E DELETE SCHEDULE: Command failed
    - lock conflict. (SESSION: 3452)
    23.05.12 09:10:11 CEST ANR1696E Server SERVER1 attempted to
    process command 'DEL SCHED SCHED1 XXX_NODE' but encountered
    errors.(SESSION: 8)
    23.05.12 10:10:44 CEST ANR2033E QUERY EVENT: Command failed -
    lockconflict. (SESSION: 3467)
    23.05.12 10:10:44 CEST ANR2033E DEFINE SCHEDULE: Command failed
    - lockconflict. (SESSION: 8)
    23.05.12 10:10:44 CEST ANR2705E cssess.c(1321) Scheduler lock
    failed:99. (SESSION: 3279)
    23.05.12 10:10:44 CEST ANR2705E csprompt.c(518) Scheduler lock
    failed:-1. (SESSION: 80)
    23.05.12 10:10:44 CEST ANR2705E csmgr.c(672) Scheduler lock
    failed: -1.
    23.05.12 10:10:44 CEST ANR2705E cssess.c(1321) Scheduler lock
    failed:99. (SESSION: 3417)
    23.05.12 10:10:44 CEST ANR2705E cscmdsch.c(371) Scheduler lock
    failed:-1.
    23.05.12 10:10:44 CEST ANR2703E Schedule prompter aborted.
    (SESSION: 80)
    23.05.12 10:10:44 CEST ANR2599W The central scheduler is unable
    to obtain a required lock and will retry in 60 seconds.
    
    
    The  problem is caused because of the interlock of the "delete
    schedule" command and a concurrently running SELECT statement
    on the "client_schedule" table.
    
    
    
    
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager Server V5 and V6
    
    
    
    
    Initial Impact:
    Low
    
    
    
    
    Additional Keywords:
    TSM lock conflict SQL schedule
    

Local fix

  • Run "update/delete/copy schedule" when no time consuming SELECT
    statement is running.
    

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.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

    IC89083

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    62A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-13

  • Closed date

    2013-03-13

  • Last modified date

    2013-03-19

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager

Software version:

62A

Reference #:

IC89083

Modified date:

2013-03-19

Translate my page

Machine Translation

Content navigation