Hi Christoph,
the following answer came from IBM:
"If you want to use Type 2 connectivity, the application should be changed to use only one connection. Using multiConnsWithExistingAttach (JCC property) is not recommended because it may cause problems due to connection sharing.
T4 connection is based on DRDA, thats nothing to do with the existing attachemnet. t2 z/Os uses the existing attachment and it cannot work same as t4
Usually we wont recommend to use this property"
And regarding the performance perspective I recommend to have a look at the IBM Redbook from the IBM CICS Performance Series: IBM CICS Performance Series: Comparing Type 2 and Type 4 JDBC Driver Performance with IBM CICS Transaction Server for z/OS V5.2 Liberty JVM server
We are not able to verify because of the above mentioned problem, but I guess it still works the same with CICS V6.x
------------------------------
Helmut Roese
------------------------------
Original Message:
Sent: Tue June 17, 2025 02:22 AM
From: Christoph Buck
Subject: Multiple DataSources in Liberty
Hallo Helmut!
Did IBM mention a reason as to WHY it does not work? Using different dataSources within the same server configuration does not seem to be that far fetched an idea...
Also, did you come to any conclusion regarding the performance comparison of JDBC type 2 and type 4? There seems to be an ongoing discussion and I feel like recommendations an swung back forth between the two options in recent years.
Kind regards!
------------------------------
Christoph
Original Message:
Sent: Mon June 16, 2025 04:52 AM
From: Helmut Roese
Subject: Multiple DataSources in Liberty
After we opened a case at IBM we got the answer that this type of processing does not work.
There might be an option to circumvent the problem but this is not recommended.
------------------------------
Helmut Roese
Original Message:
Sent: Fri March 28, 2025 05:16 AM
From: Helmut Roese
Subject: Multiple DataSources in Liberty
We are currently using multiple dataSources with a JDBC-driver type4 in Liberty with CICS 5.6 and it works well. We now wanted to try the JDBC-driver type2 to compare the performance but we get an error message com.ibm.db2.jcc.t2zos.T2zosConnection.initialize: Multiple Connections are disallowed in current pre-existing attachment environment ERRORCODE=-4228, SQLSTATE=null
All dataSource belong to the same DB2 , but have different Schemas. Does anyone use this type of configuration?
------------------------------
Helmut Roese
------------------------------