Question & Answer
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.
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.
CICS/TS CICSTS CICS TS CICS Transaction Server
09 October 2017