Interstage Shunsaku Data Manager Operator's Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

D.4.3 Memory Requirements for Sorters

This section explains the formulas for estimating how much memory sorters will use.

Shared Memory

The shared memory requirement is shown below.

Definition unit	Variable elements	Size (byte)
The area for storing command information	Fixed	1,000,000

Local Memory

The formulas for estimating local memory are shown below.

Definition unit	Variable elements	Size (byte)
Fixed	None	5,000,000
Threads per request	The maximum number of sort or aggregation requests that can be received at the same time (*1)	1,000,000 x the maximum number of sort or aggregation requests that can be received at the same time
Memory for sort calculation	The maximum number of sort or aggregation requests that can be received at the same time (*1)	30,000,000 x the maximum number of sort or aggregation requests that can be received at the same time
Memory for storing reply data	Average reply data size The maximum number of sort or aggregation requests that can be received at the same time (*1)	Average reply data size x 1,000 x the maximum number of sort or aggregation requests that can be received at the same time

*1) This is specified in the MultiMax parameter in the sorter environment file.

Example Calculation

An example calculation for local memory is shown below.

If the variable elements are as follows:

• The maximum number of sort or aggregation requests that can be received at the same time: 20
• Average reply data size: 4,000 (bytes)

Threads per Request

1,000,000 x 20 = 20,000,000 bytes (approx. 20 MB)

Memory for Sort Calculation

30,000,000 x 20 = 600,000,000 bytes (approx. 600 MB)

Memory for Storing Reply Data

4,000 x 1,000 x 20 = 80,000,000 bytes (approx. 80 MB)