System-Supplied Databases

Caché provides the following databases:

CACHELIB — This is a read-only database that includes the object, data type, stream, and collection classes and many other class definitions. It also includes the system include files, generated INT code (for most classes), and generated OBJ code.
CACHESYS (the system manager’s database) — This database includes utilities and data related to system management. It is intended to contain specific custom code and data of yours and to preserve that code and data upon upgrades.
This database contains or can contain:
- Users, roles, and other security elements (both predefined items and ones that you add).
  For reasons of security, the Management Portal handles this data differently than other data; for example, you cannot display a table of users and their passwords.
- Data for use by the NLS (National Language Support) classes: number formats, the sort order of characters, and other such details. You can load additional data.
- Your own code and data. To ensure that these items are preserved upon upgrades, use the naming conventions in “Custom Items in CACHESYS,” later in this chapter.
Caution:

InterSystems does not support moving, replacing, or deleting this database.

The directory that contains this database is the system manager’s directory. The console log (cconsole.log) is written to this directory, as are other log files.
CACHE — Contains items such as cached SQL queries and CSP session information.

Note:

No customer application should directly interact with the CACHE database.
CACHEAUDIT — When you enable event logging, Caché writes the audit data to this database.
CACHETEMP — Caché uses this for temporary storage, and you can use it as well for the same purpose. This database is reinitialized each time the system restarts; see also the MaxCacheTempSizeAtStart CPF keyword. Note that this database is not journaled.
DOCBOOK — This database contains the documentation that the DocBook application serves up to viewers.
SAMPLES — This database contains code samples.
USER — This database is empty and is reserved for your use. Unlike the other databases, this database is entirely untouched by the installer, after the initial installation.

For additional detail on CACHESYS and SAMPLES, see the chapter “Assets and Resources” in the Caché Security Administration Guide.