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

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 
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 

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