Network Computing is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them. Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Sneak Preview: IBM's DB2 Everyplace 8.1.4: Page 4 of 5

MDAC isn't pretty, but it does what's needed. Every aspect of synchronization, including user and group creation, subscription management and synchronization-schedule management--is controlled from this console. Groups are assigned subscription sets, consisting of one or more subscriptions. A subscription describes the data source (tables), operations allowed (delete, insert, select, update) and encryption settings. The source data can come from any supported database.

Access Denied!

Users can have data filters applied to their subscriptions to limit the data synchronized. I specified synchronization based on the "CITY" field within a subscription for a user, so that he received contact records only for Green Bay. Such filters decrease the time and bandwidth necessary for data synchronization, and can help reduce the size of the local database. Filters also can be used as a security mechanism. They can be configured on a group or subscription basis, affecting all users assigned to that group or subscription.

You can view logs for replication and synchronization within MDAC, and filter them by time stamp, user name, subscription, database source or other value. MDAC can distribute files and apps to mobile devices automatically, as well as upgrade client-synchronization and DB2 database software without user intervention.

With its wide relational database and client OS support, DB2 Everyplace offers a single replication and synchronization solution that should be able to support most, if not all, of your mobile-client needs.