|
Scalable Performance Data Server
Note this document pertains only to SPD Server 3.0. For system requirements pertaining to SPD Server 4.0 and above, consult the Installation section of the System Administrator's Guide that accompanies the product.Table of Contents:
AIX Requirements and Tuning for 32-bit SPD Server AIX Requirements and Tuning for 32-bit SPD ServerSystem RequirementsRequired OS level: 4.3.3 or 5.1A (Note: Critical threading problems which affect data integrity were found in release 5.1.) Minimum System Configuration: RS/6000 system with minimum 256 Mb memory Kernel Tuning RequirementsPlease note that the following kernel parameters need to be adjusted on the RS/6000 system where you will run SPD Server. You must have root access to make these changes. In order to persist these changes across a system reboot, you will need to follow IBM recommendations for running the tuning commands at system startup time. /usr/samples/kernel/vmtune -R 64 -R 64 sets the read-ahead page threshold to 64 pages. AIX Requirements and Tuning for 64-bit SPD ServerSystem RequirementsRequired OS level: 4.3.3 or 5.1A (Note: Critical threading problems which affect data integrity were found in release 5.1.) Minimum System Configuration: RS/6000 system with minimum 256 Mb memory Kernel Tuning RequirementsPlease note that the following kernel parameters need to be adjusted on the RS/6000 system where you will run SPD Server. You must have root access to make these changes. In order to persist these changes across a system reboot, you will need to follow IBM recommendations for running the tuning commands at system startup time. /usr/samples/kernel/vmtune -R 64 -R 64 sets the read-ahead page threshold to 64 pages. DIGITAL UNIX Requirements & TuningSystem RequirementsRequired OS level: 4.0F Minimum System Configuration: AlphaServer system with minimum 256 Mb memory Kernel Tuning RequirementsPlease note that the following kernel parameters need to be adjusted on the AlphaServer system where you will run SPD Server. You must have root access to make these changes via the sysconfig(/sbin/sysconfig) utility. After you make these kernel parameter changes, be sure to reboot the AlphaServer system before you attempt to use the SPD Server. In the following discussion, MAX(a,b) means to take the maximum of the values a or b. /sbin/sysconfiq -q vm vm-maxvas =1G + MAX(SORTSIZE, INDEX_SORTSIZE) vm-mapentries = 200 + 25 * #concurrent SAS/SPD Server jobs vm-vpagemax = 131072 or larger
/sbin/sysconfig -q proc max-per-proc-address-space = same as vm_maxvas per-proc-address-space = same as max-per-proc-address-space max-per-proc-data-size = same as max-per-proc-address-space per-proc-data-size = same as max-per-proc-data-size max-proc-per-user = 5 + #concurrent SPD Server jobs max-threads-per-user = #concurrent SPD Server jobs * MAXWHTHREADS Note: SORTSIZE, INDEX_SORTSIZE, MAXWHTHREADS are SPD Server parameters from the spdserv.parm file. Increasing these SPD Server parameters may require adjusting the AlphaServer kernel parameters accordingly. For more information on SPD Server parameters consult the Scalable Performance Data Server Installation Guide(install-unix.html). Warning: If gh-chunks parameter is set on the AlphaServer system, it is a good indication that an RDBMS is installed on the same AlphaServer system. It may not be possible to set optimum kernel parameters to run both the RDBMS and SPD Server on this system. HP-UX Requirements & Tuning for 32-bit SPD ServerSystem RequirementsRequired OS level: HP-UX 11.0 Note: You must apply the latest generation HP-UX patch for libc that contains the patch PHCO_15768 or later. Minimum System Configuration: HP server system with minimum 256 Mb memory Kernel Tuning RequirementsPlease note that the following kernel parameters need to be adjusted on the HP server system where you will run SPD Server. You must have root access to make these changes via the sam utility(/usr/sbin/sam). After you make these kernel parameter changes, be sure to reboot the system before you attempt to use the SPD Server. dcb_max_pct = 10% dcb_min_pct = 2% max_thread_proc = 512 maxdsiz = 128Mb maxuprc = 4 + #concurrent SPD Server users nproc = current nproc value + 4 + #concurrent SPD Server users Other HP-UX kernel parameters that may need to be increased depending on the way you use the SPD Server include:
HP-UX Requirements & Tuning for 64-bit SPD ServerSystem RequirementsRequired OS level: HP-UX 11.0 64-bit OS Note: You must apply the latest generation HP-UX patch for libc that contains the patch PHCO_15768 or later. Minimum System Configuration: HP-PA 2.0 server system with minimum 2Gb memory Kernel Tuning RequirementsPlease note that the following kernel parameters need to be adjusted on the HP server system where you will run SPD Server. You must have root access to make these changes via the sam utility(/usr/sbin/sam). 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 spdserv.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 Scalable Performance Data Server Installation Guide(install-unix.html). Other HP-UX kernel parameters that may need to be increased depending on the way you use the SPD Server include:
Solaris Requirements and Tuning for 32-bit SPD ServerSystem RequirementsRequired OS level: Solaris 2.4 or greater Minimum System Configuration: Sun SPARC or UltraSPARC system with minimum 256 Mb memory Solaris Requirements and Tuning for 64-bit SPD ServerSystem RequirementsRequired OS level: Solaris 2.7 or greater Minimum System Configuration: Sun UltraSPARC system with minimum 2Gb memory Windows NT Requirements and Tuning for 32-bit SPD ServerSystem RequirementsRequired OS level: Windows NT 4.0 Service pack 3 or greater Minimum System Configuration: NT server system Client requirements for SPD ServerSystem RequirementsRequired SAS level: SPD Server 3.0 requires SAS 8.1
Additional information about clients to allow SPD Server 3.0 communicate with different versions of SAS can be found at: |
