IBM Support

IT19093: SQL QUERIES MAY PRODUCE INCORRECT RESULTS DUE TO DB2 APAR IT13665

Subscribe

You can track all active APARs for this component.

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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 7.1.3

Reference #: IT19093

Modified date: 01 March 2017