Is it possible to synchronize tables on DB2 for z/OS ?

Hi Raida,

To answer a question like this a lot more details are needed...

-What One Identity version are you running

-How is your DB2 for z/OS set-up? For example, do you have any insight into how the LDAP is configured (if so, the LDAP connector can work, there are also LDAP bridges for RACF systems)

What version of DB2 for z/OS are we talking about? The initial one from 1995 or the version 13 released in 2022 are erm, not comparable....

-Do you have any idea into what tables you want to synchronize?

So, be aware if you want to be able to get a useful answer a lot more details are needed... :) Otherwise the answer is, it depends... But there are people who manage their DB2 for z/OS systems.

Hi Jos

-What One Identity version are you running
 9.0 TLS

It is DB2 version 13 on  mainframe and we are using RACF 
I have create syncronization project and i can connect to DB2 using Windows ODBC datasource from syncronization project

We using DB2 Connnect version 11.5 installed Microsoft windows server

After Initializing where i wrote : sql statment :  SELECT * FROM TEST.Employee

Error running the following statement.

SELECT * FROM TEST.Employee
SQL logic error
no such table: TEST.Employee

SynchronizationEditor.log

SELECT * FROM TEST.Employee VI.Base.ViException: Error running the following statement.

SELECT * FROM TEST.Employee---> System.Data.SQLite.SQLiteException: SQL logic error
no such table: TEST.Employee
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()

-Do you have any idea into what tables you want to synchronize?
Table Person in OI

Hi,

You say in your reply that it's RACF - there's a connector for that:  https://support.oneidentity.com/technical-documents/identity-manager/9.0%20lts/ldap-connector-for-ibm-racf-reference-guide

Based on the LDAP connector.

If it's really DB2 - there's a guide for that:  https://support.oneidentity.com/technical-documents/identity-manager/9.0%20lts/generic-database-connector-user-guide-for-connecting-db2--luw--databases

Those docs should hopefully guide you.

HTH, Barry.

Hi 
Thanks Barry 
If it's really DB2 - there's a guide for that:  https://support.oneidentity.com/technical-documents/identity-manager/9.0%20lts/generic-database-connector-user-guide-for-connecting-db2--luw--databases

It is not for DB2 z/OS Mainframe - it is for LUW type (DB2 for Linux, UNIX, and Windows)

DB2 z/OS uses RACF for permissions and previliges - it happens behind the scene