IBM Db2 LUW Topics
Syniti Data Replication supports use of IBM Db2 LUW for:
- Refresh replications, both source and target
- Mirroring replications, both source and target. For source connections, Syniti Data Replication offers the transaction log and triggers
- Synchronization
For mirroring replications using the transaction log, set up your IBM Db2 LUW environment as follows:
-
DBADM or SYSADM Login ID.
-
Db2 Log settings as follows:
LOGRETAIN: Recovery
LOGARCHMETH1:LOGRETAIN or DISK -
Copy file from <InstallDir>/ServerFiles/Db2UDB to
<Db2 Home Directory>/function on Db2 server. -
Rename copied file to Db2udbreadlog02.dll (Db2udbreadlog02 for LINUX/AIX)
For mirroring replications using triggers, set up your IBM Db2 LUW environment as follows:
-
Use Db2 UDB v. 7.2 or higher
-
Obtain Package creation privileges for the first connection (DBMS tools)
-
Set security mechanism in Syniti Data Replication ( Management Center)
This section contains topics that describe:
- IBM Db2 LUW Connection Requirements
- IBM Db2 LUW Transactional Replication Settings (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog)
- Using the Ritmo/DB2 .NET Provider
- Customizing Character Data by Overriding the CCSID Setting
Further Resources
- For a complete up-to-date list of supported sources and targets, and information on where to obtain a .NET provider, check the Supported .NET Providers article in the Help Center.
- The Help Center also provides database-specific setup notes in PDF format.