Extend and Unextend a Database
You can extend a database to use additional data and work locations. Locations must exist prior to this operation and must be specified with a Usage Type of database or work.
To extend a database, use the extenddb command or the Alter Database dialog in Director or VDBA. For details on the extenddb command, see the Command Reference Guide.
For example, this command extends the stockdb database to use the directory /disk1/loc1 as new data and work areas:
extenddb -lextraloc1 stockdb -a/disk1/loc1 -Udata,work
After extending to another data location, create new tables and indexes in the extended location, and modify existing tables and indexes to use the extended location. For details on creating and moving tables, see the chapter “Managing Tables and Views.”
When you extend to a new work location, the system spreads the workload between the initial location (specified at create time) and the extensions.
Unextending a database reverses the extend operation and deletes the entry from the configuration files so the location can be used again.
Note: After unextending a database location, you should checkpoint the database. Previous checkpoints cannot be used because they reference a location that is no longer accessible to the database.
To unextend a database, use either the unextenddb command or the Alter Database dialog in VDBA. For additional information, see the Command Reference Guide and online help, respectively.
Last modified date: 01/30/2023