Direct links to fixes
6.3.6.000-TIV-TSMRPT-AGENT-Linux
6.3.6.000-TIV-TSMRPT-AGENT-AIX
6.3.6.000-TIV-TSMRPT-AIX
6.3.6.000-TIV-TSMRPT-AGENT-Windows
6.3.6.000-TIV-TSMRPT-Linuxx86
6.3.6.000-TIV-TSMRPT-Linuxx86_64
6.3.6.000-TIV-TSMRPT-WindowsI32
6.3.6.000-TIV-TSMRPT-WindowsX64
6.3.6.000-TIV-TSMAC-WindowsX64
6.3.6.000-TIV-TSMAC-WindowsI32
6.3.6.000-TIV-TSMAC-SolarisSPARC
6.3.6.000-TIV-TSMAC-Linuxx86
6.3.6.000-TIV-TSMAC-Linuxs390x
6.3.6.000-TIV-TSMAC-AIX
6.3.6.000-TIV-TSMALL-SolarisSPARC
6.3.6.000-TIV-TSMALL-WindowsX64
6.3.6.000-TIV-TSMSTA-WindowsI32
6.3.6.000-TIV-TSMALL-HP-UX
6.3.6.000-TIV-TSMALL-Linuxppc64
6.3.6.000-TIV-TSMALL-AIX
6.3.6.000-TIV-TSMALL-Linuxs390x
6.3.6.000-TIV-TSMALL-Linuxx86_64
IBM Tivoli Storage Manager (TSM) server V7.1.1.x interim fix downloads
IBM Tivoli Storage Manager V6.3 Fix Pack 6 (6.3.6.000) Server Downloads
APAR status
Closed as program error.
Error description
Select commands return incorrect results after upgrade to Tivoli Storage Manager Server v6.3.5 or v7.1.1 after a "DEFINE CURSOR" command is used. For example: tsm: TSM11>SELECT VOLUME_NAME FROM libvolumes WHERE status='Scratch' VOLUME_NAME ---------------------------------------------------------------- -- GRO028L4 GRO124L4 GRO209L4 tsm: TSM11>SELECT COUNT(*) FROM libvolumes WHERE status='Scratch' Unnamed[1] ------------ 3 At the same time, the command "query libvolume" on the same server returns a different result. TSM11> query libvolume TS3500LIB GRO032L4 Private Data 1,035 LTO TS3500LIB GRO124L4 Private Data 1,036 LTO TS3500LIB GRO006L4 Scratch 1,037 LTO TS3500LIB GRO210L4 Private Data 1,038 LTO TS3500LIB GRO041L4 Scratch 1,039 LTO TS3500LIB GRO314L4 Private 1,040 LTO The correct output is in "query libvolume" command. Customer/L2 Diagnostics: The problem has been introduced by APAR IC96223 and occurs when the command "define cursor" is used for select statements. For example the following command will cause to have an incorrect output for any subsequent select statement: DEFINE CURSOR C87b12e4 SQL='SELECT * FROM NODES' Other tables involved may be VOLUMES and EVENTS. Tivoli Storage Manager Versions Affected: All Tivoli Storage Manager Server 6.3.5.x and 7.1.1.x on all Platforms. | MDVREGR 6.3.5.0-TIV_5698ISMSV | | MDVREGR 7.1.1.0-TIV_5698ISMSV | Initial Impact: low Additional Keywords: define cursor sql select incorrect db2 IC96223
Local fix
Do not use "define cursor" command with select statements
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager server users of the DEFINE CURSOR * * command. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in levels 6.3.6, 7.1.1.200, and 7.1.3. * * Note that this is subject to change at the discretion of * * IBM. * ****************************************************************
Problem conclusion
This problem was fixed. The tables used on the DEFINE CURSOR command will now continue to update, but only after either the session using the cursor terminates or if the DELETE CURSOR command is used. If you are running an application that is using the DEFINE CURSOR command make sure it is deleting the cursors using the DELETE CURSOR command, or terminating the session with the Tivoli Storage Manager server as soon as it is done with the cursors. On session termination the Tivoli Storage Manager server will perform the deletion of the defined cursors. The following tables are known to be affected by this issue: ADMIN_SCHEDULES, ADMINS, CLIENT_SCHEDULES, DBSPACE, DB, DEVCLASSES, DRIVES, EVENTS, LIBRARIES, LIBVOLUMES, SQL_LICENSES, MEDIA, OPTIONS, SCRIPTS, SERVER_GROUP_VIEW, SESSIONS, STGPOOLS, VOLUMES, STATUS, AUDITOCC, CLIENTOPTS, MGMTCLASSES, DOMAINSVIEW, RESTORES, PROCESSES, DRMEDIA, PATHS, CLOPTSETS, DRMSRPF, DRMTRPF, DRMSTANZA, SAN, SHREDSTATUS, SCRIPT_NAMES, LOG, and TSM_MON_SETTINGS. Affected platforms: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT06648
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
63W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-01-23
Closed date
2015-02-23
Last modified date
2015-07-09
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
Document Information
Modified date:
09 July 2015