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

DB2 Everyplace requires an instance of DB2 UDB. If there isn't one on the machine, the software will install an embedded version of DB2. Similarly, the product requires a J2EE-compliant app server that supports the Servlet 2.0 API. If one is not available, the software will load an embedded version of WebSphere. I like this: You get a self-contained version of the product that is configured correctly and requires no additional software installation.

Data can be queried and verified on the local database using a set of command-line tools included with the client distributables. I ran the DB2 Control Center and used it to change the data in the central database, then forced an update of the client and verified that the changes had been made.

Insensitivity Training

New to this version of DB2 Everyplace is case-insensitive searching via SQL. This is a boon--case-sensitive searches require additional code to provide case-insensitivity.

Before you can fire up MDAC, the DB2 Applet Server must be running. This is one of the drawbacks of the product--you need to start it manually whenever the machine restarts, or create an init script to kick it off.