MINPARTSIZE= Parameter File Option

Specifies the minimum partition size for SPD Server tables.

Valid in: spdsserv.parm parameter file
Default: 16M
Syntax
Required Argument
Details

Syntax

MINPARTSIZE=n | nK | nM | nG;

Required Argument

n

specifies a number that indicates the amount of memory in terms of bytes (1), kilobytes (1,024 bytes), megabytes (1,048,576 bytes), or gigabytes (1,073,741,824 bytes).

Details

Use MINPARTSIZE= to ensure that large server tables cannot be created with an arbitrarily small partition size. Large server tables with small partition sizes create an excessive number of physical files, which increases clutter and degrades I/O performance. The default MINPARTSIZE= value is 16 MB, unless you are creating tables in a Hadoop domain. If you are using a Hadoop domain, the minimum MINPARTSIZE= is 128 MB.
The most common values for MINPARTSIZE= are in the range 128 MB–256 MB.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017