Change details about a tablespace. Tablespaces are applicable only to aggregate storage databases. To see a list of tablespaces, use display tablespace. You cannot change the location or size of the metadata and log tablespaces.
Permission required: Application Manager. This statement requires the application to be started.
Syntax
Use alter tablespace to edit tablespaces in the following ways:
Keyword | Description | ||
---|---|---|---|
add file_location | Add a new file location to the tablespace.
| ||
alter file_location | Change the maximum file-size or disk-size value for the specified file location.
| ||
set max_file_size | Specify a value for the maximum size that a data file may attain before Essbase creates a new file. The largest possible value that the aggregate storage kernel can handle is 134217727 MB. This is also the default value. If operating system limits take effect before this value is reached, the kernel creates a new file. If you enter a value that is larger than 134217727 MB, the kernel ignores the setting and caps file size at 134217727 MB. The minimum value is 8MB (8388608b), and any values you enter are rounded up to the next 8MB interval. | ||
set max_disk_size | Specify the value for the maximum amount of disk space to be allocated to the file location. The largest possible value that the aggregate storage kernel can handle is 4294967295 MB. This is also the default value. If operating system limits take effect before this value is reached, the kernel attempts to use another file location in the tablespace. If you enter a value that is larger than 4294967295 MB, the kernel ignores the setting and caps disk size at 4294967295 MB. The minimum value is 8MB (8388608b), and any values you enter are rounded up to the next 8MB interval. | ||
drop file_location | Delete the specified file location from the tablespace. When a file location is deleted, all files in the file location are deleted, as well as the subdirectory containing the files. You cannot delete a file location if it contains data. You cannot delete the tablespace itself.
|
Example
alter tablespace asosamp.'default' add file_location 'C:\\mytablespace' set max_file_size 50mb;
Adds another file location for the default tablespace. Now the tablespace default is in C:\mytablespace in addition to the original location, C:\Hyperion\products\Essbase\EssbaseServer\app.
alter tablespace asosamp.'default' alter file_location 'C:\\Hyperion\\products\\Essbase\\EssbaseServer\\' set max_file_size 50mb;
Changes the maximum file size allowed in the specified location of the default tablespace. Note that the file_location string is case sensitive.