DB2 v11 CM z/OS 2.2 SQLCODE = -4302

Ram Ramaiyan

DB2 v11 CM z/OS 2.2 SQLCODE = -4302

Dear Experts, 

We have recently migrated our data sharing systems from DB2 v10 NFM to DB2 v11 CM. After migration application is facing SQLCODE =-4302. 

Display ==> M (M=Msg,X=Hex) DB2 SSID ==> DXT1
SQLcode ==> -4302 Opid ==> XXXXXXX Planname ==> DISTSERV
SQLstate ==> 38000 Connid ==> SERVER Contoken ==> 5359534C564C3031
Program ==> SYSLH200 Type ==> PKGE Stmt# ==> 1
Collid ==> NULLID
Version ==>

-------------------------------------------------------------------------------

DSNT408I SQLCODE = -4302, ERROR: JAVA STORED PROCEDUE OR USER-DEFINED
FUNCTION DB2XML.HTTPPOSTCLOB (SPECIFIC NAME DB2XML.HTTPPOSTCLOB) HAS
EXITED WITH AN EXCEPTION java.io.IOException: Server re
DSNT418I SQLSTATE = 38000 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION.

The function and respective WLM is available. We have also applied the PTF UI36354. 

Any leads will be really appreciated. Thank you!

-Ram R.

Lizette Koehler

DB2 v11 CM z/OS 2.2 SQLCODE = -4302
(in response to Ram Ramaiyan)
What is the Java Error? This looks truncated



EXITED WITH AN EXCEPTION java.io.IOException: Server re



Lizette





From: Ram Ramaiyan [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 9:47 AM
To: [login to unmask email]
Subject: [DB2-L] - DB2 v11 CM z/OS 2.2 SQLCODE = -4302



Dear Experts,

We have recently migrated our data sharing systems from DB2 v10 NFM to DB2 v11 CM. After migration application is facing SQLCODE =-4302.

Display ==> M (M=Msg,X=Hex) DB2 SSID ==> DXT1
SQLcode ==> -4302 Opid ==> XXXXXXX Planname ==> DISTSERV
SQLstate ==> 38000 Connid ==> SERVER Contoken ==> 5359534C564C3031
Program ==> SYSLH200 Type ==> PKGE Stmt# ==> 1
Collid ==> NULLID
Version ==>

-------------------------------------------------------------------------------

DSNT408I SQLCODE = -4302, ERROR: JAVA STORED PROCEDUE OR USER-DEFINED
FUNCTION DB2XML.HTTPPOSTCLOB (SPECIFIC NAME DB2XML.HTTPPOSTCLOB) HAS
EXITED WITH AN EXCEPTION java.io.IOException: Server re
DSNT418I SQLSTATE = 38000 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION.

The function and respective WLM is available. We have also applied the PTF UI36354.

Any leads will be really appreciated. Thank you!

-Ram R.

Lizette Koehler

DB2 v11 CM z/OS 2.2 SQLCODE = -4302
(in response to Lizette Koehler)
User-defined function or stored procedure routine-name exited with a Java exception that was not a java.sql.SQLException.



If present, exception-string contains as much as will fit of the toString() of the exception that was uncaught.



The user-defined function or stored procedure probably needs to be corrected. See your database administrator, or the author of the routine to find out if the exception can be avoided, or if the user-defined function or stored procedure needs to be fixed before it can be used.



Lizette



From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 9:51 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 v11 CM z/OS 2.2 SQLCODE = -4302



What is the Java Error? This looks truncated



EXITED WITH AN EXCEPTION java.io.IOException: Server re



Lizette





From: Ram Ramaiyan [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 9:47 AM
To: [login to unmask email] <mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 v11 CM z/OS 2.2 SQLCODE = -4302



Dear Experts,

We have recently migrated our data sharing systems from DB2 v10 NFM to DB2 v11 CM. After migration application is facing SQLCODE =-4302.

Display ==> M (M=Msg,X=Hex) DB2 SSID ==> DXT1
SQLcode ==> -4302 Opid ==> XXXXXXX Planname ==> DISTSERV
SQLstate ==> 38000 Connid ==> SERVER Contoken ==> 5359534C564C3031
Program ==> SYSLH200 Type ==> PKGE Stmt# ==> 1
Collid ==> NULLID
Version ==>

-------------------------------------------------------------------------------

DSNT408I SQLCODE = -4302, ERROR: JAVA STORED PROCEDUE OR USER-DEFINED
FUNCTION DB2XML.HTTPPOSTCLOB (SPECIFIC NAME DB2XML.HTTPPOSTCLOB) HAS
EXITED WITH AN EXCEPTION java.io.IOException: Server re
DSNT418I SQLSTATE = 38000 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION.

The function and respective WLM is available. We have also applied the PTF UI36354.

Any leads will be really appreciated. Thank you!

-Ram R.

Philip Sevetson

DB2 v11 CM z/OS 2.2 SQLCODE = -4302
(in response to Lizette Koehler)
**please note my email address change**
Check the JDBC drivers which Websphere is using.

We had this problem on migrating to V11 a couple of months ago, and it turned out that our instances of Websphere were using JDBC Type 3 drivers, at a (very old) level which is _not_ supported by DB2V11. Upgrading the drivers (in our case, to the current version and JDBC Type 4) resolved the problem.

Philip Sevetson
Computer Systems Manager
5 Manhattan West (33rd St at 10th Ave)
New York, NY 10001-2632
212-857-1688 w
917-991-7052 c
212-857-1659 f
[cid:[login to unmask email]

From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 12:54 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 v11 CM z/OS 2.2 SQLCODE = -4302

User-defined function or stored procedure routine-name exited with a Java exception that was not a java.sql.SQLException.

If present, exception-string contains as much as will fit of the toString() of the exception that was uncaught.

The user-defined function or stored procedure probably needs to be corrected. See your database administrator, or the author of the routine to find out if the exception can be avoided, or if the user-defined function or stored procedure needs to be fixed before it can be used.

Lizette

From: Lizette Koehler [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 9:51 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - RE: DB2 v11 CM z/OS 2.2 SQLCODE = -4302

What is the Java Error? This looks truncated

EXITED WITH AN EXCEPTION java.io.IOException: Server re

Lizette


From: Ram Ramaiyan [mailto:[login to unmask email]
Sent: Wednesday, July 26, 2017 9:47 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - DB2 v11 CM z/OS 2.2 SQLCODE = -4302


Dear Experts,

We have recently migrated our data sharing systems from DB2 v10 NFM to DB2 v11 CM. After migration application is facing SQLCODE =-4302.

Display ==> M (M=Msg,X=Hex) DB2 SSID ==> DXT1
SQLcode ==> -4302 Opid ==> XXXXXXX Planname ==> DISTSERV
SQLstate ==> 38000 Connid ==> SERVER Contoken ==> 5359534C564C3031
Program ==> SYSLH200 Type ==> PKGE Stmt# ==> 1
Collid ==> NULLID
Version ==>

-------------------------------------------------------------------------------

DSNT408I SQLCODE = -4302, ERROR: JAVA STORED PROCEDUE OR USER-DEFINED
FUNCTION DB2XML.HTTPPOSTCLOB (SPECIFIC NAME DB2XML.HTTPPOSTCLOB) HAS
EXITED WITH AN EXCEPTION java.io.IOException: Server re
DSNT418I SQLSTATE = 38000 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNX9CAC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION.

The function and respective WLM is available. We have also applied the PTF UI36354.

Any leads will be really appreciated. Thank you!

-Ram R.

-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
Attachments

  • image001.png (3.3k)