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 2 of 5

DB2 Everyplace's synchronization is managed using the centralized MDAC (Mobile Device Administration Center), which gives DB2 Everyplace a small client footprint. For development, IBM provides client libraries for supported OSs--including Linux, Palm OS, Windows CE/ Pocket PC, Win32, Symbian and Embedded Linux. The product's usefulness out of the box is limited: You'll need to write apps for the database to take advantage of the sync server. Because only the necessary APIs are implemented for the target device, it's easy to develop apps for mobile devices. DES 56 or 128 is available for secure communications with the synchronization server, and table-level encryption--as opposed to the database-only encryption offered by some mobile-sync products--is used. For larger databases on the client, DB2 Everyplace supports microdrives and Flash memory.

Data synchronization to mobile devices is not restricted to IBM relational databases: DB2 Everyplace supports IBM DB2 UDB8 (Universal Database), Cloudscape, Informix, Lotus Domino, Microsoft SQL Server, Oracle and Sybase.

Wanted: Beefy Server

DB2 Everyplace 8.1.4 requires at least a Pentium III with 512 MB of RAM (1 GB is recommended if you're using WebSphere as the application server). Although the server appeared to run fine on a machine with only 256 MB of RAM in my tests at our Green Bay, Wis., labs, running the Java administrative tools was painful.

For a Linux installation, you'll need to do a little work, including manipulating kernel parameters. The changes, which can be made with sysctl, include increasing file-handle maximums, shared memory and thread maximums. You'll also need to export your display if you aren't running X on the server. I did the install locally within X and administration remotely on a laptop running Mandrake Linux 9.1. Both methods worked well.