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