A fix is available
APAR status
Closed as new function.
Error description
Db2 13 for z/OS new function
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 13 for z/OS users of parallelism * * query. * **************************************************************** * PROBLEM DESCRIPTION: * * In the EREP output, a number of * * entries with reason code RC00E50013 * * are issued for a FETCH FIRST N ROWS * * query running on parallel. * **************************************************************** * RECOMMENDATION: * **************************************************************** In the EREP output, a number of entries with reason code RC00E50013 are issued for a FETCH FIRST N ROWS query running on parallel. The EREP entries RC00E50013 codes are generated by the parallel child tasks when the number of N rows returned to the application is satisfied by the parallel parent, but the parallel child tasks still have more rows to fetch. Hence, the parallel parent sends out a "STOP" message to its all child tasks. Once the child task receives this "STOP" message, the parallel child task will stop processing as if it is cancelled. Additional Keywords: SQLFFNR SQLPARALLELISM PARALLELISM DB2PARALL/K
Problem conclusion
Temporary fix
Comments
After applying this PTF, it will allow the parallel child task to "STOP" processing the FETCH FIRST N ROWS query sooner so that it will no longer write out the EREP entry RC00E50013 message.
APAR Information
APAR number
PH48183
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-07-21
Closed date
2022-08-18
Last modified date
2022-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI82021
Modules/Macros
DSNXROJ1 DSNXRTSC DSNXRTSS DSNXRFF DSNXRSGB DSNXRRP DSNXRT1J DSNXREOJ DSNXRSFN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UI82021
UP22/08/27 P F208
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 September 2022