DEFAULTAWSEGSIZE
The DEFAULTAWSEGSIZE option holds the default maximum segment size for an analytic workspace created in your Database session. The setting is in effect for the duration of your session. For each new session, DEFAULTAWSEGSIZE reverts to the default value.
Tip:
To change the maximum size for new segments in an existing workspace, use the AW command with the SEGMENTSIZE keyword. To discover the current maximum size for new segments, use the AW function with the SEGMENTSIZE keyword.
Syntax
DEFAULTAWSEGSIZE = n
Parameters
- n
-
The number of bytes.
Examples
Example 5-22 Displaying the Maximum Segment Size for a Session
The following statement lists the current maximum segment size for workspaces.
SHOW DEFAULTAWSIZE
Example 5-23 Setting the Maximum Segment Size for a Session
The following statement sets the maximum segment size to approximately 1/2 gigabyte.
DEFAULTAWSIZE = 536870910
