Creating a DB File

Add a DB file to a dbspace.

1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
2. In the left pane, expand IQ Servers > Space Management, and then select DB Files.
3. Click the arrow next to DB Files and select New.
   Tip: You can also create a DB File from Dbspace Properties > DB Files page > Folder > New.
   The Create DB File wizard appears.
4. On the DB Files page, select the resource and the dbspace to which you are adding the DB file.
   If the resource is a multiplex, the Multiplex node dropdown appears.
   1. Select the node containing the dbspace to which you are adding the DB file.
   2. Select the dbspace.
   Note: For cache dbspaces, each node shows only the cache dbspace that resides on it. For main store dbspaces, all dbspaces show regardless of which multiplex node is selected.
5. Click Add.
   Note: DB files can only be added to the RLV store dbspace when it is online. The RLV dbspace can either be in ReadOnly or ReadWrite mode, however files can only be added in ReadWrite mode when there are no RLV-enabled objects.

   Note: For a cache dbspace, you can add multiple DB Files to a multiplex node, but only one file at a time. For a cache dbspace on a simplex, you can add multiple DB files at once.
6. On the DB File Details page, specify:

   Option	Description
   Logical name	User-defined name of the DB file.
   Path to physical file on disk	Path to the physical file on disk. It is usually best to use an absolute path. A relative path works for simplex servers and for multiplexes that use the SCC shared-disk facility and have the SCC installation directory mounted in the same location on each multiplex server host. If you specify a relative path for a simplex that is later converted to a multiplex, the relative path might cause an error.
   Raw device	A check mark indicates the file is on a raw device. Cache dbspaces normally use raw device files.
   File size	Space you allocate to the DB file in kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB). Unavailable on raw devices; required if the file is not on a raw device. Minimum file size is 8 MB.
   Reserve size	(Optional; default is 0.) Extra space you allocate to the DB File in kilobytes (KB), megabytes (MB), gigabytes (GB), or terabytes (TB). Default is 0. You can use this space to increase the file size if the file grows. Guideline: reserve size should be about 30% of file size. Note: Not applicable to cache dbspace.
   Mode	(Optional) Read Only Read/Write Force Read/Write Note: This option appears only if you are adding DB files to the IQ_SHARED_TEMP dbspace in a multiplex setup.

7. Click Finish.

Create a Dbspace File Size in Use alert to warn you if the DB file exceeds a set percentage of the configured file size (70%, for example). If the alert is activated, you can increase the file size. To enable this alert, first schedule a data collection that includes its key performance indicator, such as the Dbspace File Statistics Collection or All Stats w/o Availability.