A fix is available
APAR status
Closed as program error.
Error description
SQL code -4742 rsn=11 on SELECT with FETCH FIRST n ROWS ONLY FOR FETCH ONLY and Accelerator is enabled. IDAAV3R1/K (d167854)
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 11 for z/OS who are * * also using IBM DB2 Analytics Accelerator. * **************************************************************** * PROBLEM DESCRIPTION: SQLCODE -4742 REASON 11 is incorrectly * * returned for queries that include * * data that is encoded with the EBCDIC * * mixed or graphic encoding schemes. * **************************************************************** * RECOMMENDATION: * **************************************************************** SQLCODE -4742 REASON 11 is incorrectly returned for queries that include data that is encoded with the EBCDIC mixed or graphic encoding schemes.
Problem conclusion
Code is fixed to offload the query to the accelerator Additional Search Keywords: IDAAV3R1/K IDAAV4R1/K SQLCODE4742
Temporary fix
Comments
APAR Information
APAR number
PM93122
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-07-16
Closed date
2013-08-01
Last modified date
2013-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK96375
Modules/Macros
DSNXONZA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UK96375
UP13/08/17 P F308
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":"11.0","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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 September 2013