Modifying a DB File

Modify the name, mode, and path properties of a DB file.

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. In the right pane, select a DB file to modify.
4. Click the drop-down arrow that appears next to the DB file name and select Properties.
   Note: If the DB file is read-only in a read-write dbspace, Empty File is enabled on the menu.
5. Change property values:

   Property	Description
   Name	Logical file name. If the dbspace is in Read Only mode and OFFLINE status, you cannot change the name of the DB file.
   Path	Location of the physical file or raw partition. You can modify the path only when the dbspace’s status is OFFLINE. 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.
   Mode	Mode of the dbspace: Read Only Read/Write Force Read/Write
   File size	Current size of the file or raw partition. Use the Modify file size field to change the file size.
   Reserved size	Reserved space in the dbspace that you can add to this DB file. Use the Modify file size field to transfer space between the reserved size and the file size.
   Total size	Current size of the file plus the size of the reserved space.
   Modify file size	Enter a new value for file size. You cannot increase the file size by more than the reserved size. For example, if the file size is 100 MB and the reserve is 30 MB, the maximum file size is 130 MB.
   Dbspace	Name of the dbspace.
   Status	Status of the dbspace: ONLINE OFFLINE

6. Click OK.