PARTSIZE= Table Option

Specifies the size of the SPD Server data partition file.

Valid in:	SPD Server
Valid in:	DATA step and PROC step
Default:	128 megabytes
Range:	16 to 8,796,093,022,207 megabytes
Restriction:	Specify a data partition file size only when creating a new table.
Interaction:	The PARTSIZE= table option overrides the SPDSIZE= macro variable. For more information, see SPDSSIZE= Macro Variable.
Tip:	When you update data, a smaller partition size provides the best performance. For example, when you update a value, SPD Server locates the appropriate partition, modifies the value, and rewrites all replications of the partition. Because each update requires that the partition be rewritten, it is recommended that you perform updates only occasionally or set a small partition size if you are planning to update the data frequently.

Syntax

Required Argument

Details

Example

Syntax

PARTSIZE=n

Required Argument

n

is the size of the data partition file in megabytes.

Details

Each partition is stored as a separate file with the file extension .dpf. Depending on the amount of data and the partition size, the data can consist of one or more physical files, but is referenced as one logical file.

The PARTSIZE= specification is limited by the MINPARTSIZE= parameter file option. The MINPARTSIZE= parameter file option specifies the minimum data partition size. MINPARTSIZE= ensures that a SAS user does not create small partitions, thereby generating a large number of physical files. The default for MINPARTSIZE= is 128 megabytes.

For a Hadoop domain, the value of PARTSIZE= must be larger than the greater of the value declared for MINPARTSIZE= or 128 megabytes, in order to have any effect.

Example

proc sql;
   create table spdscen.hr80spds (partsize=250)
      .
      .
      .;
quit;