Skip to main content



The ^DATABASE routine is used to manage databases; it also allows you to set values related to Caché security.

  1. Create a database

    Allows you to create a new database.

  2. Edit a database

    Allows you to change the characteristics of an existing database, for example, by adding additional volumes.

  3. List databases

    Displays the characteristics of one or more databases.

  4. Delete a database

    Allows you to delete a Caché database. This action is irreversible.

  5. Mount a database

    Makes a database ready for use by Caché. Databases must be mounted to Caché in order to be usable. Databases can be set to be automatically mounted at startup.


    You can use the Mount a database option to mount any CACHE.DAT file accessible to the instance by specifying the directory containing it. However, if you do this with a database that was deleted from, or was never added to, the Management Portal database configuration (see Configuring Databases in the “Configuring Caché” chapter of the Caché System Administration Guide), the database is not added to the Management Portal configuration and is therefore unavailable for portal database operations and for some routines, for example ^Integrity (see Checking Database Integrity Using the ^Integrity Utility in the “Introduction to Data Integrity” chapter of the Caché Data Integrity Guide).

  6. Dismount a database

    Permits you to quiesce a database and remove it from use by Caché.

  7. Compact globals in a database

    Reorganizes the data inside CACHE.DAT. Note that this option does not reduce the size of the database file; to reduce the size of the database, see option 13.

  8. Show free space for a database

    Displays the available space for a database. This is calculated as the difference between its current contents and its current declared size.

  9. Show details for a database

    Displays detailed information on a specified database including location, size, status, and other controlling parameters.

  10. Recreate a database

    Creates a new, empty database with the parameters of the original database. The new database is the same size as the original database.

  11. Manage database encryption

    Removes all the logical data from a database while preserving the properties of the database for reuse.

  12. Return unused space for a database

    Frees either a specified amount of or all available extra space associated with a database, reducing it from its current size to its smallest possible size.

  13. Compact freespace in a database

    Specifies the desired amount of freespace (unused space) that is in a database after the end of the database's data. You can also eliminate this freespace using the Return unused space for a database option (#12).

  14. Defragment globals in a database

    Defragments a database, which organizes its data more efficiently. Defragmentation may leave freespace in a database (see options #12 and #13).

FeedbackOpens in a new tab