IBM Support

DSRA8100E PooledConnection with SQL State 57015 Code -923 when using CICS integrated-mode Liberty JVM server

Question & Answer


Question

I am running an application my a CICS Transaction Server for z/OS (CICS TS) V5.3 integrated-mode JVM server that makes a SOAP call using a JDBC Type 2 DataSource. Why would my Liberty server show this message?

 DSRA8100E: Unable to get a PooledConnection from the DataSource. with SQL State : 57015 SQL Code : -923

If I look in the dump in the CICS tracing, I see the taskid 05235 running on T800C attempting to find a DB2ENTRY for the CJSA transaction and not finding one. Then looking for the DEFAULT plan and getting an exception.

Answer

There is no DB2ENTRY for the CJSA transaction so it is looking for a DB2 planname of "DEFAULT" which fails resulting in the -923 SQLCODE.

CICS trace shows attempts to locate a DB2ENTRY for CJSA and finally returning exception:

 AP 3266 D2D2  *EXC* FAILED_TO_ALLOCATE_PLAN(DEFAULT )

See the CICS TS V5.3 in the CICS TS V5.3 documentation topic Manually configuring a DB2 DataSource with type 2 connectivity through CICS using the Liberty jdbc-4.0 or jdbc-4.1 features

...where it references Defining the DB2 Connection which includes creating a DB2ENTRY.

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

Product Synonym

CICS/TS CICSTS CICS TS CICS Transaction Server

Document Information

Modified date:
09 October 2017

UID

dwa1405753