Display Tablespace

View details about a tablespace. Tablespaces are applicable only to aggregate storage databases. Permission required: Application Manager. This statement requires the application to be started.

Syntax

Syntax diagram for display tablespace (aggregate storage).TABLSP-NAME

Example

set column_width 50; /* so file_location will not be truncated */
display tablespace ASOSamp.'default';

This example displays the following output:

Column HeaderContents
file_locationC:\Hyperion\products\Essbase\EssbaseServer\APP\
max_file_size56
max_disk_size4294967295