A fix is available
APAR status
Closed as program error.
Error description
During an explain with the 'FETCH FIRST ? ROWS' clause, a detected error condition is mishandled.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Process SQL from a sequential data set or * * PDS member; * **************************************************************** * PROBLEM DESCRIPTION: Unable to dynamically explain SQLs * * that contain phrases "FETCH ? ROWS" * * or "OFFSET ? ROWS " * **************************************************************** * RECOMMENDATION: Apply the PTFs * **************************************************************** Unable to dynamically explain SQLs that contain phrases "FETCH ? ROWS" or "OFFSET ? ROWS "
Problem conclusion
Code logic was corrected to fix the issues described.
Temporary fix
Comments
APAR Information
APAR number
PH37648
Reported component name
DB2 SQL PERF AN
Reported component ID
5697F5701
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-05-27
Closed date
2021-06-17
Last modified date
2021-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI75962
Modules/Macros
ANLBATCH ANLMAIN ANLPH91B ANLPH91C ANLPH91D ANLPH91E ANLPH91F ANLPH91H ANLPH91I ANLPH91J ANLPH91K ANLPH91L ANLPIDD ANLPTEX ANLSQLPA ANLTSO
Fix information
Fixed component name
DB2 SQL PERF AN
Fixed component ID
5697F5701
Applicable component levels
R510 PSY UI75962
UP21/06/19 P F106
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":""},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Document Information
Modified date:
03 July 2021