Provides powerful data subsetting capability, supports join predicates or subselects allowing you to distribute data efficiently from normalized databases Provides sophisticated data transformation using standard SQL, including multi-table joins and stored procedures, thus maximizing the value of your data warehouse and business intelligence systems Provides an easy interface to define replication scenarios (including data sources, targets, frequency and timing of replication events, pre- and post-change processing).

This enables centralized and consistent database management. Replicates data between central database and regional transactional databases, making business data available to regional databases for prompt transaction processing Component of DB2 Universal Database providing heterogeneous replication functions via DB2 Information Integrator Replication Edition. Separately orderable tool or feature in the z/OS (OS/390), z/VM, VSE, and OS/400 environments.