The DB2 Everyplace solution has the following key features and components:
This database resides on the mobile device. The mobile database is included with DB2 Everyplace Database Edition, DB2 Everyplace Enterprise Edition, and DB2 Everyplace Software Development Kit. Another component associated with the mobile database is:
The DB2 Everyplace mobile database is available for:
DB2 Everyplace also supports MIDP mobile devices that use the MIDP database.
DB2 Everyplace Sync Server is included with DB2 Everyplace Enterprise Edition. Other important components that are associated with the Sync Server include:
You can synchronize data and applications between DB2 Everyplace mobile 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 DB2 Everyplace Sync Server also provides a mechanism for conflict resolution.
The DB2 Everyplace Sync Server provides an administration tool that helps you manage and deliver synchronization services to groups of users with similar data synchronization needs. More information about the Mobile Devices Administration Center is available in the Sync Server Administration Guide.
DB2 Everyplace Sync Server supports synchronizing relational data with any data source that has a JDBC interface, such as DB2 Universal Database.
DB2 Everyplace Sync Server supports synchronizing relational data with the following data sources:
The DB2 Everyplace Sync Client is included with DB2 Everyplace Enterprise Edition.
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 mobile database on the mobile device. The mobile device 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 database.
The Sync Client is available for the following operating systems:
The DB2 Everyplace Mobile Application Builder is included with the Software Development Kit and is also downloadable from the IBM Web site.
You can use the DB2 Everyplace Mobile Application Builder to develop DB2 Everyplace applications for Palm OS, WinCE, Symbian OS, and other platforms that support a user interface and a Java Virtual Machine. With the Mobile Application Builder, you can build applications without writing a single line of code. For information on how to get the Mobile Application Builder, visit the DB2 Everyplace Web site.
Other development tools include WebSphere Studio Device Developer, Visual Age Micro Edition, Metrowerks CodeWarrior, and the GNU Software Developer's Kit.
The sample applications provide an example of an application using DB2 Everyplace. You can use the Visiting Nurse sample application to quickly test bi-directional synchronization between the mobile database and the Sync Server. The sample applications has two parts, one that runs on the Sync Server and another that runs on the mobile database. This mobile database sample application demonstrates the database engine functionality in stand-alone environment. When the Sync Server sample application and the database engine sample application are used together, they work as a complete application that invokes all components of the DB2 Everyplace.
The IBM Sync is also a sample application which demonstrates how to use the DB2 Everyplace Sync Client API to synchronize tables of the subscriptions defined in MDAC.
The Command Line Processor is an application development tool provided as an example application using DB2 Everyplace on platforms with a command line interface. The Command Line Processor is used for the DB2 Everyplace database on mobile devices. It is not used by the Sync Server.
The SQL statements supported by DB2 Everyplace enable you to create and drop a table and index, and delete, insert, and update the rows of a table.