Read-only and Read-write Dbspaces and Files

A file is read-only when either the file status is read-only or the file status is read-write, but the owning dbspace status is read-only.

Altering a dbspace to read-only does not alter the catalog status of its associated files to read-only, but does make the associated files read-only at the operating system level. In other words, the file’s catalog read-only or read-write status remains the same, but data in the file cannot be modified.

• Status of Dbspaces and Associated Files
  A dbspace and its associated files can have individual read-only (RO) or read-write (RW) status, for example:
• Allowed Dbspace Transformations
  Your ability to change a dbspace configuration depends on the type of alter operation and certain attributes of the dbspace. Alter operations are governed by the state of the dbspace (online or offline), the read-write status of the dbspace, and the type of dbspace.