================================= MACHINE SPECIFIC NOTES FOR Informix Dynamic Server 7.30.UC2 PRODUCT RELEASE DATE: 15 Jul 1998 ================================= PORT NUMBER: 013473 (TAPE CARTRIDGE), 013493 (8MM CASSETTE), 013513 (DAT CARTRIDGE), 013533 (CD ROM) IRIS JOB NUMBER: 15173 Informix Dynamic Server Shared Memory Parameters and Kernel Parameters: ============================================================================== The following entries were put in the kernel configuration file while doing the port. SHMMAX: 768000000 Kernel Parameters used for testing: =================================== The following kernel parameter settings were used during the port. They are included here for information only, and should NOT be used as recommendations or guidelines for customer systems. PERCENTLOCKABLE 90 NPROC 8192 MAXUP 8192 SDESLIM 2048 HDESLIM 2048 MAXSLICE 100000 NOLANGUISHING 0 NOILEVEL 1 AOD_ENABLE 0 MAXBUFAGE 60000 NQUEUE 1000000 NSTREVENT 4096 SEMMNI 4096 MSGTQL 4096 MSGMNB 4000000 MSGMAX 8192 NFS USERLOCKLIMIT 10240 USE_LONG_FM 1 LOCATION OF SHARED MEMORY: ========================= SHMBASE: 0x20000000 Machine Specific Notes: ======================= 1. The following protocol(s)/interface(s) are supported for this platform: TLI using TCP/IP TLI using IPX/SPX IPC using stream pipe To use TLI with TCP/IP, NETTYPE in the ONCONFIG file & the nettype field in the sqlhosts file entry must contain "ontlitcp". To use TLI with IPX/SPX, NETTYPE in the ONCONFIG file & the nettype field in the sqlhosts file entry must contain "ontlispx". To use IPC with stream pipe, NETTYPE in ONCONFIG file and the nettype field in the sqlhosts file entry must contain "onipcstr". 2. The "onarchive" feature is supported with the following tape drives on this platform: QIC cartridge tape drives 4mm DAT tape drives 8mm tape drives (requires kernel parameter "USE_LONG_FM 1") DLT tape drives 3. Kernel AIO is supported on this platform. 4. The Affinity feature that allows the pinning of a CPU vp process to a processor in a multi-cpu configuration is supported on this platform. This feature can be activated through the two onconfig parameters AFF_SPROC and AFF_NPROCS. This feature will not work if the kernel parameter INITCPUMASK is set. 5. The no aging feature that disables priority aging of CPU virtual processors by the operating system is not supported on this platform. Therefore, the NOAGE onconfig parameter should be set to 0. 6. TERMINFO is not supported on this platform. 7. The OnPerf performance monitoring capability is supported on this platform. OnPerf has been successfully tested under DG/UX R4.20 with X11R5 and Motif 1.2.4. When using onperf, a /tmp/prf file will be created for each cpu on the machine. These files can be removed after onperf is no longer running on the machine. 8. The DB/Cockpit DBA monitoring tool is not available on this platform. 9. C2 OS auditing is not supported on this platform because C2 OS auditing is not supported on standard DG/UX. 10. The High Performance Loader is supported. Onpload and Ipload were tested on DG/UX R4.20 using X11R5 and Motif 1.2.4. They require a minimum of 35Meg of memory and 70Meg 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. 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. 11. OnSNMP is supported on this platform. For DG/UX, OnSNMP is based on SNMP Research's EMANATE product, release 12.3. The distribution includes the following: bin/onsnmp The OnSNMP subagent. bin/onsrvapd The daemon which spawns off a subagent for each server it discovers. snmp/*V1.mib SNMP V1 compliant MIB files defining the instrumentation provided with OnSNMP. snmp/*V2.mib SNMP V2 compliant MIB files defining the instrumentation provided with OnSNMP. bin/snmpdm The SNMP Research's EMANATE master agent. Refer to the documentation notes that accompany the onsnmp product for more details. snmp/snmpr/snmpd.cnf Configuration files that are used by the EMANATE master agent. The distribution also includes: snmp/snmpr/onmibinfo.dat DG/UX has the SNMP Research EMANATE master agent as part of the base operating system release as /usr/bin/snmpd and this is the master agent you should use. As such it is using configuration files in /etc and /etc/srconf. To add OnSNMP to the configuration for snmpd update /etc/snmpinfo.dat by performing the following. cd /etc cp snmpinfo.dat snmpinfo.dat.save cd $(INFORMIXDIR)/snmp/snmpr postmosy -merge onmibinfo.dat 12. Enterprise Replication (ER - formerly CDR) is supported in this release. 13. Stack tracing is supported on this port. The function arguments list will show 3 arguments no matter how many arguments the function really has. 14. This port requires DG/UX R4.20 MU02 or later operating system revision. 15. Shared memory residency: Informix 7.30 internally uses the DG/UX system call mlock(3C) to lock down its 'RESIDENT' segment in response to a RESIDENT = 1 setting in the ONCONFIG file, or in response to a 'onmode -r' request. In order to be allowed to lock down the 'RESIDENT' segment, the kernel configuration parameter PERCENTLOCKABLE may have to be explicitly set and the kernel rebuilt. The total amount of configured memory (defaults to the physical memory on the machine, but may be changed by the MEMCONF parameter in the kernel) multiplied by PERCENTLOCKABLE (default to 10%) must be large enough to accommodate the 'RESIDENT' segment. If not, the attempt by Informix will fail, and the message "forced-resident shared memory not available" from oninit or "onmode: residency option unavailable" from onmode will be given. 16. Maximum size of a shared memory segment allocated by Online Dynamic Server is 2 GB on DG/UX R4.20 MU02. This may be limited by actual memory available and/or kernel configuration. 17. Some of the functions called by OnBAR are in a shared library supplied by third party storage management vendors. For OnBAR to access the functions, the library must be installed in one of the three ways noted below. 1. Rename the library to /usr/lib/ibsad001.so. 2. Create /usr/lib/ibsad001.so as a symbolic link to the library. 3. Set the BAR_BSALIB_PATH paramter in $INFORMIXDIR/etc/$ONCONFIG to the full pathname of the library. Please contact Data General for available storage managers. 18. In this release, partition profiling can be disabled by setting the configuration parameter, TBLSPACE_STATS, to 0 in the onconfig file. When TBLSPACE_STATS is set to 0, the output of onstat -g ppf will read "Partition profiles disabled". Disabling the partition profiling will result in fewer cache invalidations and less bus traffic due to fewer updates to the partition structure in the shared memory. This feature benefits especially the NUMA systems, since disabling partition profiling will reduce intra-quad memory updates. By default, the value of this parameter is 1 (collection of partition statistics enabled). 19. Informix Storage Manager (ISM) is not supported on this platform. 20. Informix Enterprise Command Center (IECC) support 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.30 server. 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. 21. CSS/CSM is not supported in this release. 22. Bugs fixed in this release: Bug 64430 GCORE MECHANISM NOT PRODUCING CORE FILE CORRECTLY DURING EXCEPTION CONDITION SHUTDOWN OF ONLINE ENGINE