bozoz HowTo Grandmaster

Joined: 30 Jul 2006 Posts: 17
|
Posted: Thu Oct 12, 2006 3:25 pm Post subject: Infromix tuning notes from IBM for Linux on 32bit systems |
|
|
http://publib.boulder.ibm.com/epubs/html/25122030.html
the important part:
++++++++++++++++++++++++++++++++++++++++++++++
2. Location of Shared Memory
The ONCONFIG setting SHMBASE should be set to the following:
SHMBASE 0x10000000L
- The default start address for shared libraries on Linux is 0x40000000.
Therefore, the maximum available space for shared memory is 768 MB
when using 0x10000000L as the SHMBASE value.
SHMBASE can also be set to start above the shared library addresses.
When doing so, ensure that dynamically loaded shared libraries
do not collide with the shared memory segments.
The address space layout can be checked by the following command:
$ cat /proc//maps
- On Red Hat Enterprise Linux 3 the start address for shared libraries
is 0xb7600000 and memory address space is utilized downwards.
- Some Linux distributions (e.g. SuSE Linux 8.1, 8.2, 9, SLES 8 and
Redhat Linux Advanced Server 2.1) provide a way to dynamically change
the default start address for shared libraries on a per-process basis.
This feature is available if the file /proc/$$/mapped_base exists.
To change the start address for shared libraries of the oninit processes,
the new start address needs to be specified by the user root in the shell
from where oninit is started. For example, the following sets the start
address of shared libraries to 0xB0000000L:
$ echo $$
29712
$ su root
Password:
# echo 0xB0000000 > /proc/29712/mapped_base
# exit
$ oninit
Assuming the ONCONFIG setting SHMBASE is 0x10000000L, this gives 2.5 GB
of contiguous address space available for the database server.
==============================================
and here is the rest for posterity sake:
=================================
MACHINE SPECIFIC NOTES
FOR
IBM Informix Dynamic Server 9.40.UC4 PRODUCT RELEASE
DATE: 24 Mar 2004
=================================
PORT NUMBER: 204074 (CD ROM) 204075 (Electronic Delivery)
IRIS JOB NUMBER: 42248
OS Information : Built on Kernel: 2.4.7-10, Glibc: 2.2.4 (i686 version)
System Requirements:
===================
1. This product was built on RedHat Linux 7.2 for i686 compatible
processors and is targeted for Linux Kernel 2.4.7 or higher and
glibc 2.2.4 or higher. The i686 version of glibc is required.
This product has been certified to run on RedHat Enterprise Linux 3.0.
2. The UNIX graphical tools provided with this release require
runtime libraries from an OpenMotif package (e.g.
openmotif-2.2.2-3_ICS or newer versions if compatible).
Check for the latest version at
http://www.motifzone.org/download/
3. The ISM scripts need ksh. Install it as /bin/ksh.
4. The High Performance Loader utilities, onpload and ipload, require a
minimum of 35 MB of memory and 70 MB of swap space in order to run.
5. J/Foundation (Java in the Server):
J/Foundation supports the JRE 1.3.1 release from Sun Microsystems,
which uses the Linux native threads based Java Virtual Machine.
JRE 1.3.1 is available under $INFORMIXDIR/extend/krakatoa/jre
and should be used with J/Foundation. To use this JRE, specify the
ONCONFIG setting JVPJAVAHOME as shown below:
JVPJAVAHOME /jre
where is $INFORMIXDIR/extend/krakatoa
For developing Javaudrs used with J/Foundation, use the JDK 1.3.1 release
which can be downloaded from:
http://java.sun.com/j2se/1.3
For IBM Informix Dynamic Server ONCONFIG settings for J/Foundation,
refer to "onconfig.std" in $INFORMIXDIR/etc.
System Configuration:
====================
1. Kernel Parameters
The values of the kernel parameters that were used for testing this
product are given below. These values might need to be tuned depending
on the application and availability of system resources. They
can either be dynamically changed in the /proc file system or are defined
in the kernel sources and can be changed by rebuilding the kernel.
SHMMAX: 33554432
SHMMIN: 1
SHMMNI: 128
SHMSEG: 128
SHMALL: 4194304
SEMMNI: 128
SEMMSL: 250
SEMMNS: 32000
SEMOPM: 32
- The value of the kernel parameter "SEMMSL" should be set to at least
100. This is the maximum number of semaphores per set. See the
section on "Configuring Semaphore Parameters" in the IBM Informix
Dynamic Server Migration Guide for details.
2. Location of Shared Memory
The ONCONFIG setting SHMBASE should be set to the following:
SHMBASE 0x10000000L
- The default start address for shared libraries on Linux is 0x40000000.
Therefore, the maximum available space for shared memory is 768 MB
when using 0x10000000L as the SHMBASE value.
SHMBASE can also be set to start above the shared library addresses.
When doing so, ensure that dynamically loaded shared libraries
do not collide with the shared memory segments.
The address space layout can be checked by the following command:
$ cat /proc//maps
- On Red Hat Enterprise Linux 3 the start address for shared libraries
is 0xb7600000 and memory address space is utilized downwards.
- Some Linux distributions (e.g. SuSE Linux 8.1, 8.2, 9, SLES 8 and
Redhat Linux Advanced Server 2.1) provide a way to dynamically change
the default start address for shared libraries on a per-process basis.
This feature is available if the file /proc/$$/mapped_base exists.
To change the start address for shared libraries of the oninit processes,
the new start address needs to be specified by the user root in the shell
from where oninit is started. For example, the following sets the start
address of shared libraries to 0xB0000000L:
$ echo $$
29712
$ su root
Password:
# echo 0xB0000000 > /proc/29712/mapped_base
# exit
$ oninit
Assuming the ONCONFIG setting SHMBASE is 0x10000000L, this gives 2.5 GB
of contiguous address space available for the database server.
3. JRE Shared Libraries
In order to ensure the JRE shared libraries are loaded properly, the
following steps are neccessary:
a. Create following link in $INFORMIXDIR/extend/krakatoa/jre/lib/
ln -s i386 i686
b. Add the following lines at the end of /etc/ld.so.conf
<$INFORMIXDIR>/extend/krakatoa/jre/lib/i686
<$INFORMIXDIR>/extend/krakatoa/jre/lib/i686/server
<$INFORMIXDIR>/extend/krakatoa/jre/lib/i686/native_threads
This assumes the bundled JRE in $INFORMIXDIR/extend/krakatoa/jre
is used. Substitute <$INFORMIXDIR> by the value of your
INFORMIXDIR environment variable.
c. Run ldconfig as root
# ldconfig
Feature Notes: (alphabetized by feature)
=============
1. High Performance Loader
User-defined conversion routines for the High Performance Loader must be
provided in a dynamic, shared library called ipldd09a.so. Previously, the
custom-code shared library file was installed in the /usr/lib directory.
Now it is installed in the $INFORMIXDIR/lib directory. You can set the
location of this file with the new HPL_DYNAMIC_LIB_PATH configuration
parameter in the file pointed to by PLCONFIG environment variable. For
more details please refer the manual, "Guide to the High-Performance Loader"
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.
2. Network Protocols
The following protocol(s)/interface(s) are supported besides shared memory
on this platform:
Berkeley sockets using TCP/IP
To use sockets with TCP/IP, NETTYPE in the ONCONFIG file and the nettype
field in the sqlhosts file entry must contain "onsoctcp".
The protocol used for supporting MaxConnect on this platform is "onsocimc".
3. Online Backup and Restore (ON-Bar)
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:
a. Rename the library to $INFORMIXDIR/lib/ibsad001.so
b. Create $INFORMIXDIR/lib/ibsad001.so as a symbolic link to the
library.
c. Set the BAR_BSALIB_PATH parameter in $INFORMIXDIR/etc/$ONCONFIG
to the full pathname of the library.
Previously, the shared library file was needed to be in the /usr/lib
directory. Now it needs to be under $INFORMIXDIR/lib.
4. Optical
The Optical feature has not been tested with the Optical Simulator.
The name of IBM Informix Shared Optical library on Linux is "iosm09a.so".
Refer to the "Guide to the Optical Subsystem" for information about
enabling optical functionality.
5. Pluggable Authentication Module (PAM)
PAM functionality is supported on Linux operating system.
The PAM is dependent on the libpam.so library supplied by the
Operating System vendor.
This feature introduces authentication using Pluggable Authentication
Module (PAM) in IBM IDS 9.4. Use of PAM can be enabled or disabled by
the system administrator. By default, IBM IDS will use the traditional
authentication mechanism in order to avoid wide spread changes required
by the users.
The PAM service identifies the PAM module. This PAM module typically
resides in /usr/lib/security and its parameters are listed in
/etc/pam.conf.
6. Raw Character Devices
Some Linux distributions support binding a raw character device to a
block device. Any block device may be used.
This version of the IBM Informix Dynamic Server supports using raw
character devices.
7. Simple Password Communications Support Module
The name of the IBM Informix shared library for Simple Password CSM
on Linux is libixspw.so.
Features not supported:
======================
The following features are not supported in this release because of
operating system limitations:
1. Processor Affinity
2. Kernel AIO
3. OnSNMP
4. Operating system audit
Known Defects:
=============
1. Bug Number: 166703
Short Description:
IPLOAD DOESN'T WORK IN LINUX "2.4.21-4.ELSMP" WHEN "LANG" IS SET TO
"EN_US.UTF-8".
This problem only exists when DISPLAY is remote. This is due to a problem
in Openmotif 2.2.2-16. The workaround is to set the environment variable
LANG to en_US.
2. Bug Number: 155970
Short Description:
ONMONITO WHEN USING ONMONITOR VERSION 9.30.UC2 THE DBSPACE
INFO DOES NOT SHOW THE SMART BLOB SPACES. THE REGULAR BLOBSPACES
ARE SHOWN HOWEVER.
3. Bug Number: 165583
Short Description:
SERVER CRASHED IN NET_NSF_LOCALFD AFTER CPU VPS DYNAMICALLY ADDED
4. Bug Number: 165499
Short Description:
DBACCESS - LAST PARSED SQL STATEMENT DOES NOT SHOW UP IN ONSTAT -G
SQL OR ONSTAT -G SES
Defects Fixed in the current Release:
====================================
1. Bug Number: 163009
Short Description:
IDS 9.40 HANGS CONSTANTLY ON CHECKPOINT REQUEST WHEN REMOTE TCP/IP
CONNECTIONS ARE EXECUTING SQL STATEMENTS.
2. Bug Number: 163454
Short Description:
"SYSTEM ERROR:RECVD ERRONEOUS EVENT ON SELECT" WHEN MORE THAN 1024
CLIENT CONNECTIONS ON LINUX
3. Bug Number: 165354
Short Description:
MESSAGE 'THE LOGICAL LOGS ARE FULL. ON-BAR MAY ENCOUNTER ERRORS
WRITING TO THE SYSUTILS DATABASE.' IN BARACT LOG WHEN LOGS ENTERED
IN REVERSE ORDER
4. Bug Number: 162842
Short Description:
SELECTING VIA INDEX AND ROWID (IN THIS ORDER) CRASHES ENGINE IN LOADKEY
5. Bug Number: 163894
Short Description:
ON LINUX A MULTISET QUERY W/AGGREGATE (MAX) ON A DATE CONSTANT CRASHES
IN NEW_EVAL FUNCTION. AGAINST OTHER DATA TYPES GIVES ERROR 595 BAD USE
6. Bug Number: 163344
Short Description:
ONSTAT STRUCTURE DUMPER PRINTS HEX ADDRESSES WITH LEADING 0X0X ON LINUX
7. Bug Number: 161670
Short Description:
IDS9.40-LINUX MACHINE NOTES AN ADDITIONAL TEXT REQUIRED
(SYSTEM REQUIREMENTS)
8. Bug Number: 165793
Short Description:
RELEASE NOTES SHOULD STATE THE NEED OF A GLIBC VERSION BUILT FOR
I686 MACHINE ARCHITECTURE. OTHERWISE, ADM VP WILL FAIL TO START.
Defects Fixed in previous Release:
=================================
1. Bug Number: 118121
Short Description:
IPLOAD GUI ON LINUX, WINDOWS COMPONENTS ARE NOT PROPERLY
DISPLAYED IN SEVERAL PLACES DUE TO UTILIZATION OF LESSTIF
(MOTIF) LIBRARY.
2. Bug Number: 118221
Short Description:
ONPERF GUI ON LINUX, WINDOWS COMPONENTS ARE NOT PROPERLY
DISPLAYED IN SEVERAL PLACES DUE TO UTILIZATION OF LESSTIF
(MOTIF) LIBRARY.
3. Bug Number: 129843
Short Description:
THE READSQL() JAVA METHOD OF A COMPLEX TYPE DOES NOT
GET A NULL VALUE IN A SMALLFLOAT TYPE MEMBER CORRECTLY.
THE RESULT IS NAN.
4. Bug Number: 131217
Short Description:
ONINIT THE INSTANCE WITH NOAGE SET TO 1 HANGS THE WHOLE
LINUX SYSTEM.
5. Bug Number: 132276
Short Description:
ONPLADM RUN JOB ... REPORTS "ERROR CONNECTING TO SOCKET".
6. Bug Number: 135381
Short Description:
IF SYSTEM CALL DLOPEN() IS NOT REENTRANT, LOADING SHARED
LIBS OF JVM MAY FAIL IF JVP LOADS ANOTHER SHARED LIB IN
NOTIFYVP_SIGNAL_HANDLER().
7. Bug Number: 105026
Short Description:
ETC/EVIDENCE.SH ASSUMES THAT ECHO BUILTIN FROM /BIN/SH
CAN HANDLE \T & \C CONVENTIONS FOR ASSERTION FAILURE DUMPS.
8. Bug Number: 145857
Short Description:
DBACCESS DOES NOT MOVE THE CURSOR TO THE NEXT FIELD WHEN
WAS HIT
9. Bug Number: 156394
Short Description:
__ON_EXIT LIBRARY FUNCTION UNDEFINED ON LINUX REDHAT 7.3
10. Bug Number: 153624
Short Description:
LINUX: AFSTACK SKIPS FAILING FUNCTION IN CASE OF ASSERT FAILURE, SEGV
11. Bug Number: 156451
Short Description:
MEMORY LEAK WITH QUERY INVOLVING MAPINFO SPATIALWARE DATABLADE UDT'S
ST_LENGTH, ST_OVERLAP OR ST_CONTAINS
12. Bug Number: 146282
Short Description:
ESCAPE (ESC) KEY HAS TO BE PRESSED TWICE IN DBACCESS OR DBMONITOR
IN ORDER TO WORK. ONLY FIRST TIME IT IS PRESSED WORKS FINE.
13. Bug Number: 162443
Short Description:
USING ONMONITOR INTERRUPT KEY ONLY WORKS THE FIRST YOU HIT IT |
|