IBM Db2 for i Connection Recommendations
When using Syniti Data Replication with IBM i/iSeries/AS400 systems, your user ID needs the authority to run the following commands:
-
DSPOBJD on the schema used for replication
and to access the following system tables:
- QSYS2.SYSTABLES
- QSYS2.SYSCOLUMNS
- QSYS2.SYSCST
- QSYS2.SYSKEYCST
- QSYS2.SYSKEYS
- QSYS2.SYSINDEXES
- QSYS2.SYSPARTITIONSTAT
- SYSIBM.SQLFOREIGNKEYS
Additionally, only if the system is used as source in mirroring or synchronization mode, the user ID needs access to:
-
DSPJRN (on the journals/receivers involved in replication)
-
DSPFD (on the tables involved in replication)
-
DSPFFD (on the tables involved in replication)
For synchronization, the user ID should be used exclusively for Syniti Data Replication so that transactions executed by Syniti DR can be easily identified in the journal.
