Some systems limit either
the number of concurrent processes a user can own at one time. Some
systems limit the number of concurrent files a user can have open
at one time. If you are using an operating system that enforces one
or more of these limits, you should consider the following configuration
updates:
Number of Processes per Operating System User ID
SPD Server installation
requires eight concurrent processes. Furthermore, each SPD Server
User ID creates another process when the SPD Server client connects
to the SPD Server host. Therefore, the maximum number of processes
that SPD Server requires is the number of concurrent active SPD Server
users plus 8.
Number of Open Files per Process
During SPD Server queries,
all tables that the query requires are fully opened, including the
table metadata file, index files, and data partition files. Therefore,
the maximum number of open files would be as follows:SPD
Server Max Open Files per Process = [(1 + the maximum number of partitions
in a queried SPD Server table) + (2 * the maximum number of indexes
in a queried SPD Server table).
To calculate the maximum
number of open files per process for an SPD Server dynamic cluster,
the calculated number of open files per process for a single table
is multiplied by the number of members in the dynamic cluster table.
For queries that involve
more than one table, the maximum number of open files per process
is the sum of the open files for each table (or dynamic cluster member)
involved in the query. A general practice for SPD Server resource
management is to configure the number of SPD Server open files per
process that are available to the user who owns the SPD Server executables
to the system maximum value. If SPD Server reaches a system-imposed
limit for the number of processes per user, or number of open files
per user, the query fails and an error is printed to the SPD Server
log.