A fix is available
APAR status
Closed as program error.
Error description
Targetless FETCH fails with SQLCODE -804 Rc 16 in DB2 V11 requester path. This occurs for local offload query and non-offload query where Continous Block Fetch feature is enabled.
Local fix
The workaround is properly fill in SQLDA area for the FETCH INTO request. Or temporarily disable IDAA acceleration for that table only to prevent query acceleration for that query.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 11 for z/OS ODBC/CLI users of the * * IBM DB2 Analytics Accelerator (IDAA) for * * query acceleration. * **************************************************************** * PROBLEM DESCRIPTION: An SQLCODE -804 (or SQLCODE804) * * reason code 16 can occur for ODBC/CLI * * applications that offload queries to * * IDAA (IBM DB2 Analytics Accelerator). * **************************************************************** * RECOMMENDATION: * **************************************************************** A DB2 for z/OS ODBC/CLI application offloads a query to IDAA. The application uses the SQLFetchScroll() API or SQLExtendedFetch() API to fetch a block of data containing multiple rows with LIMITEDBLOCKFETCH=1. The SQLFetchScroll() API or SQLExtendedFetch() API may skip rows by internally generating a "targetless" fetch (with or without the SQLBindCol() API), a DB2 FETCH statement without an INTO clause. During this process, an internal logic error occurs during the "targetless" fetch resulting in an SQLCODE -804 or SQLCODE +804. Please note. This error can also occur for application packages bound with option DBPROTOCOL(CBF) which offloads queries and issues "targetless" fetches.
Problem conclusion
DB2 has been modified to correctly skip rows during targetless fetches for offloaded queries. Additional Keywords: IDAAV2R1/K IDAAV3R1/K IDAAV4R1/K IDAAV5R1/K
Temporary fix
Comments
APAR Information
APAR number
PI57995
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-02-24
Closed date
2016-07-14
Last modified date
2016-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
006PC15 UI39387
Modules/Macros
DSNLZDTA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI39387
UP16/07/30 P F607
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:
02 August 2016