Hi Joao,
the IBM Business Automation Workflow (BAW) as well as IBM Business Process Manager (BPM) licenses include IBM DB2 as a so called "supporting program".
The license information document (e.g. https://www-03.ibm.com/software/sla/sladb.nsf/lilookup/C790AE092CDB9E908525863B00481765?OpenDocument) states the details of the usage:
Supporting Programs
Licensee is authorized to install and use the Supporting Programs identified below only to support Licensee's use of the Principal Program under this Agreement. The phrase "to support Licensee's use" would only include those uses that are necessary or otherwise directly related to a licensed use of the Principal Program or another Supporting Program. The Supporting Programs may not be used for any other purpose. A Supporting Program may be accompanied by license terms, and those terms, if any, apply to Licensee's use of that Supporting Program. In the event of conflict, the terms in this License Information document supersede the Supporting Program's terms. Licensee must obtain sufficient entitlements to the Program, as a whole, to cover Licensee's installation and use of all of the Supporting Programs, unless separate entitlements are provided within this License Information document. For example, if this Program were licensed on a VPC (Virtual Processor Core) basis and Licensee were to install the Principal Program or a Supporting Program on a 10 VPC machine and another Supporting Program on a second 10 VPC machine, Licensee would be required to obtain 20 VPC entitlements to the Program.
It also lists any restrictions which are individual to a given supporting program.
For DB2 it states:
Prohibited Components
Licensee is not authorized to use any of the following components or functions of the Program:
- pureScale clustering technology (of IBM Db2 Standard Edition)
- Db2 Connect (of IBM Db2 Standard Edition)
- SQL Warehousing Tool (SQW) (of IBM Db2 Standard Edition)
Additional Supporting Program Details
IBM Db2 Standard Edition Restrictions:
- The Supporting Program may use a maximum of 16 processor cores and 128 GB of memory on each physical or virtual server; however, if the Supporting Program is used on a cluster of servers configured to work together using database partitioning or other permitted clustering technology, the Supporting Program may use a maximum of 16 processor cores and 128 GB of memory across all virtual or physical servers in that cluster.
So, long story short:
From a licensing perspective, you are not restricted to access the DB2 database which you set up as part of your BAW/BPM installation via JDBC only. You could also use other methods to connect to the database. However, you have to ensure that you use the included DB2 license only for the IBM BAW/BPM database and not for any other purpose. And of course you should restrict your SQL interactions with the IBM BAW/BPM database to "read only" queries in order to ensure data integrity. There is no support to add/change data in the IBM BPM database directly (via JDBC or whatever access method) but you have to stick with the IBM BAW/BPM APIs to do so.
Does that answer your question?
Best regards,
Michael
------------------------------
Michael Kirchner
------------------------------
Original Message:
Sent: Thu January 28, 2021 06:42 AM
From: Joao AMADOR
Subject: BPM 86 DB2 license and queries
Hello Everyone,
I've been searching but havent't found a clair conclusion , does anyone know if the included licence for DB2 in BPM 86 allows connections from outside jdbc systems to perform sql queries?
Regards,
Joao Amador
------------------------------
Joao AMADOR
------------------------------