IBM DB2 Connector

1 Kudo

IBM DB2 integration from SailPoint helps manage users and roles for the DB2 server (Windows/Linux). Capabilities include account management, Account - Group management, and permission management.

Support Level: SailPoint Delivered

Connectors developed by SailPoint's Engineering team and supported under annual SailPoint support and maintenance. Reach out to SailPoint support for assistance.

Supported Use Cases

Full Account Aggregation
Single Account Aggregation
Full Group Aggregation
Single Group Aggregation
Create Account Provisioning
Update Account Provisioning
Delete Account Provisioning*
Create Group Provisioning*
Update Group Provisioning*
Delete Group Provisioning*
Enable / Disable Account Provisioning
Unlock Account Provisioning
Change Account Password
Add Entitlement(s)
Remove Entitlement(s)
Discover Schema*

*This feature is currently supported only with the IdentityIQ platform

Supported Versions

SailPoint IBM DB2 Connector supports the following versions of DB2 Server on Linux, Unix and Windows:
- IBM DB2 Enterprise Server version 11.5
- IBM DB2 Enterprise Server version 11.1
- IBM DB2 Enterprise Server version 10.5

Contact Us

SailPoint Support

SailPoint Professional Services

hugo_medeiros · ‎May 28, 2021

Are there plans to support version 12?

jjain · ‎Aug 03, 2022

Hi @deepesh_kumar ,

Although IBM DB2 connector document states supported platforms as Linux, Unix and Windows, we have a DB2 running on Mainframe Z/OS and wanted to check if db2jcc.jar driver can be used for connecting to DB2.

jstamps91 · ‎Dec 01, 2022

@jjain @deepesh_kumar,

Did either of you ever get resolution around jjain's question? We are running into this same issue, but are using iSeries to run our DB2.

Does this connector only support LUW type DB2?

samgupta · ‎Dec 05, 2022

@jstamps91 The IBM DB2 connector is planned to be certified for the latest version of IBM DB2 (Version 13) on zOS 2.5. I'll be sharing updates on the release timeline soon.

tusharkant-choudhury · ‎Mar 30, 2023

@samgupta Do we have any Updates on Connecting to DB2 on Mainframe.

jobowyer · ‎Jun 06, 2023

Bump, we are running into the following issue trying to connect to our DB2 on Mainframe:

Failure trying to get a pooled connection to [jdbc:CONNECTION_URL] com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10509][13454][3.72.54] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to the data server and using DB2 Connect Unlimited Edition for System z, perform the activation step by running the activation program in the license activation kit. If you are using any other edition of DB2 Connect, obtain the license file, db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968

Ger · ‎Jul 07, 2023

Hi there,

Is there any update on this Samgupta ??

The IBM DB2 connector is planned to be certified for the latest version of IBM DB2 (Version 13) on zOS 2.5. I'll be sharing updates on the release timeline soon.

If not, does it work now but just not supported or can it be done via JDBC connector ?

Many thansk
Ger

IBM DB2 Connector