There are a few other JDBC Drivers that support DRDA protocol that is used by IBM Db2 Servers.
Derby DB is one - you can do some interesting things with Derby if willing to do some ROLL-UR-OWN...
https://db.apache.org/derby/docs/10.0/publishedapi/org/apache/derby/drda/NetworkServerControl.html
There was a product from a German Company - but cannot find any information on tcEXPRESS - they must have dropped support.
Adaptigent formally GT Software, Inc.
Original Message:
Sent: Tue March 19, 2024 01:45 AM
From: Jørn Thyssen
Subject: JDBC - DB2 z/OS
Hi James,
The license requirement is tied to the use of IBM Data Server Driver, but you will have a hard time finding another JDBC driver that supports Db2 for z/OS.
It is less of a problem than it appears from this thread: a majority of customers are licensed for the Db2 Connect Unlimited Edition. You just need to convince your DBA to apply the license for the Db2 for z/OS server side or give you the appropriate client side license.
IBM Data Studio does use the IBM Data Server Driver and it does require a license file, but IBM included a restricted license for use with Data Studio only so you did not have to buy a separate license.
If you copy the license file provided with Db2 for z/OS or other IBM products such as Data Studio and use it with, say DbBeaver, you are violating the licensing terms, so don't do that.
------------------------------
Jørn Thyssen
Principal Solutions Advisor
Rocket Software
Original Message:
Sent: Mon March 18, 2024 11:09 PM
From: James Campbell
Subject: JDBC - DB2 z/OS
Really does not answer the question.
There are two situations:
1) user uses the various jar and zip files provided in the IBM Data Server Driver for JDBC and SQLJ or with Db2. Yes, license needs to be purchased. If for no other reason than the Connect won't really happen if there isn't a license and sqlcode -4472 results. But (my understanding is) the -4472 is generated on the client side - not out of Db2 for z/OS.
2) user uses another JDBC / ODBC driver. Perhaps they wrote their own - after all DRDA is supposed to be an open standard available to anyone. Perhaps they used Data Studio , which did not (for the versions that supported use with Db2 for z/OS) require a separate license. To the original question - does DBeaver come into this category?
So the question is - is a Db2 Connect license required if IBM Data Server Driver for JDBC and SQLJ is not being used?
------------------------------
James Campbell
Original Message:
Sent: Mon March 18, 2024 04:20 AM
From: Diego Cardalliaguet
Subject: JDBC - DB2 z/OS
Given that there's so much controversy...
Environment variables for the z/OS Application Connectivity to Db2 for z/OS feature
Ibm | remove preview |
| Environment variables for the z/OS Application Connectivity to Db2 for z/OS feature | You need to set environment variables so that the operating system can locate the z/OS Application Connectivity to Db2 for z/OS feature. | View this on Ibm > |
|
|
It is available to use JDBC T4 driver.
------------------------------
Diego Cardalliaguet
IBM Data&AI zStack Leader for EMEA
IBM
Original Message:
Sent: Wed March 13, 2024 09:16 PM
From: Renato Almeida de Brito
Subject: JDBC - DB2 z/OS
Hi. Can I execute queries via JDBC on DB2 12 z/OS without having to purchase DB2 Connect? For example using the "DBeaver" software.
Thanks.
#Db2 for z/OS
------------------------------
Renato Almeida de Brito
------------------------------