Viewing or Modifying DB File Properties

Display and change 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, select IQ Servers > Space Management > Db Files.
3. Select a db file from the right pane and either:
   • Click the arrow to the right of the name and select Properties, or
   • From the Administration Console menu bar, select Resource > Properties.
   The Db File Properties view appears.
4. View or modify the properties.
   • When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
   • If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.
   • The mode and status of the DB file determine which properties can be modified.

   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 (Read-only)	Location of the physical file or raw partition. You can modify the path only when the dbspace’s status is OFFLINE. You cannot change the path for DB files in the RLV store dbspace. 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 You cannot change the mode for DB files in the RLV store dbspace.
   File size (Read-only)	Current size of the file or raw partition. Use the Modify file size field to change the file size.
   Reserved size (Read-only)	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 (Read-only)	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 permissible file size is 130 MB. You can only change the file size for DB files in the RLV store dbspace when the dbspace is in Read/Write mode. You can only reduce the file size if the truncated space is not in use.
   Dbspace (Read-only)	Name of the dbspace.
   Status (Read-only)	Status of the dbspace: ONLINE OFFLINE

5. Click OK.