Storing virtual data in an extspace
An extspace lies outside the disk storage that is configured for the database server. To create a physical extspace, you might use an operating system command or use a data management software system.
An extspace can have a location other than a path or file name because the database server does not interpret the location. Only the access method uses the location information.
To store virtual data in an extspace, take one of the following actions:
- Create logical names for existing external storage with the onspaces utility. Then, specify the reserved name or names when you create a virtual table with the CREATE TABLE statement.
- Directly specify an existing physical external storage location as a quoted string in the CREATE TABLE statement.
- Provide a default physical external storage location, such as a disk file, in the access-method code.