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