SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 14 / 271

• Minimum System Configuration: HP-PA 2.0 server system with minimum 2Gb
memory.
Kernel Tuning Requirements
The following kernel parameters are for HP-UX 11.11 and HP-UX 11.23. They need to be
adjusted on the HP server system where you will run SPD Server.
After you make these kernel parameter changes, be sure to reboot the system before you
attempt to use the SPD Server. In the following, MAX(a,b) means to take the maximum
of the values a or b.
•
dcb_max_pct = 10%
dcb_min_pct = 2%
max_thread_proc = 512
maxdsiz_64 = 1Gb + MAX(SORTSIZE, INDEX_SORTSIZE)
maxuprc = 4 + #concurrent SPD Server users
nproc = current nproc value + 4 + #concurrent SPD Server users
•
Note: SORTSIZE and INDEX_SORTSIZE are SPD Server parameters from the
spdsserv.parm file. Increasing these SPD Server parameters may require adjusting
the HP-UX kernel parameters accordingly. For more information on SPD Server
parameters consult the
“SPD Server UNIX Installation Guide ” on page 11
• Other HP-UX kernel parameters that may need to be increased depending on the way
you use the SPD Server include:
• ninode = Maximum open inodes in memory. Adjust for the maximum number of
concurrently open SPD tables multiplied by the maximum number of partitions in
an SPD Server table.
• nfile = System-wide open file limit. Adjust for the maximum number of
concurrently open SPD Server tables multiplied by the maximum number of
partitions in an SPD Server table.
• nflocks = System-wide file lock limit. Adjust for the maximum number of
concurrently open SPD Server tables.
• maxfiles_lim = Process hard limit for open files. Adjust for the maximum number
of concurrently open SPD Server tables multiplied by the maximum number of
partitions in an SPD Server table. The minimum recommended setting is 8192
Required Patches
The following HP-UX 11.23 for Itanium (IA-64) patches should be applied for SPD Server
4.4:
• PHCO_30543 s700_800 11.23 Pthread library cumulative patch
• PHCO_30531 s700_800 11.23 libc cumulative patch
• The HP September 2004 Base Patch Bundle for HP-UX 11.23
8
Chapter 2 • SPD Server Pre-Installation and System Requirements Guide