Syntax
The ALTER LOCATION statement has the following format:
[EXEC SQL] ALTER LOCATION location_name
WITH USAGE = (usage_type {, usage_type}) | NOUSAGE
location name
Specifies the name of an existing disk and directory combination.
usage_type
Specifies the types of file that can be stored at this location. Valid values are:
DATABASE
WORK
JOURNAL
CHECKPOINT
DUMP
ALL
NOUSAGE
Prevents any files from being stored at the location.