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

Change Dbspace Status

Read syntax diagramSkip visual syntax diagramChange Dbspace Status Clause:

|--+-dbspace_name-+--+-ONLINE--+--------------------------------|
   '-dbspace_id---'  '-OFFLINE-'

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

Usage

Use the onutil ALTER DBSPACE command to force a non-critical dbspace online or offline.

Keyword
Description
ONLINE
Brings the dbspace online.
OFFLINE
Takes the dbspace offline.

Bringing a Dbspace On-line

When bringing a dbspace online using the onutil ALTER DBSPACE command it is important to note data consistency issues that may arise. The server cannot know whether the space is internally consistent or synchronized with other dbspaces in the instance, unless a successful physical and logical restore of the offline dbspace has been performed. Therefore, when forcing a down dbspace back online, it is the administrator's responsibility to verify the integrity of the space.

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