InformixLink TechInfo Center - Machine Specific Notes
 


                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
           INFORMIX-OnLine Dynamic Server 7.10.UD2 PRODUCT RELEASE
                               DATE: 26 Jun 1995
                      =================================

PORT NUMBER: 025385

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

The following entries were configured in /etc/system while doing the port.

set enable_sm_wa = 1
set shmsys:shminfo_shmmax=268435456
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmns=4096
set semsys:seminfo_semmnu=4096
set semsys:seminfo_semume=64
set shmsys:shminfo_shmmin=100
set shmsys:shminfo_shmmni=500
set shmsys:shminfo_shmseg=100
set c2audit:audit_load=1

LOCATION OF SHARED MEMORY:
=========================
SHMBASE:0x50000000L


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".
    In addition, the SunSoft product "PC Protocol Services with
    IPX/SPX for the Solaris 2.x Operating Environment" is required.

    To use IPC with stream pipe, NETTYPE in the ONCONFIG file & the nettype
    field in the sqlhosts file entry must contain "onipcstr".

2. Onarchive tape drives/tape drivers:

   Onarchive has been tested on Solaris(x86) with 8mm tape using the BSD tape
   driver.  It currently fails when using the System V tape driver.  The
   BSD tape driver is invoked by using tape devices with names ending in
   'b', such as /dev/rmt/0mb.  

   We have tested our product to work well with "st" driver provided on
   this platform. 

   Due to Sun SW/HW problems, onarchive does not work properly with
   cartridge tape drives.  This problem has been reported to Sun and is
   under investigation.

3. TERMINFO is supported on this port.


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 port. This 
   feature can be activated through the two onconfig parameters of AFF_SPROC 
   and AFF_NPROCS.

5. Solaris(x86) 2.4 Patch Information:

   For user's information, the following patches from Sun Service 
   were installed on the machine where the products were built and
   tested.

	Patch ID   Description
	=========  =============
	101946     SunOS 5.4_x86: jumbo patch for kernel
	101960     SunOS 5.4_x86: jumbo lp patch
	101970     SunOS 5.4_x86: ip driver fixes
	101974     SunOS 5.4_x86: apps using AUTH_DES fail when many 
                                  simultaneous requests are made
	101982     SunOS 5.4_x86: login & security fixes
	102008     SunOS 5.4_x86: vnode v_count is not maintained correctly
	102021-04  SunOS 5.4_x86: asynchronous I-O in the user level hurts 
                                  RDBMS performance
	102071     SunOS 5.4_x86: Bugfix for rpcbind/portmapper
	102217     SunOS 5.4_x86: NFS client starts using unreserved UDP port
	102219     SunOS 5.4_x86: libbsm fixes
	102611	   SunOS 5.4_x86: ufsboot fix 


6.  The OnPerf performance monitoring capability is supported.
    Used X11R5 and Motif 1.2.3 when testing on this platform.
    
7.  The DB/Cockpit DBA monitoring tool is not available on this platform.

8.  Kernel AIO is a standard feature of Solaris 2.4, and is supported
    by this release.

9.  The Informix network libraries are supported as shared libraries
    on this platform.  

10. The following problem has been reported to Sun Service.  However,
    resolutions or patches are not available as of the date of this 
    Informix product release.

    Sun Service Order/ 
    Problem #		Description
    =================	======================================================
    1193946		PC Protocol Services 1.0 with IPX/SPX for the
			Solaris 2.x Operating Environment handles limited
			concurrent connection requests.

			Informix PTS#: 37245

			Symptom:
			Informix database servers using nettype tlispx
			fail to handle concurrent user connections in
			burst mode.

			Workaround:
			Use INFORMIXCONTIME and INFORMIXCONRETRY environment
			variables on client side to retry connections.

11. Configuring the operating system audit subsystem


The objective of this section is to specify how to configure 
the OS audit subsystem to be able to record INFORMIX-OnLine
audit records in the OS audit log. The following steps
need to be performed in order to use the INFORMIX-OnLine OS auditing feature.

	1. A new audit class "ix" must be introduced to the OS audit
	   subsystem as the class for INFORMIX-Online DBMS generated audit 
	   events.

	2. A new event "AUE_INFORMIX" must be introduced to the audit 
	   subsystem. This will be an event type belonging to the "ix"
	   audit class, and will be used by the INFORMIX-OnLine DBMS.

	3. The OS audit subsystem must be configured to audit events of the
	   event class designated by "ix".

	4. The OS audit subsystem must be operational, and auditing enabled.

Starting the audit system
=========================
Once you have completed the configuration steps above, enable auditing with
the new configuration. See 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 AUE_INFORMIX, of the event class "ix".
Please see the man pages for audit, auditreduce, auditconfig and other related
commands for details on configuring auditing on the system.
The class type "ix" must be introduced by inserting a line defining the class
in /etc/security/audit_class. The event type AUE_INFORMIX must be introduced to
the OS with class "ix", by inserting a line defining this event in the file 
/etc/security/audit_event. 

NOTE: The entry should be added to the section for Non-KERNEL events, and
the number must be a valid number > 32767. Please pay careful attention
to the format, even of the comments, because they are parsed by the 
auditreduce and perhaps other audit library functions at runtime.

SETTING UP THE SYSTEM AUDIT MASK
================================
To receive INFORMIX-OnLine audit data, the operating system audit
subsystem must be configured to accept events of the type AUE_INFORMIX, 
and of class "ix"

Line extracted from /etc/security/audit_class
===================================================
0x00008000:ix:Informix OnLine Class

Line extracted from /etc/security/audit_event
===================================================
32768:AUE_INFORMIX:Informix OnLine Event:ix

*** Note *** if auditing is disabled at OS level, no error will be
             generated by INFORMIX OnLine audit subsystem, as the 
             system call au_write() does not return any error when 
             auditing is disabled.

Lines extracted from /etc/security/audit_control
===================================================
dir:/var/audit
flags:ix

Important files in configuring OS audit subsystem.
=================================================
/etc/security/audit_control
/etc/security/audit_event
/etc/security/audit_class

HOW TO DO IT
============
	
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 use 
"onshowaudit -O" to extract INFORMIX-OnLine records. Refer to the 
INFORMIX-OnLine TFM for further details.

12. The following problem with auditing in Solaris 2.4 has been reported 
    to Sun Service.  However, resolutions or patches are not available as of 
    the date of this Informix product release.

    Sun Service Order/ 
    Problem #		Description
    =================	======================================================
    1956255       	The Solaris audit utility "praudit", when executed 
			with no options or the options "-l" or "-s", produces 
			a segmentation violation when the OS audit system has
			been configured with user-defined audit events such 
			as "AUE_INFORMIX".  However, "onshowaudit" can be 
			used to extract Informix audit records from the OS 
			audit trail.  

			One workaround that can be used to read other kinds 
			of events from the OS audit trail is to remove the 
			audit class "ix" from the file 
			/etc/security/audit_class and the audit event 
			"AUE_INFORMIX" from the file 
			/etc/security/audit_event, and then reconfigure the 
			OS audit system with audit_startup.  "praudit" can 
			then be used to read the audit trail.  However, 
			the INFORMIX-OnLine DBMS cannot be used to generate
			audit records to the OS audit trail when OS auditing
			is configured this way.

			A similar problem occurs with the Solaris audit
			utility "auditreduce".  When executed with the "-c"
			option, it only issues a warning.
^L
 
The following list of bugs have been fixed in  : 7.10.UD2
This port was based on the original port master: 7.10.UD1

--------------------- Bugs Associated with OnLine --------------------------

Bug Number: 36400

Description:
The onarchive failed with error code 14202 when executing the request :
"archive/dbspaceset=critical/vset=vset1/level=0" (where vset1 was defined
on tape). This problem was intermittent and it was found to occur with
other archiving levels and other dbspaces also.


Bug Number: 39834
 
Description:
OnLine panics when running a DELETE or UPDATE statement with BEFORE or
FOR EACH ROW trigger containing a stored procedure and with PDQPRIORITY > 0.
 
--------------------- End of Bug Fixes in 7.10.UD2 -------------------------
 
^L
 
The following list of bugs have not been fixed in  : 7.10.UD2
This port was based on the original port master    : 7.10.UD1
 
--------------------- Bugs Associated with OnLine --------------------------
 
Bug Number: 37681
 
Description:
The utility onunload fails with error 4 and/or error 16 when unloading to a
tape drive.
 
The workaround is to specify the tape device as :
where  is the hostname of the system and  is the
name of the tape device being used.
 
Example : onunload -t : 
 

Bug Number: 37564

Description:
With DR pair brought up using IPX/SPX protocol, if the primary server is broughtdown using onmode, restarting the DR pair by doing oninit on primary causes
the primary server to panic.

------------------ End of Bugs associated with online in 7.10.UD2 -----------



                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
                 INFORMIX-ESQL/COBOL 7.10.UD1 PRODUCT RELEASE
                               DATE: 26 Jun 1995
                      =================================

PORT NUMBER: 025385


1. Solaris(x86) 2.4 Patch Information:

   For user's information, the following patches from Sun Service 
   were installed on the machine where the products were built and
   tested.

	Patch ID   Description
	=========  =============
	101946     SunOS 5.4_x86: jumbo patch for kernel
	101960     SunOS 5.4_x86: jumbo lp patch
	101970     SunOS 5.4_x86: ip driver fixes
	101974     SunOS 5.4_x86: apps using AUTH_DES fail when many 
                                  simultaneous requests are made
	101982     SunOS 5.4_x86: login & security fixes
	102008     SunOS 5.4_x86: vnode v_count is not maintained correctly
	102021-04  SunOS 5.4_x86: asynchronous I-O in the user level hurts 
                                  RDBMS performance
	102071     SunOS 5.4_x86: Bugfix for rpcbind/portmapper
	102217     SunOS 5.4_x86: NFS client starts using unreserved UDP port
	102219     SunOS 5.4_x86: libbsm fixes
	102611	   SunOS 5.4_x86: ufsboot fix 

2.  If using MF COBOL compiler version v3.1.52-e, need to modify
    C compiler path from SC2.0.1 to SC3.0.1 in /coblib/liblist.
    




                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
                   INFORMIX-ESQL/C 7.10.UD1 PRODUCT RELEASE
                               DATE: 26 Jun 1995
                      =================================

PORT NUMBER: 025385


Machine Specific Notes:
=======================

1. Solaris(x86) 2.4 Patch Information:

   For user's information, the following patches from Sun Service 
   were installed on the machine where the products were built and
   tested.

	Patch ID   Description
	=========  =============
	101946     SunOS 5.4_x86: jumbo patch for kernel
	101960     SunOS 5.4_x86: jumbo lp patch
	101970     SunOS 5.4_x86: ip driver fixes
	101974     SunOS 5.4_x86: apps using AUTH_DES fail when many 
                                  simultaneous requests are made
	101982     SunOS 5.4_x86: login & security fixes
	102008     SunOS 5.4_x86: vnode v_count is not maintained correctly
	102021-04  SunOS 5.4_x86: asynchronous I-O in the user level hurts 
                                  RDBMS performance
	102071     SunOS 5.4_x86: Bugfix for rpcbind/portmapper
	102217     SunOS 5.4_x86: NFS client starts using unreserved UDP port
	102219     SunOS 5.4_x86: libbsm fixes
	102611	   SunOS 5.4_x86: ufsboot fix 


2. The Informix network libraries are supported as shared libraries
   on this platform.  



                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
                       C-ISAM 7.10.UD1 PRODUCT RELEASE
                               DATE: 26 Jun 1995
                      =================================

PORT NUMBER: 025385


Machine Specific Notes:
=======================
  



                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
              INFORMIX-OnLine/Optical 7.10.UD2 PRODUCT RELEASE
                               DATE: 26 Jun 1995
                      =================================

PORT NUMBER: 025385


Machine Specific Notes:
=======================




                      =================================
                            MACHINE SPECIFIC NOTES
                                    FOR
                    INFORMIX-SE 7.10.UD1 PRODUCT RELEASE
                               DATE: 26 Jun 1995
                      =================================

PORT NUMBER: 025385


Machine Specific Notes:
=======================

1. The following protocol(s)/interface(s) are supported for this platform:

	TLI using TCP/IP
	TLI using IPX/SPX

   To use TLI with TCP/IP, the nettype field in the sqlhosts file entry
   must be "setlitcp".

   To use TLI with IPX/SPX, the nettype field in the sqlhosts file entry
   must be "setlispx".  In addition, the SunSoft product "PC Protocol 
   Services with IPX/SPX for the Solaris 2.x Operating Environment" is
   required.

2. Solaris(x86) 2.4 Patch Information:

   For user's information, the following patches from Sun Service 
   were installed on the machine where the products were built and
   tested.

	Patch ID   Description
	=========  =============
	101946     SunOS 5.4_x86: jumbo patch for kernel
	101960     SunOS 5.4_x86: jumbo lp patch
	101970     SunOS 5.4_x86: ip driver fixes
	101974     SunOS 5.4_x86: apps using AUTH_DES fail when many 
                                  simultaneous requests are made
	101982     SunOS 5.4_x86: login & security fixes
	102008     SunOS 5.4_x86: vnode v_count is not maintained correctly
	102021-04  SunOS 5.4_x86: asynchronous I-O in the user level hurts 
                                  RDBMS performance
	102071     SunOS 5.4_x86: Bugfix for rpcbind/portmapper
	102217     SunOS 5.4_x86: NFS client starts using unreserved UDP port
	102219     SunOS 5.4_x86: libbsm fixes
	102611	   SunOS 5.4_x86: ufsboot fix 

3. The Informix network libraries are supported as shared libraries
   on this platform.  


4. The following problems have been reported to Sun Service.  However,
   resolutions or patches are not available as of the date of this 
   Informix product release.

   Sun Service Order/ 
   Problem #		Description
   =================	======================================================
   1193946		PC Protocol Services 1.0 with IPX/SPX for the
			Solaris 2.x Operating Environment handles limited
			concurrent connection requests.

			Symptom:
			Informix database servers using nettype tlispx
			fail to handle concurrent user connections in
			burst mode.

			Workaround:
			Use INFORMIXCONTIME and INFORMIXCONRETRY environment
			variables on client side to retry connections.




End of All Machine Notes for This Release