A fix is available
APAR status
Closed as new function.
Error description
New Function to improve the APREUSE bind option
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users. * **************************************************************** * PROBLEM DESCRIPTION: * * The APREUSE bind option is sometimes * * unable to reuse a particular access * * path due to a change in the query * * transformations performed on the * * query. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When certain query transformations applied to a query change, it sometimes results in the APREUSE bind option being unable to reuse the access path. This can result in a bind error, when APREUSE(ERROR) is specified, or a bind warning, when APREUSE(WARN) is specified.
Problem conclusion
This APAR provides new functionality to improve the reusability of certain access paths with the APREUSE bind option when query transformations are involved. This reduces the likelihood that the APREUSE bind option will result in a bind error, or a bind warning.
Temporary fix
Comments
APAR Information
APAR number
PH36728
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-04-27
Closed date
2021-05-26
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:
UI75603
Modules/Macros
DSNXODML DSNXOD10 DSNXOGP DSNXOLX1 DSNXORDP DSNXOFMG DSNXOCCA DSNXESX DSNXEXPL DSNXOD17 DSNXOD18 DSNXOD13 DSNXOLX2 DSNXOCCH DSNXOD15 DSNXOD16 DSNXOD20 DSNXOMRG DSNXOPTI DSNXQADD DSNXOAPL DSNXOPAH DSNXOPRW DSNXOD8 DSNXOD9 DSNXOD7 DSNXOD4 DSNXOD5 DSNXOD2 DSNXOD3 DSNXOD1 DSNXODTX
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI75603
UP21/06/04 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":"LOB10","label":"Data and AI"},"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":"All Versions"}]
Document Information
Modified date:
03 July 2021