A fix is available
APAR status
Closed as program error.
Error description
DB2DDF DB2DRDA defect pm76746 dpm76746 A DB2 for z/os distributed requester thread receives a -30005 from DSNLZRDT when accessing binary xml data on a remote DB2 server that does not support SQLAM level 10. For DB2 for z/os servers, SQLAM level 10 is not supported until DB2 10 NFM. ************************************************************ Additional Symptoms and Keywords: SQLCODE30005 SQLCODE -30005 SQL30005N DSNLZRDT XML
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All Distributed Data Facility (DDF) users. * **************************************************************** * PROBLEM DESCRIPTION: A DB2 10 for z/OS application may * * encounter the following error : * * o SQLCODE -30005, with SQLSTATE * * 56072 and SQLERRP DSNLZRDT when * * DB2 is operating in CM. * * o SQLCODE -303, with SQLSTATE * * 56072 and SQLERRP DSNLZRDT when * * DB2 is operating in NFM. * **************************************************************** * RECOMMENDATION: * **************************************************************** A DB2 10 for z/OS application connects to a remote server while DB2 is operating in Conversion Mode (CM). DB2 incorrectly interprets the input SQLDA provided for the SQL statement and thus incorrectly determines that binary XML data is provided. As a result, DB2 incorrectly detects an SQLCODE -30005 condition and fails the SQL since binary XML data type is not supported in a DB2 10 CM environment. Similarly, when the same condition occurs in DB2 10 New Function Mode (NFM), SQLCODE -303 can incorrectly be issued.
Problem conclusion
DB2 10 for z/OS requester processing has been changed to correctly determine when an input SQLDA describes binary XML data.
Temporary fix
Comments
APAR Information
APAR number
PM76746
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-11-08
Closed date
2013-03-05
Last modified date
2013-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK92251
Modules/Macros
DSNLXMRF DSNLXRBF DSNLXRFT DSNLZGDT DSNLZRDT DSNLZVDA DSNXROHB DSNXROHR DSNXROHS DSNXROH2
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK92251
UP13/03/21 P F303
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 April 2013