Is your retail POS system holding your business back? If you’re running on a legacy …
![]()
Cloud-native POS platform for seamless omnichannel customer experience.
![]()
A single hub for all promotions campaigns.
![]()
The most advanced synchronization solution for databases and file systems.
![]()
Data configuration and batch automation across different disparate systems and vendors.
Is your retail POS system holding your business back? If you’re running on a legacy …
Last week, I had the opportunity to be at EuroShop 2026 in Düsseldorf, Germany, the …
COLUMBUS, Ohio – November 5, 2025 – 54% of North American retailers surveyed say they …
Overview Organizations today face the challenge of consolidating data from on-premise and cloud-based systems into …
Single Sign-On with OAuth 2.0/OpenID Connect One of the many new features included in version …
The new release of SymmetricDS Pro 3.16 data replication software simplifies setup, improves performance, and …
Jumpmind Powers Point of Sale and Promotions Execution for Landmark Retail, One of the Largest …
Retail Technology Leader Jumpmind to Enable Mobile Point of Sale and Inventory Management for DTLR/VILLA …
The retailer is charting its next chapter with retail technology modernization to power inspired omnichannel …
Last week, I had the opportunity to be at EuroShop 2026 in Düsseldorf, Germany, the …
Digitally Connected Consumers Are Reinventing Brick & Mortar Retail: 53% of European Shoppers Now Use …
DTLR Brings New Point of Service Online to 200 Additional Stores in 24 Hours, with …
![]()
Cloud-native POS platform for seamless omnichannel customer experience.
![]()
A single hub for all promotions campaigns.
![]()
The most advanced synchronization solution for databases and file systems.
![]()
Data configuration and batch automation across different disparate systems and vendors.
DB2 for IBM i journal replication captures only the changes as they occur on the database and sends them to all targets using the SymmetricDS tool. Journal-based change capture creates less impact on the source database while still achieving a reliable replication use case.
If you do not already have journaling setup for your application tables this will need to be done prior to replication. See the SymmetricDS documentation for details.
DB2 for IBM i SymmetricDS Documentation
Grant USE authority to the journal and to all requested journal receivers.
Setup journal table images with the IMAGES(*BOTH) so that updates will contain old and new data. Without this changes to primary keys will not be replicated because the old ID is not provided in the journal and no update will be performed.
In order to capture changes in DB2 for IBM i, setup a SymmetricDS node as a source with the following values. Changes will need to be made to provide your proper credentials such as hostname, database name, user, and password.

After connecting to the DB2 for IBM i database, provide the journal name that contains the changes as well as the library this journal is located.

Connect a target database after completing the connection setup for the DB2 for IBM i source database. Next, select tables for replication using the add table wizard. Finally, perform an initial load to send the existing data from the DB2 for IBM i to the target systems.
For more details on setting up the target node and tables to replicate watch this introductory video: Setting up your first sync scenario