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
[{"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":"62A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
19 March 2013