Previous Topic: Changing the Area StatusNext Topic: Purging Database Buffers


Changing the File Status

The OPEN, OPEN UPDATE, and CLOSE options are useful to force opening or closing files of the specified area. By using these options you can change the status of all the files with one command. The CLOSE option is allowed only when the area status is OFFLINE or TRANSIENT RETRIEVAL.

Dynamic File Deallocation

In order to deallocate an area, it and any areas contained in the same files must be offline.