InformixLink TechInfo Center - Machine Specific Notes
Machine Specific Notes

UNIX
7.20.UC2 UNIX Servers Products





                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
                   INFORMIX-OnLine 7.20.UC2 PRODUCT RELEASE
                               DATE: 17 Jun 1996
                      =================================

PORT NUMBER: 024718(8MM CASSETTE) 024721(DAT CARTRIDGE) 024724(TAPE CARTRIDGE) 024737(CD ROM)
IRIS JOB NUMBER: 7563

INFORMIX-OnLine Dynamic Server Shared Memory and Kernel Parameters:
==================================================================

SHMMAX:	268435456 (256 MB)
SHMMIN:	1
SHMALL:	Not Applicable
SHMMNI:	4096
SHMSEG:	Not Applicable
SHMBRK:	Not Applicable
MAXMEM:	Not Applicable
SEMMNI:	Not Applicable
SEMMNS:	Not Applicable
SEMMSL:	Not Applicable
NFILES:	Not Applicable

LOCATION OF SHARED MEMORY:
=========================

The ONCONFIG variable SHMBASE should be set to the following

SHMBASE	0x30000000L

Machine Specific Notes:
=======================
  1. The Informix 7.2 Servers and Connectivity(SCT) products require that the drivers for a) Portable Streams Environment (PSE) and b) Asynchronous IO (AIO) be loaded on the AIX system on which the Informix 7.2 SCT products are used. The Informix 7.2 SCT executables use entry points defined by these drivers. Portable Streams Environment (PSE) may be loaded using /usr/sbin/strload command and Asynchronous IO (AIO) device may be enabled (loaded) using either the 'smit' interface or using the command /usr/sbin/mkdev -l aio0. For further information consult AIX documentation.
  2. The UNIX graphical tools provided with this release requires X Windows System X11R5 and Motif 1.2.3 or later runtime libraries.
  3. The thread safe ESQL/C libraries require DCE 2.1 for AIX installed. Currently thread safe ESQL/C is supported with static libraries only. Please make sure to set the THREADLIB environment variable to dce. For example, in case of Korn shell: export THREADLIB=dce To build thread safe ESQL/C programs, use following command: esql -static -thread prog.ec -o prog At present, this feature is supported for the online engine and the following protocol only: Berkeley sockets using TCP/IP NOTE: ---- Applications that have not been compiled with the -thread option cannot be linked with applications that have been compiled with the -thread option. To do so, compile all applications with the -thread option.
  4. The Network Protocols/Interfaces supported for this platform are: a. Berkeley sockets using TCP/IP To use this protocol, the NETTYPE must be set to "onsoctcp" in the ONCONFIG and sqlhosts configuration files. The network protocol/interface TLI using SPX/IPX is not supported in this release.
  5. OnArchive tape drives/tape drivers: OnArchive has been tested and is supported on this platform only with 8mm tape drives. The tape device needs to be configured to have block size of 512 and to use extended file marks. OnArchive MAX_SPACE qualifier should be set to a minimum value of 256 on this platform.
  6. TERMINFO is not supported on this platform.
  7. The Affinity feature(ONCONFIG variables AFF_SPROC, AFF_NPROCS) that allows the pinning of CPU VPs to physical processors in a multi-cpu configuration is not supported in this release. On AIX 4.1.3, the bindprocessor command can be used to bind the specific CPU VP to a processor on IBM SMP platforms. The process id for CPU VPs can be obtained using 'onstat -g sch' command.
  8. The OnPerf performance monitoring capability is supported on this platform.
  9. The DB/Cockpit DBA monitoring tool is supported in this release.
  10. Kernel AIO is supported on this platform.
  11. Some operating systems lower the priority of processes as the processes age. NOAGE (ONCONFIG variable) which controls priority aging is supported on this platform. a) If NOAGE is set to 1, the CPU VPs are set to a fixed default priority of 65. b) To override the default priority value for CPU VP class set the following environment variable (as shown below for sh/ksh) in the range of 50 to 90. The recommended range of priority value is 60 to 90. Example, for Korn shell, export INFX_CPUVP_PRIORITY=nnn The server checks and sets the CPU VP process to the defined priority if the defined value is within the above range.
  12. C2 Operating System Audit is supported in this release. This section gives the necessary configuration changes to the OS audit subsystem in order for Informix-OnLine audit records to be recorded in the system audit log. a. The OS audit subsystem must be operational, and auditing enabled. b. A new event INFORMIX_DBMS must be introduced to the audit subsystem. c. INFORMIX_DBMS event must be added in a relevant class definition. d. The auditing must be configured for binary or stream mode. To receive Informix-OnLine audit data, the operating system audit subsystem must be configured to accept events of the type INFORMIX_DBMS. The event type INFORMIX_DBMS must be introduced to the OS, by inserting a line defining this event in the file /etc/security/audit/events. (Please pay careful attention to the format, even of the comments, because they are parsed by the auditselect and perhaps by other audit library functions at runtime.) Lines extracted from /etc/security/audit/events: * INFORMIX audit events INFORMIX_DBMS = printf "%s" Lines extracted from /etc/security/audit/config: classes: infx = INFORMIX_DBMS users: root = infx Important files in configuring OS audit subsystem: /etc/security/audit/events, config, bincmds, streamcmds After configuring the system, enable auditing with the new configuration. Refer to the Operating system documentation on how to accomplish this. The OS auditing must be enabled for all users that might use the OnLine product, and for the event type INFORMIX_DBMS, of the relevant class. Please see the man pages for "audit", "auditpr", "auditselect" and other related commands for details on configuring auditing on the system. To select which INFORMIX-OnLine events are to be audited, specify audit masks using the "onaudit" utility. Refer to the INFORMIX-OnLine Trusted Facility Manual (TFM) for further details. To extract audit records from operating system audit trail files, "auditselect" and "auditpr" utilities can be used. To extract INFORMIX-OnLine records use "onshowaudit -O" which is configured to use /audit/trail by default. If the system is configured to use a different audit file, use "onshowaudit" utility with -f option to specify the required audit file. For e.g., to use /etc/security/audit/trail file, specify: onshowaudit -O -f "/etc/security/audit/trail".
  13. Shared Memory Residency feature is not supported on this platform.
  14. High Performance Loader (HPL) is supported on this platform. The HPL utilities onpload and ipload utilities require a minimum of 35MB of memory and 70MB of swap space in order to run. Currently onpload utility is linked with archive libraries only and does not support custom drivers feature.
  15. It is found that Informix definition of loc_t clashes with AIX definition of loc_t (in the system header file sys/localedef31.h). To use Informix definition, please compile your application with _H_LOCALEDEF flag set.

================================= MACHINE SPECIFIC NOTES FOR INFORMIX-ESQL/C 7.20.UC2 PRODUCT RELEASE DATE: 17 Jun 1996 ================================= PORT NUMBER: 024718(8MM CASSETTE) 024721(DAT CARTRIDGE) 024724(TAPE CARTRIDGE) 024737(CD ROM) IRIS JOB NUMBER: 7563 Machine Specific Notes: =======================
  1. ESQL/C libraries are now supported as both static and shared libraries. The 'esql' script uses the shared or static libraries depending on "-shared" or "-static" option. To use shared library, invoke esql -shared and to use static library, invoke esql -static If no option is specified then, by default, shared library is used. During execution of ESQL/C program compiled with shared library, the environment variable LIBPATH may need to be set to include the $INFORMIXDIR/lib, $INFORMIXDIR/lib/esql directories (where ESQL/C shared libraries are installed). For example, for C Shell, use: setenv LIBPATH $INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LIBPATH or for Bourne Shell, use: LIBPATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$LIBPATH export LIBPATH ESQL/C applications using previous versions of Informix ESQL/C libraries may need to be recompiled and/or relinked to work with this version of product.
  2. The thread safe ESQL/C libraries require DCE 2.1 for AIX installed. Currently thread safe ESQL/C is supported with static libraries only. Please make sure to set the THREADLIB environment variable to dce. For example export THREADLIB=dce /* ksh */ To build thread safe ESQL/C programs, use following command: esql -static -thread prog.ec -o prog At present, this feature is supported for the online engine and the following protocol only: Berkeley sockets using TCP/IP NOTE: ---- Applications that have not been compiled with the -thread option cannot be linked with applications that have been compiled with the -thread option. To do so, compile all applications with the -thread option.
  3. Support for Version 2.1 of CICS for AIX is provided through the shared object $INFORMIXDIR/lib/esql/libcicsshr.o. For additional information see IBM's documentation: - CICS for AIX Administration Guide - The Program Directory for CICS for AIX - The PSP (Preventive Service Plan) for CICS for AIX from IBM Service

================================= MACHINE SPECIFIC NOTES FOR INFORMIX-ESQL/COBOL 7.20.UC2 PRODUCT RELEASE DATE: 17 Jun 1996 =================================
    PORT NUMBER: 024718(8MM CASSETTE) 024721(DAT CARTRIDGE) 024724(TAPE CARTRIDGE) 024737(CD ROM) IRIS JOB NUMBER: 7563 Machine Specific Notes: =======================
  1. Currently MicroFocus Cobol for AIX 4.x does not support shared libraries. Therefore Informix ESQL/COBOL-MF2 libraries are supported as static only. The 'makerun' and 'esqlcobol' must be invoked with the "-static" option.
  2. ESQL/COBOL-RM85 is not supported on AIX 4.1.x due to problems with the AIX curses library (bug # 48503).

================================= MACHINE SPECIFIC NOTES FOR C-ISAM 7.20.UC2 PRODUCT RELEASE DATE: 17 Jun 1996 ================================= PORT NUMBER: 024718(8MM CASSETTE) 024721(DAT CARTRIDGE) 024724(TAPE CARTRIDGE) 024737(CD ROM) IRIS JOB NUMBER: 7563 Machine Specific Notes: =======================
================================= MACHINE SPECIFIC NOTES FOR INFORMIX-SE 7.20.UC2 PRODUCT RELEASE DATE: 17 Jun 1996 ================================= PORT NUMBER: 024718(8MM CASSETTE) 024721(DAT CARTRIDGE) 024724(TAPE CARTRIDGE) 024737(CD ROM) IRIS JOB NUMBER: 7563 Machine Specific Notes: =======================
  1. The Informix 7.2 SCT products require that the drivers for a) Portable Streams Environment (PSE) and b) Asynchronous IO (AIO) be loaded on the AIX system on which the Informix 7.2 SCT products are being used. The Informix 7.2 SCT executables use entry points defined by these drivers. Portable Streams Environment (PSE) may be loaded using /usr/sbin/strload command and Asynchronous IO (AIO) device may be enabled (loaded) using either the 'smit' interface or using the command /usr/sbin/mkdev -l aio0. For further information consult AIX documentation.
  2. The Network Protocols/Interfaces supported for this platform are: a. Berkeley sockets using TCP/IP To use this protocol, NETTYPE must be set to "sesoctcp" in the sqlhosts configuration file.
  3. TERMINFO is not supported on this platform.

================================= MACHINE SPECIFIC NOTES FOR INFORMIX-OnLine/Optical 7.20.UC2 PRODUCT RELEASE DATE: 17 Jun 1996 ================================= PORT NUMBER: 024718(8MM CASSETTE) 024721(DAT CARTRIDGE) 024724(TAPE CARTRIDGE) 024737(CD ROM) IRIS JOB NUMBER: 7563 Machine Specific Notes: ======================= The optical product is not tested with simulator since optical simulator for AIX 4.1.3 is not available. Testing was attempted using the AIX 3.2.5 simulator. It was found that the simulator for AIX 3.2.5 dumps core with 7.20.UC2 product on AIX 4.1.3 (Bug #55391).
End of All Machine Notes for This Release