IBM Support

PH28029: A QUERY MAY DELIVER WRONG RESULTS IF IT CONTAINS A SCALAR SUBQUERY AND 'FETCH FIRST 1 ROW' (-> IT33171)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • A query may deliver wrong results if there
    - exists at least one scalar subquery
    - at least one of the scalar subqueries contains
      'FETCH FIRST 1 ROW'
    This issue is the same as described in Db2luw APAR IT33171.
    
    The issue will be fixed with IDAA V7.5 maintenance level
    7.5.2.2.
    
    Additional keywords:
    IT33171 scalar subquery TS003662800
    

Local fix

  • Use query optimization level 0 or 1.
    

Problem summary

  • The issue has been resolved by maintenance level 7.5.2.2 of
    the accelerator; a new Db2wh engine (11.5.1) has been
    incorporated here which includes the fix for APAR IT33171.
    IT33171 describes the underlying root cause in the database.
    

Problem conclusion

  • Upgrade your accelerator maintenance level to 7.5.2.2 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH28029

  • Reported component name

    ANYTCS ACCLTR Z

  • Reported component ID

    5697DA700

  • Reported release

    750

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-07-30

  • Closed date

    2021-01-21

  • Last modified date

    2021-01-21

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"750"}]

Document Information

Modified date:
22 January 2021