Adding 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 of the Administration Console, expand IQ Servers > Space Management and select DB Files.
3. Click the drop-down arrow that appears next to DB Files and select New.
4. On the DB Files page of the wizard, select the resource and the dbspace to which you are adding the DB file.
5. Click Add.
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.
   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). You can use this space to increase the file size if the file grows. Guideline: reserve size should be about 30% of file size.
   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 OK to add the file, then 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.