SQL Reference Guide > SQL Reference Guide > SQL Statements > ALTER LOCATION
Was this helpful?
ALTER LOCATION
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The ALTER LOCATION statement changes the type of files that can be created at an existing location.
Current usage of the location is unaffected, but future attempts to extend a database to the target extension are constrained by the new usage setting.
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.
Embedded Usage
In an embedded ALTER LOCATION statement, the usage portion of the WITH clause can be specified using a host string variable. The preprocessor does not validate the WITH clause.
Permissions
You must have the MAINTAIN_LOCATIONS privilege and be connected to the iidbdb.
Locking
The ALTER LOCATION statement locks pages in the iilocation_info system catalog.
Related Statements
CREATE LOCATION
DROP LOCATION
Last modified date: 08/28/2024