================================= MACHINE SPECIFIC NOTES FOR INFORMIX Dynamic Server 7.31.UD3 PRODUCT RELEASE DATE: 27 Oct 2001 ================================= INFORMIX 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. For users' information, the following patches from IBM were installed in where the products were built and tested. AIX 4.2.1: Patch ix82633: Latest Year 2000 Related Updates Patch ix79576: JDK (Java Development Kit) version 1.1.4 upgrade Patch ix81658: DCE 2.1 Fixpack 25 (for DCE users only) PTF#: U453842, PMR#: 56819: certify the Informix Dynamic Server 7.31 on AIX 4.3 The following patch is required to fix the problem described in bug number 104662: DBACCESS IN IBM, AIX PLATFORM, USING NETWORK CONNECTION, PRESSING CTRL-C CAUSES ERROR 25580. Patch for AIX 4.2.1: IY01803 Patch for AIX 4.3.2: IY01759 2. The new protocol used for supporting MaxConnect is onsocimc. For more information on how to configure your server to use with MaxConnect, please refer to the following documents: Guide to Informix MaxConnect Ver 1.0. 7.31 Server Release Notes. 3. The Informix 7.31 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.31 SCT products are used. The Informix 7.31 SCT executables use entry points defined by these drivers. Portable Streams Environment (PSE) can be loaded using /usr/sbin/strload command and Asynchronous IO (AIO) device can be enabled (loaded) using either the 'smit' interface or using the command /usr/sbin/mkdev -l aio0. For further information consult AIX documentation. 4. The UNIX graphical tools provided with this release requires X Windows System X11R5 and Motif Version 1.2.3 or later runtime libraries. 5. The following protocol(s)/interface(s) are supported besides shared memory for this platform: a. Berkeley sockets using TCP/IP To use TCP/IP, the NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must be set to "onsoctcp". b. TLI using IPX/SPX To use IPX/SPX, the NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must be set to "ontlispx". c. IPC using stream pipe (Implemented using Unix Domain Sockets) To use IPC with stream pipe, the NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must be set to "onipcstr". 6. 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. 7. TERMINFO is supported in this release. 8. The Processor 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.2.1, 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. 9. The OnPerf performance monitoring capability is supported on this platform. 10. The DB/Cockpit DBA monitoring tool is supported in this release. 11. Kernel AIO is supported on this platform. For KAIO to work, the AIO driver needs to be configured into the AIX system. AIO can be configured as given in 2. above. If AIO is not configured, oninit will report the following error at start up 0509-037 System error - error data is: oninit 0509-023 Symbol kaio_rdwr in /usr/lib/libc.a is not defined. 0509-023 Symbol listio in /usr/lib/libc.a is not defined. 0509-023 Symbol acancel in /usr/lib/libc.a is not defined. 0509-023 Symbol iosuspend in /usr/lib/libc.a is not defined. 0509-022 Cannot load library libc.a[aio.o]. 0509-026 System error: Cannot run a file that does not have a valid format. 12. 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. For example, to set CPU VP priority to 70, set: export INFX_CPUVP_PRIORITY=70 The server checks and sets the CPU VP process to the defined priority if the defined value is within the above range. 13. 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. The auditing must be configured for binary or stream mode. c. A new event INFORMIX_DBMS must be introduced to the audit subsystem. d. INFORMIX_DBMS event must be added in a relevant class definition. 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: 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 Dynamic Server 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 example, to use /etc/security/audit/trail file, specify: onshowaudit -O -f "/etc/security/audit/trail" 14. The Online Backup and Restore Utility(ON-Bar) is available with this release. ON-Bar uses the XBSA interface. Some of the functions called by ON-Bar are in a shared library supplied by third party storage management vendors. For ON-Bar to access the functions, the library has to 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 parameter in $INFORMIXDIR/etc/$ONCONFIG to the full pathname of the library. ON-Bar requires that the storage manager insert a row into the bar_version table of the sysutils database which describes the compatibility of a particular storage manager's shared library with the ON-Bar version. Only the storage management vendors have this information. If ON-Bar returns 0x8c (139 decimal) to its caller or displays the message: ERROR: Version of XBSA shared library is not compatible with version %1 of On-BAR. in the ON-Bar activity log, then select the contents of the bar_version table and consult your storage manager documentation or contact your storage management vendor. The following is the content of bar_version table: ||| where is the version of the 7.31 ON-Bar, is the release version of the XBSA shared library, is the name of this Storage Manager, is the version of the Storage Manager application. To load a storage manager version, first edit the file $INFORMIXDIR/etc/sm_versions (create if it does not exit) and enter a line giving the ON-bar version, the XBSA version, the Storage Manager name and the Storage Manager version. For example, 1|1.0.1|ism|ISM.2.00.UC1.44| Load the values into the bar_version table by running the following script as user 'informix': dbaccess sysutils - << EOF load from '$INFORMIXDIR/etc/sm_versions' insert into bar_version; EOF Run onbar -b -L0 and check your online and onbar log files as defined in onconfig to see the following messages: Level 0 Archive started on rootdbs Archive on rootdbs Completed. If there is no parameter BAR_ACT_LOG defined in the onconfig file, then onbar writes its log to /tmp/bar_act.log file. 15. OnSNMP is supported on this platform: For AIX, OnSNMP is based on PEER Network's Subagent Development Kit release 2.3. The distribution includes the following under $INFORMIXDIR: bin/onsnmp the OnSNMP subagent. bin/onsrvapd the daemon which spawns a subagent for each server it discovers. etc/*V1.mib etc/*V2.mib etc/*.my MIB files defining the instrumentation provided with OnSNMP. Files with 'V1' conform to SNMP version 1 and share the widest acceptance; files with 'V2' conform to SNMP version 2; files with the 'my' extension are transitional that may be used as a last resort. Refer to the installation notes that accompany the master agent and network manager for more details. Note: OnSNMP is supported only on single engine per host in this release. If multiple engines are running on the same host, the values returned by the subagent are only for the first engine, and all subagents for the subsequent engines will fail to start. Follow these steps to configure the Vendor Master Agent: 1) Modify the file /etc/snmpd.peers to allow the OnSNMP subagent executable 'onsnmp' to register as a peer: "onsnmp" 0.0 "" 2) Modify the file /etc/snmpd.conf and add smux 0.0 "" 16. Enterprise Replication (ER) is supported in this release. A Graphical User Interface (GUI) which runs on Windows NT, is available to define, monitor and control the replication system. Refer to the Guide to Informix Enterprise Replication for details about using the ER GUI. On the Server machine, the following setup is needed for using ER. The file /etc/snmpd.conf must have entries community hskgsk96
readWrite smux 0.0 "" where, "hskgsk96" is the name of the community
is either a hostname or an IP address in dotted notation, of the client machine where the ER GUI is installed. specifies the network mask. is the IP address of the host on which the Server is running. The file /etc/snmpd.peers must have an entry "cdragt" 0.0 "" Here "cdragt" is the name of the ER sub-agent process. Please refer to the comments in the files /etc/snmpd.conf and /etc/snmpd.peers for the syntax and explanation of various fields in these files. To bring up the SNMP master agent, execute the following command, logged in as "root": /usr/sbin/snmpd To bring up the ER sub-agent "cdragt" execute the following command logged in as "informix": $INFORMIXDIR/bin/cdragt -t -f where is a number which specifies the trace level and the name of the file in which the trace output is generated. You may bring up the Informix Server after bringing up the SNMP master agent. The PEER2.3 based master agent (snmpdp) supplied by Informix may be used as an alternative to the AIX's master agent (/usr/sbin/snmpd) for using the ER GUI. To bring up the PEER master agent, execute the following command as a root user. $INFORMIXDIR/bin/snmpdp Where is $INFORMIXDIR/snmp/peer/CONFIG and is an arbitrary filename 17. Shared Memory Residency feature is NOT supported on this platform. 18. High Performance Loader (HPL) is supported on this platform. The HPL utilities onpload and ipload require a minimum of 35MB of memory and 70MB 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). 19. Greater than 2GB (maximum) size for a shared memory segment is not supported in this release. 20. Informix Storage Manager (ISM) is supported in this release. The devices that are currently supported are Type Model Capacity (GB) Firmware 4mm --- ADIC: DAT 2000a 2 rev 6.09 DAT 8000a 4-8 rev 7.09 DAT 8008 4-8 DAT 8024 12-24 Andataco: ENC-4200S 2-4 rev T503 ENC-4400S 4-8 rev 9401 Box Hill: DTH4 4-8 Compaq: 2/8 GB DAT 2-4 rev. 1211 4/16 GB DAT 4-8 rev. 4ao, 0316 DEC StorageWorks: 4mm DAT Drive 2-4 rev. 4BE0 TLZ07 4-8 rev. 491A, 553A TLZ07 4-8 rev. 0172 TLZ07 12-24 Exabyte: 4200 2 rev. 148 4200c 2-4 rev. 132 Hewlett-Packard: 35470A (JetStore 2000) 2 rev. 6.09 35480A (JetStore 5000) 2-4 rev. 7.09 C1520A/E, C1525A, C2224B/C 2 rev. 6.09 C1521A/E, C1526A, C2225A/B 2-4 rev. 7.09 C1528A, C1529A (SureStore DAT8i 8e) 4-8 rev. 9401 C1533A (SureStore 6000) 4-8 rev. 9401 C1520G/H, C1525G/H, C1534 (SureStore 2000, 2000i, 2000e) 2 rev. T503 C1521 G/H, C1523 G/H, C1536 (SureStore 5000, 5000i, 5000e) 2-4 rev. T503 C1537A 12-24 C1538 2-4 C1539 4-8 Seagate Tape: Python 43x0 2 rev. 2.26, 2.50 Python 43x2 2-4 rev. 3.58, 3.59-1 Python 43x4 2-4 rev. 3.58 CTD-4000 2-4 CTD-8000 4-8 Scorpion 2(STD22000N, STD62000N) 2 Scorpion 4(STD24000N, STD64000N) 2-4 Scorpion 8(STD28000N, STD68000N) 4-8 Sony: SDT5000 4-8 rev. 3.26 SDT5200 4 rev. 3.02 SDT7000 4-8 rev. 0148 SDT9000 12-24 Storage Dimensions: DDS-2 Tape Backup 4-8 rev. 9401 WangDAT: 3100 2 rev. 1.1 3200 2-4 rev. 1.1 3400DX 4-8 rev. 1.10 8mm --- Andataco: ENC 8505XLS 7-14 rev. 06S1 Box Hill: CT5 5-10 CT7 7-14 Exabyte: 8200 2 rev. 2.52 * 8500 5 rev. 0415, 047Z * 8500c 5-10 > * 8505 5 rev. 05B0, 06M0 * 8505XL 7-14 rev. 06S1 * 8900 Mammoth 20-40 rev. 21C Hitachi: MT8M1 30-60 ? IBM: 8mm 8505 5 rev. 6S0A 8900 Mammoth 20-40 Sony AIT SDX-300, SDX-300C 25-50 rev. 0300 Storage Dimensions: 8mm Tape Backup 5 rev. 06M0 3480/3490 --------- IBM: 3480 .2 3490E .8-1.6 Memorex-Telex 5450E 2 .2 5490E 2 .8-1.6 Philips/LMS: TD3610 .8-1.6 StorageTek: 4480 .8-1.6 rev i4.23 4890 Twinpeaks .8-1.6 9490 Timberline .8-1.6 35x0 Magstar ------------- IBM: 3570 Magstar 5-10 rev. 3245 DLT --- ADIC: DS9200 10-20 rev. 9105, 9410 DS9300D 15-30 rev. 8203 DS9400D 20-40 rev. C504 DS9000 35-70 Andataco: ENC-6001-30S 15-30 rev. 8203 ENC-6001-40S 20-40 rev. C504 Box Hill: DLT3 15-30 DLT4 20-40 Compaq: 10/20 GB DLT Tape Drive 10-20 rev. 9410 15/30 GB DLT Tape Drive 15-30 rev. 8203, A00 Conner (Cipher): MS20DLT T860DLT .86 rev. 10 DEC StorageWorks: TZ87N 10-20 rev. 9514 TZ88 20-40 rev. CA19 TZ89 35-70 Hewlett-Packard: 30e 15-30 rev. 8203 40e 20-40 rev. C504, CC37 Quantum: DLT2000 10-20 rev. 9105, 9410 DLT2000XT 15-30 rev. 8203 DLT4000 20-40 rev. C504, CC37 DLT7000 35-70 Storage Dimensions: DLT4000 20-40 rev. CA19 Optical ------- Hewlett-Packard: Corsair I (C1716C) .6 Corsair II (C1716T) 1.3 Corsair III 2.6 IBM: Multifunction (M-O Mode Only) 1.3 Maxoptics: T4 2.6 rev. B000 Sony: SMO-541 2.6 rev. 1.09 *AIX does not support 1024 bytes/sector media, the capacities for AIX are 1.2 GB and 2.4 GB (512bytes/sector) 21. Communications Support Service using Communications Support Module (CSM) with - Simple-Password is supported in this release. The CSM library is called ispws07a.so. - DCE-GSS CSM is NOT supported in this release. There is a known issue(bug number: 107801) with CSM, when ClientSDK 2.20.x is installed on top of 7.31.x IDS server release. As a consequence of this bug, the IDS server, when initialized with CSM option, fails to build sysmaster. Please note the following workaround to avoid this problem. In your concsm.cfg file, please specify the library path as shown below - (Refer to Section 4-14 of Administrator's Guide for Informix Dynamic Server Version 7.3, for details on how to configure and use CSM) For Simple-Password CSM: SPWDCSM ("/usr/informix/lib/csm/ispws07a.so", "", "") Please note that this problem is specific to ClientSDK 2.20.x and IDS 7.31.x combination and ONLY occurs when used with CSM option. This will be fixed in future releases. 22. Known platform specific issues: