The DB2 Everyplace database and an application can be run directly from read-only media such as CD-ROMs or ROM chips in embedded devices. For example, a sample application of a quarterly product catalog might be distributed on a CD-ROM to sales representatives. Each quarter the sales representatives receive a CD-ROM containing the complete company product catalog and a DB2 Everyplace application to browse, display, and query product information for products meeting a customers specific needs. The DB2 Everyplace application would run directly from the CD-ROM without having to be installed on a workstation first.
When DB2 Everyplace detects that an application is running on read-only media (or that the files are write protected), it is set to read-only mode. In this mode, updates, inserts, deletes, create and drop statements are prohibited, and will return an error. Note that for some select queries DB2 Everyplace creates temporary tables and files. These are created in the default temporary directory. On Win32 platforms this directory is designated by the environment variable TEMP. If the TEMP environment variable does not exist, it might also be designated TMP. In Linux, the /tmp/ directory is used.
This feature is supported only on Win32 and Linux platforms.