================================= MACHINE SPECIFIC NOTES FOR Informix Dynamic Server 7.31.UD2 PRODUCT RELEASE DATE: 25 Aug 2001 ================================= Informix Dynamic Server Shared Memory Parameters and Kernel Parameters: ========================================================================== ==== The following entries were used for testing: STREAMS Parameters: STRTHRESH 0 Semaphore Parameters: SEMMAP 500 SEMMNI 1000 SEMMNS 1200 SEMMNU 100 SEMMSL 100 SEMOPM 20 SEMUME 20 SEMMNI parameter: ---------------- The number of semaphore ids in the system needs to be configured much higher due to a performance change. For this SEMMNI parameter must be equal to at least the number of users + the number of cpuvps + some extra for overhead. Shared Memory Parameters: SHMMAX: 536870192 SHMMIN: 1 SHMMNI: 100 SHMSEG: 64 Resource Limit Parameters: SFNOLIM 0x400 HFNOLIM 0x400 SDATLIM 0x7FFFFFFF HDATLIM 0x7FFFFFFF SVMMLIM 0x7FFFFFFF HVMMLIM 0x7FFFFFFF LOCATION OF SHARED MEMORY: ========================= The ONCONFIG variable SHMBASE should be set to the following : 0x20000000 Machine Specific Notes: ======================= 1. This product was built on Reliant Unix 5.43 C2003 2. The following protocol(s)/interface(s) are supported on this platform: TLI using TCP/IP SOCKETS using TCP/IP IPC using stream pipe IPC using shared memory To use TLI with TCP/IP, NETTYPE in the ONCONFIG file & the nettype field in the sqlhosts file entry must contain "ontlitcp". To use SOCKETS with TCP/IP, NETTYPE in the ONCONFIG file & the nettype field in the sqlhosts file entry must contain "onsoctcp". To use IPC (interprocess communications) with stream pipe, NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must contain "onipcstr". To use IPC (interprocess communications) with shared memory, NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must contain "onipcshm". In some applications, soctcp showed better performance compared to tlitcp 3. TERMINFO is supported on this port. 4. Kernel AIO is supported by this release. KAIO is enabled by default. To disable KAIO, set the environment variable KAIOOFF. KAIOOFF=1; export KAIOOFF (for Bourne or Korn Shell) setenv KAIOOFF 1 (for C Shell) 5. The Affinity feature that allows the pinning of a CPU VP process to a processor in a multi-cpu configuration is supported on this port. This feature can be activated through the two onconfig parameters of AFF_SPROC and AFF_NPROCS. 6. The no aging feature that disables priority aging of CPU virtual processors by the operating system is supported on this platform. This feature can be activated throught the onconfig parameter NOAGE. 7. The OnPerf performance monitoring capability is supported on this platform. 8. The DB/Cockpit DBA monitoring tool is not supported on this platform. 9. The onpload and ipload tools are supported. They require a minimum of 35M of memory and 70M of swap space in order to run. User-defined conversion routines must be provided in a dynamic, shared library called ipldd07a.so. This library must be located in /usr/lib (or must have a link provided in /usr/lib). Onpload will use shared memory during its execution. It will allocate memory beyond the address for the server, leaving room for server shared memory expansion. The machine must have been installed with the C++ runtime library package CDS++RTS in order to run ipload. If ipload can't find the location of the X and Motif shared libraries installed, the environmental variable LD_LIBRARY_PATH may need to be set to include these locations. 10. The OnSNMP feature is supported in this release. 11. The Operating System Audit feature is supported in this release. Configuring the Operating System Audit Subsystem on SNI Platforms: The objective of this section is to specify how to configure the OS audit subsytem to hold the INFORMIX-OnLine audit records in the OS audit trail. In order to support this feature of INFORMIX-OnLine, you need to install t! Auditing Utilities package (V2.x) on your system. To open a new OS audit trail file, use auditpro -record To stop the audit process, use auditpro -stop The OS audit subsystem uses an intermediate buffer to hold the audit records. However, these records are flushed to the OS audit trail file when the buffer becomes full. Due to the buffering mechanism, INFORMIX-OnLine audit records may not be visible as and when they are generated (provided you are using OS managed INFORMIX-OnLine auditing). If this is undesireable, you can execute the following command to bypass buffering. auditlog -v 0 Refer to the AUDIT V2.x (Reliant UNIX) Manual for more information on configuration and operation of the audit package. To select which INFORMIX-OnLine events are to be audited, specify audit masks using the "onaudit" utility. To extract INFORMIX-OnLine audit records from the Operating System audit trail, use "onshowaudit -O" command. Refer to the INFORMIX-OnLine Trusted Facility Manual (TFM) for further details. 12. Set value of kernel parameter SEMMSL to at least 100. The maximum number of semaphores per set is typically given by the SEMMSL operating system configuration parameter. Look into section on "Configuring Semaphore Parameters" in Informix Dynamic Server Migration guide for details. 13. Set value of kernel parameter SEMMNU to at least the maximum number of open ipcshm connection, plus the number of semaphore undo structures required by other processes in the system. (eg. set semsys:seminfo_semmnu=4096) 14. Enterprise Data Replication (CDR) is supported in this release. 15. Unlike other Informix products, the Informix Language Supplement CD should be mounted without the -o dos switch. 16. Informix Storage Manager (ISM 2.0) is supported in this release. The devices that are currently supported are 4mm drive (model MC23) 8mm drive 5GB (model MC10) dlt 5000 optical (we tested only the behaviour, not against specific optical devices) 17. IECC ServerAgent is NOT supported for this release on this platform. Because of this, only the following Tools within IECC Win NT/95 Client can be used against the 7.31.UC2 server. ISM Administrator Enterprise Replication SQL Editor For more information on how to configure and use these Tools please refer to IECC Tools section within IECC Users Guide. Be sure to also refer to IECC Client Release Notes. 18. The UNIX graphical tools provided with this release for onperf and ipload require X Windows System X11R5 and Motif 1.2.4 runtime libraries. 19. Installing, checking and removing of this product is done by using the pkgadd and pkgrm commands for installing and removing products.. 20. The performance can be increased by doing a binding interrupts 1) To bind all interrupts on a specific CPU (and make sure you do NOT bind CPU VP on that CPU): edit /etc/default/boot file as root, to add a line like BOOTP2=dint_active=0 which binds all io+network interrupts to CPU#0 This example assumes you have already BOOTP0 and BOOTP1 set (typically - root,swap) reboot the system for this to take effect. 2) In addition, if you want to include information about shared memory (data) big page feature, you need to add these additional lines: BOOTP3=segshm=1 BOOTP4=segshm_askmem=4224 where 4224 is in MB (size reserved for data big pages, not managed by VM), 64MB aligned. 21. DCE/CSM is not supported on this platform due to operating system limitations. This implementation requires re-entrant system libraries provided through the DCE package which would introduce a dependancy on this package and would degrade the server performance. DCE package is not part of the default operating sytem. 22. Profile Based Optimization (PBO) has been disabled in this release due to persistent conflicts with CDR.