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, expand IQ Servers > Space Management, and then select 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 you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
   • If you do not have privileges to modify properties, SAP 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: ReadOnly ReadWrite Force ReadWrite You cannot change the mode for DB files in the RLV store dbspace. For DB Files in the Cache dbspace, you can only change the mode if the dbspace is ONLINE.
   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. Do one of:
   
   • Click OK to update any changes to the database and exit the properties view.
   • Click Apply to update any changes to the database, but remain in the properties view.
   • Click Cancel to cancel any changes not updated to the database and exit the properties view.