A fix is available
APAR status
Closed as program error.
Error description
Setting of CURRENT OPTIMIZATION HINT for remote applications does not work.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for zOS users of the CURRENT * * OPTIMIZATION HINT special register * * for remote applications * **************************************************************** * PROBLEM DESCRIPTION: The CURRENT OPTIMIZATION HINT * * special register is set incorrectly * * when using implicit DRDA or the JCC * * properties. * **************************************************************** * RECOMMENDATION: * **************************************************************** The setting of the CURRENT OPTIMIZATION HINT special register through implicit DRDA or through the JCC API does not set the special register correctly; garbage data is stored instead of the proper value. In addition, an error is not issued when a string longer than 128 bytes is used to set CURRENT OPTIMIZATION HINT special register through an implicit DRDA connection or through the JCC API.
Problem conclusion
DB2 is modified to set the CURRENT OPTIMIZATION HINT special register correctly. For strings longer than 128 bytes, DB2 will now issue sqlcode -725. Additional Keywords: SQLSPECIALREG
Temporary fix
Comments
APAR Information
APAR number
PM87044
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-15
Closed date
2013-07-08
Last modified date
2013-10-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK96744 UK96745
Modules/Macros
DSNXESSR DSNXRSPG DSNXRSQO
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 October 2013