A fix is available
APAR status
Closed as program error.
Error description
Any SELECT statements containing the IN or NOT IN clauses may not return valid results. For example, the following query does not return an accurate count of filespaces: tsm: SERVER>select count(*) from filespaces where node_name in (select node_name from nodes where nodetype='CLIENT') Unnamed[1] ------------ 1 The same query, when re-issued with the GROUP BY clause, correctly returns the count of matching filespaces: tsm: SERVER>select count(*) from filespaces where node_name in (select node_name from nodes where nodetype='CLIENT' group by node_name) Unnamed[1] ------------ 44 This problem behavior is addressed by DB2 APAR IT13665: http://www-01.ibm.com/support/docview.wss?uid=swg1IT13665 Versions Affected: IBM Spectrum Protect server versions 7.1.4 and higher. IBM Spectrum Protect server version 8.1.x is not affected by this problem. Initial Impact: Low
Local fix
Do not use the IN or NOT IN clauses when issuing SELECT statements against the IBM Spectrum Protect server. The circumvention described in APAR IT13665 will resolve the problem behavior, but may adversely affect the performance of complex SQL queries.
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 7.1.8. Note that this is * * subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms for reported release: AIX, HP-UX, Solaris, Linux, and Windows. Platforms fixed: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT19093
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-02-02
Closed date
2017-03-01
Last modified date
2017-03-01
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
[{"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":"7.1.3","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
01 March 2017