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.

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"Java","Version":"","Line of Business":{"code":"LOB70","label":"Z TPS"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Product Synonym

CICS/TS CICSTS CICS TS CICS Transaction Server

Document Information

Modified date:
08 October 2025

UID

dwa1339067