DB2 Everyplace

DB2 Everyplace is the next-generation of mobile data stores. It provides a full enterprise synchronization solution to integrate enterprise and mobile information — from any location or source, at any time, right in the palm of your hand with broad mobile and embedded device platform support.

DB2 Everyplace shortens development time by allowing invisible/zero administration, and supporting open standards which eases integration with existing enterprise applications. It makes operations more efficient because the small footprint (approximately 350 KB) relational database able to handle tens of thousands of records. DB2 Everyplace has advanced conflict detection and resolution when synchronizing with a JDBC-compliant database such as DB2, IDS, Oracle, or Microsoft™ SQL Server.

DB2 Everyplace Sync Server

Synchronize data and applications between DB2 Everyplace client devices and enterprise data sources using the DB2 Everyplace Sync Server and DB2 Everyplace Sync Client. Data synchronization can be bi-directional or uni-directional. Data can be updated at the DB2 Everyplace mobile device or the enterprise database.

For example, users could download a subset of data from a DB2 for z/OS database to a DB2 Everyplace database on the mobile device, view the data, make changes to the data, and then synchronize the changed data back to the z/OS server. The synchronization server also provides a mechanism for conflict resolution.

Key Features include:

• Advanced synchronization features such as conf lict resolution and data partitioning

• Compression and encryption of data for faster, secure data synchronization

• Enterprise Edition Only: High availability and load-balancing configurations using IBM WebSphere Application Server groups

• Enterprise Edition Only: Easy set-up and administration of large numbers of users and user groups, as well as data access, either online, remotely or through scripting

• Synchronization of clients with multiple relational data sources and on demand downloading of files and applications

DB2 Everyplace Sync Client

The DB2 Everyplace Sync Client, which runs on mobile devices, is comprised of applications that work with the DB2 Everyplace Sync Server. It handles bi-directional synchronization of enterprise relational data with the DB2 Everyplace database on the device. Sync Client also manages operations related to file subscriptions for easy distribution of mobile applications to the device and can execute stored procedures stored on a DB2 UDB database. In addition, Sync Client can synchronize personal information such as E-mail and address books with enterprise messaging servers. For Palm OS® devices, the personal information is stored in native databases and can be manipulated by native Palm OS applications.

DB2 Everyplace Database

The SQL statements supported by DB2 Everyplace database enable you to create or drop a table or index, and delete, insert, or update rows of a table.

Key Features:

• Optimized for SAP Mobile Applications

• 200KB-footprint database with zero administration required

• Industry-leading indexing and query performance with advanced database and structured query language (SQL) functionality

• Table-level local data encryption in the database and secure data synchronization architecture