Alter Tablespace (Aggregate Storage)

To see a list of tablespaces, use display tablespace. You cannot change the location or size of the metadata and log tablespaces.

Tablespaces are applicable only to aggregate storage cubes.

Permission required: Application Manager.

Syntax

Description of the illustration alttabl.gif

Use alter tablespace to edit tablespaces in the following ways:

Keywords

add file_location

Add a new file location to the tablespace.

Note:

FILE-NAME is case sensitive in this statement.

alter file_location

Change the maximum file-size or disk-size value for the specified file location.

Note:

FILE-NAME is case sensitive in this statement.

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.

Note:

Some operating system platforms may enforce a maximum file size limit.

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.

Note:

FILE-NAME is case sensitive in this statement.

Notes

This statement requires the application to be started.
On Windows, you can specify tablespace file locations using Uniform Naming Convention (UNC) syntax, which is \\ComputerName\SharedFolder\Resource. Including the escape characters required by MaxL Shell, the UNC file name specification would look like the following:

'\\\\ComputerName\\SharedFolder\\Resource'

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.

alter tablespace ASOsamp.'default' alter file_location '\\\\ComputerName\\SharedFolder\\Resource' set max_file_size 50mb;

Changes the maximum file size allowed in the specified location of the default tablespace. The file_location string is specified using UNC.