IBM DB2 for i Topics

Syniti Data Replication supports use of IBM Db2 for i for:

• Refresh replications, both source and target
• Mirroring replications, both source and target. For source connections, Syniti Data Replicationoffers the use of the transaction log/journal, and the Log Server Agent
• Synchronization

When setting up IBM DB2 for i for use with Syniti Data Replication:

• Set user ID authorities appropriately (DBMS tools)

• Make sure tables are journaled and receivers are set up appropriately (DBMS tools)

• Create a library on Db2 (Management Center)

This section contains topics that describe:

• IBM Db2 for i Transactional Replication Settings (in the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog)
• IBM Db2 for i Journal Information (in the Create Replication wizard and Create Multiple Replications wizard Source Log Info screen)
• IBM Db2 for i Connection Recommendations
• Creating the Db2 Library Manually
• Journals and Receivers
• Customizing Character Data by Overriding the CCSID Setting
• Replicating from Multi-Member Tables
• Setting the CCSID for Tables and Columns
• Synchronization Limitation with IBM Db2 for i
• Using a Relative Record Number to Identify a Record
• Using the Ritmo/i .NET Provider
• Writing a Script to Determine Receiver Use

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.