Question & Answer
Question
Why am I getting an SQL code -923 when trying to run the supplied JVM server Java Database Connectivity (JDBC) sample application in CICS Transaction Server for z/OS (CICS TS)? I have setup my JVM server and it starts without error. The DB2 subsystem is connected to the CICS region. When I run the J327 transaction, I get an SQLCODE = -923 connection error.
Answer
First step is to make sure you configured your JVM server correctly for DB2. To do this, refer to Configuring a JVM server to support DB2 in the CICS TS documentation.
The SQL error code -923 makes it seem like the Java setup is correct and that the failure is somewhere between CICS and DB2. Capturing a trace of the problem, shows that the problem is that the plan being used is not bound in DB2. The plan being used is DSNJCC. To support a default naming convention for the IBM Data Server Driver for JCBS and SQLJ, the CICS-supplied dynamic plan exits, DSNCUEXT and DFHD2PXT can detect an input CPRMPLAN name whose first characters are SYSSTAT, SYSLH or SYSLN. If such a plan name is detected, the plan name is changed to "DSNJCC ". To use the default dynamic plan exits, with Java applications for CICS, bind the multiple DBRMs into a plan called DSNJCC.
More information about the sample exit program DSNCUEXT can be found here in the CICS TS documentation under topic The sample exit programs, DSNCUEXT and DFHD2PXT.
Product Synonym
CICS/TS CICSTS CICS TS CICS Transaction Server
Was this topic helpful?
Document Information
Modified date:
18 January 2017
UID
dwa1339067