Creating a Local Database

Creating a Local Database

To create a local database:

1. Navigate to the Local Databases page (System Administration > Configuration > System Configuration > Local Databases).

2. Click Create New Database to open the Database Wizard.

3. Enter a database name in the text box. A database name must not already be in use within the InterSystems IRIS instance; also see Rules for Database Names.

4. The first time you create a local database in an InterSystems IRIS instance using a particular browser, you must either

   • Enter the name of the database directory, in which case this directory, containing the IRIS.DAT file, is created in c:\InterSystems\mgr once you confirm it.

   • Click the folder icon to browse to an existing directory, in which case the IRIS.DAT file is created in that directory.

   Thereafter, by default a directory of the same name as the database name you provide, containing the IRIS.DAT file, is created in the same location as the previous database directory. For example, if you first create database db22 in any directory under c:\InterSystems\mgr, when you click Create New Database again and enter db33 in the Enter the name of your database box, c:\InterSystems\mgr\db33 is automatically filled into the Database directory text box. If you change this to c:\InterSystems\db33 and create db33, the base directory c:\InterSystems will be filled in the next time.

   Note:

   InterSystems does not support the use of symbolic links when configuring database directories.

5. Click Next to continue configuring the database. If a IRIS.DAT file already exists in the directory you specified, you are warned of this and can either

   • Click Finish to use the existing file, in which case all of the databases characteristics are determined by the IRIS.DAT file. You would typically do this when copying or moving a database from another instance, or temporarily mounting a database created in another instance on the same system.

   • Click Back to specify another directory, then click Next again to continue specifying the characteristics of the new database in the next step.

6. In the Initial Size text box, type the number of megabytes for your database size (the default is 1 MB).

   Note:

   You cannot create or edit a database so that its size is larger than the total available disk space. If the size you specify is within 90% of the disk's free space, you are warned and must confirm the action.

7. Select the desired block size from the Block size for this database will be drop-down list. By default, all new databases are created with a Block Size of 8 KB.

   Caution:

   Do not select block sizes other than 8 KB from the drop-down list unless you have read and understand the guidelines described in Large Block Size Considerations.

8. If you require a multivolume database, change the value of New volume threshold size to a number greater than 0, then choose the radio button for TB, GB, or MB units. When IRIS.DAT reaches this size, a new database volume will be created. For more information see Multivolume Databases.

9. Select whether or not you want to journal globals in this database from the Journal globals? drop-down list. See Journaling.

   Note:

   If you are configuring the database to store temporary globals, setting the Journal globals property to No is not the same as storing the temporary globals in IRISTEMP; for more information, see Using Temporary Globals and IRISTEMP.

10. If encryption is activated, you can encrypt this database by selecting Yes for Encrypt Database?.

11. If the instance is part of a mirror, you can add this database to the mirror by selecting Yes for Mirrored Database?. See Add Databases to the Mirror for information about creating mirrored databases.

12. From this panel onward, you can click Next. to continue configuring the database or Finish to accept the remaining defaults

13. Choose the resource to control access to this database:

    • Default — %DB_%DEFAULT

    • Existing — Choose from a list of existing database resources

    • New — Create a new database resource (the new name defaults to %DB_% database name)

14. Click Next to view a list of the database attributes.

15. Click Finish to add your database.

You are now ready to configure and manage your new database.