When using the Data Source Explorer in TIBCO Business Studio to create a connection to a DB2 database higher than DB2 9.5, the Schemas section cannot be expanded.
Article ID: KB0093719
Updated On:
| Products | Versions |
|---|---|
| TIBCO Business Studio iProcess Add-in | - |
| TIBCO iProcess Business Studio | - |
| TIBCO Business Studio - BPM Edition | - |
Description
Description:
When using the Data Source Explorer in TIBCO Business Studio to create a
connection to a DB2 database higher than DB2 9.5, the Schemas section
cannot be expanded.
Symptoms:
If you are attempting to model a Database Service Task, the Data Source Explorer can be used to select your stored procedure and auto-populate the Parameters section of the call. If you attempt to make a connection to a DB2 database higher than version 9.5, the Schemas section can not be expanded in order to select a stored procedure.
Cause:
The DTP drivers within TIBCO Business Studio 3.5.2 (Eclipse Ganymede version 3.4.2) will not work with any version of DB2 greater than 9.5. This was resolved in the 1.11.2 version of the DTP drivers where the IBM "enablement" plugins (org.eclipse.datatools.enablement.ibm.xxx) were reworked to include a catalog loader that is specific to DB2
for LUW. Previously it was using the default (Derby) catalog loader,
which does not work for DB2 releases after v9.5.
Resolution
Issue/Introduction
Additional Information
Feedback
