Physical retail is still where the magic happens. According to new research by RSR, 85% …
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.
Physical retail is still where the magic happens. According to new research by RSR, 85% …
Beyond the Hype: What Retailers Really Want from Tech in 2025 Europe’s biggest retail conference …
What a fun week it was for women from across the country who came together …
The new release of SymmetricDS Pro 3.16 data replication software simplifies setup, improves performance, and …
Sybase ASE (more recently known as SAP Adaptive Server Enterprise), announced its end of mainstream …
Azure Blob Storage has become a popular option for storing files in the cloud. 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 …
43 percent say handling online order returns in-store is a top challenge, and that increases …
After nearly a century in business, the legendary Canadian fashion retailer is retooling to streamline …
The Solution Addresses Modern Retail Challenges with Innovative Promotions to Captivate Inflation-Weary Shoppers NRF 2024, …
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