Is it possible to synchronize tables on DB2 for z/OS ?
- Products
- Solutions
- Resources
- Trials
- Support
- Partners
- Communities
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