I spent this week at eTail Boston, and if you looked at the agenda, you’d …
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
A comprehensive solution designed to simplify and give you ownership of the inventory lifecycle.
A native post-transaction reconciliation module built into Jumpmind Commerce.
- Omnichannel ExperienceCreate seamless customer experiences
- Device IndependencePOS agnostic to form factor or operating system
- Self-CheckoutDo more with fewer associates
- Mobile StoreLeverage POS from anywhere
- POS on the GoEnable associates to sell outside of the store
- Unified PromotionsStreamline and simplify promotion workflows
- CX ConnectAllow customers to engage with POS during checkout
- Composable CommerceCreate the store experience you want
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
-
Data Replication
- Multi-tier DistributionReplicate thousands of remote locations
- Cloud Database ReplicationCapture live changes from on-premise to the cloud
- High Availability and Load BalancingEnsure 24/7 access to data and scale efficiently with demand
- Analytics and ReportingCapture the whole picture with real-time reporting
- Multi-masterMaintain consistency of data in a peer to peer setup
- Data WarehouseReplicate live and historical data to a warehouse
- MigrationsConduct live data migration with no downtime
-
-
Data Integration
- Master Data ManagementChanges propagate across the entire system, allowing you to maintain a centralized view of all parts of your core business entities.
- Application IntegrationReduce dependencies, complexity, and risk to build a high-performance, data-driven application.
- Web ServicesIntegrate multiple systems using web services or build a business application using a service-oriented architecture.
- Data WarehouseIntegrate disparate data from multiple systems so you can transform data for better business intelligence and reporting.
- Data MigrationConduct live data migration during critical server replacements, storage upgrades, and data center relocations—with no downtime.
- ImplementationIntegration consultants help design, develop, and deploy an implementation of our products.
- DevelopmentThe product developers can add features, enhance existing functionality or build support for new platforms.
- TrainingEngage our experienced training resources to gain in-house knowledge and expertise on Jumpmind products.
- SupportLeverage product engineers to resolve issues, fix defects and provide updates or patches.
- Proof of ConceptDetermine the feasibility of implementing our products and get answers to your questions quickly.
Recent Posts
Consumers are expected to spend more than $146 billion on back-to-school shopping this year, and …
Shoptalk Europe wrapped up in Barcelona last week and I want to get a few …
View all Blog Posts
Recent Posts
We built 3.18 because the question we kept hearing from customers changed. It used to …
Quick answer: Edge AI agents running on technician laptops, warehouse devices, or hospital workstations need …
Everyone is talking about what AI will do for their business. Very few people are …
View all Blog Posts
Recent Posts
Introduction In retail, POS updates have traditionally been quarterly events at best. From October through …
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 …
View all Customer Stories
Recent Posts
We built 3.18 because the question we kept hearing from customers changed. It used to …
The offering gives security teams a practical path to risk management and accountable AI COLUMBUS …
The insights have implications for retail technology in the store: it must help mind information …
View all Blog Posts
Retail Products
Cloud-native POS platform for seamless omnichannel customer experience.
A single hub for all promotions campaigns.
A comprehensive solution designed to simplify and give you ownership of the inventory lifecycle.
A native post-transaction reconciliation module built into Jumpmind Commerce.
Retail Use Cases
Retail Services
Data Products
The most advanced synchronization solution for databases and file systems.
Data configuration and batch automation across different disparate systems and vendors.
Data Use Cases
-
Data Replication
-
-
Data Integration
Data Services
About
Blog Topics
-
Retail Retail trends, technology, and enhancing the customer experience
-
Data Thoughts on data matters, dialects, performance, and security
-
Customer Stories How Jumpmind impacts the businesses of our clients
-
Videos & Webinars Watch on demand demos, reviews, and tours of our products
-
Company News Get the scoop on Jumpmind's growth and impact
View all Blog Posts
Replicate DB2 for IBM i with Journal-Based Change Capture
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.
Popular Use Cases
- Cross Platform – Move data to a relational database such as Postgres, SQL Server, Oracle, MySQL and more.
- Data Warehouse – Setup a new data warehouse or data lake in the cloud.
- Analytics – Move data to one of the many cloud based platforms dedicated to analytics and reporting.
DB2 for IBM i Journal Setup
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
DB2 for IBM i Journal Permissions
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.
SymmetricDS Setup to Replicate DB2 for IBM i
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
