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

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