A fix is available
APAR status
Closed as program error.
Error description
DB2DDF IDAAV2R1/K IDAAV3R1/K Defect pm75917 dpm75917 A java application using the IBM DB2 Data Server connects to a DB2 10 for z/OS server and executes an OPEN or a INSERT WITH SELECT statement to be offloaded to IDAA. The statement includes timestamp input data, but the statement fails with one of the following SQL errors: SQLCODE = -514 SQLCODE = -518 ************************************************************* Additional Symptoms and Keywords: SQLCODE -514 SQLCODE514 SQL514N SQL0514N SQL00514N SQLCODE -518 SQLCODE518 SQL518N SQL0518N SQL00518N
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Distributed Data Facility (DDF) users * * accessing the IBM Data Analytics Accelerator * * (IDAA). * * DB2 10 for z/OS users only. * **************************************************************** * PROBLEM DESCRIPTION: An application using the IBM Data * * Server Driver for JDBC and SQLJ * * accesses DB2 10 for z/OS in New * * Function Mode (NFM) to open a query or * * to perform an INSERT with subselect * * where the query or subselect, * * respectively, is offloaded to IDAA. * * The request fails with SQLCODE -514 or * * SQLCODE -518 (SQLCODE514 or * * SQLCODE518), respectively, even though * * the dynamic request is prepared. * **************************************************************** * RECOMMENDATION: * **************************************************************** The query or subselect being offloaded to IDAA includes timestamp input data and the application options cause the PREPARE request and OPEN or EXECUTE of the prepared statement to be sent to DB2 10 for z/OS in a chain. DB2 incorrectly rejects the query offload with SQLCODE -514 or SQLCODE -518.
Problem conclusion
DB2 10 for z/OS server processing has been corrected to process timestamp input data from the IBM Data Server Driver for JDBC and SQLJ for queries being offloaded to IDAA.
Temporary fix
Comments
APAR Information
APAR number
PM75917
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
2012-10-25
Closed date
2012-12-03
Last modified date
2013-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK83965
Modules/Macros
DSNLXROP DSNXERT DSNXERT2
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK83965
UP12/12/19 P F212
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:
02 January 2013