Modifying a DB File

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

Prerequisites
Space Admin authority is required.
Task

The mode and status of the DB file determine which properties can be modified.

  1. In the Perspective Resources view, highlight the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console view, select IQ Servers > Space Management > DB Files.
  3. In the DB Files view, highlight the DB file to modify.
  4. Hover the mouse pointer over the DB file and click the arrow.
    Note: If the DB file is read-only in a read-write dbspace, Empty File is enabled on the menu.
  5. Select Properties.

    Property

    Description

    Name

    Logical file name.

    Path

    Location of the physical file or raw partition.

    Mode

    Mode of the dbspace:
    • ReadWrite
    • ReadOnly

    File size

    Current size of the file or raw partition in kilobytes (KB) or megabytes (MB).

    Reserved size

    Reserved space that can be added to this file in the dbspace.

    Total size

    Current size of the file plus the size of the reserved space.

    Modify file size

    New value for file size.

    Dbspace

    Name of the dbspace.

    Status

    Status of the dbspace:
    • ONLINE
    • OFFLINE
  6. In the DB file view, change the value of the property.
    Note:

    You can change the Name and Mode of a DB file, regardless of the Status value.

    If the dbspace Status is OFFLINE, you can change the DB file Path.

    If the dbspace is ReadOnly mode and OFFLINE status, you can change the Path of the DB file, but you cannot change the Name of the DB file.

    You cannot change DB file size attributes from the Properties dialog.

  7. Click OK.
Related tasks
Viewing DB File Properties
Adding a DB File
Emptying a DB File
Deleting a DB File
Generating DB File DDL Commands