^DATABASE
^DATABASE
The ^DATABASE routine is used to manage databases; it also allows you to set values related to Caché security.
-
Create a database
Allows you to create a new database.
-
Edit a database
Allows you to change the characteristics of an existing database, for example, by adding additional volumes.
-
List databases
Displays the characteristics of one or more databases.
-
Delete a database
Allows you to delete a Caché database. This action is irreversible.
-
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.
Note: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).
-
Dismount a database
Permits you to quiesce a database and remove it from use by Caché.
-
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.
-
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.
-
Show details for a database
Displays detailed information on a specified database including location, size, status, and other controlling parameters.
-
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.
-
Manage database encryption
Removes all the logical data from a database while preserving the properties of the database for reuse.
-
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.
-
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).
-
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).