Changing the Readonly/Readwrite Status of a Cache Dbspace Dbfile

Change a single dbfile in the cache dbspace to read-only or read-write status.

Prerequisites
Task
  1. Connect to a simplex or multiplex node.
  2. Change a dbfile to read-only or read-write using the ALTER DBSPACE statement:
    • Change the cache dbspace dbfile to read-only:
      ALTER DBSPACE myDAS ALTER FILE iqdas2 READONLY
    • Change the cache dbspace dbfile to read-write:
      ALTER DBSPACE myDAS ALTER FILE iqdas2 READWRITE
Parent topic: Cache Dbspace for Direct-Attached Storage