Home | Previous Page | Next Page   Utility Reference > onutil: Check, Define, and Modify Storage Objects > ALTER DBSPACE >

Toggling The Read Mode of a dbspace

Read syntax diagramSkip visual syntax diagramToggle Read Mode Clause:

|--+-dbspace_name-+--+-STATIC------+----------------------------|
   '-dbspace_id---'  '-OPERATIONAL-'

Element Purpose Restrictions Syntax
dbspace_name The dbspace name Must be a non-critical, non-temp dbspace See Identifiers in onutil Commands.
dbspace_id The dbspace number Must be a non-critical, non-temp dbspace See Identifiers in onutil Commands.

Usage

Use the onutil ALTER DBSPACE command to turn on/off the read-only mode of a dbspace.

Keyword
Description
STATIC
Turns on read-only mode
Note:
You can only use the STATIC keyword if the database server is in quiescent mode. It is recommended to back up the dbspace using onbar immediately after it is altered to STATIC mode. For more information, see IBM Informix: Backup and Restore Guide.
OPERATIONAL
Turns off read-only mode

You can determine the read-only status of a dbspace using the onstat -d command.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]