IBM Support

SQL -923 connection error when trying to run CICS JDBC sample application

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"Java","Version":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Product Synonym

CICS/TS CICSTS CICS TS CICS Transaction Server

Document Information

Modified date:
18 January 2017

UID

dwa1339067