HowToForums.net Forum Index HowToForums.net
An Open Source of Knowledge
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Infromix tuning notes from IBM for Linux on 32bit systems

 
Post new topic   Reply to topic    HowToForums.net Forum Index -> Informix
View previous topic :: View next topic  
Author Message
bozoz
HowTo Grandmaster
HowTo Grandmaster


Joined: 30 Jul 2006
Posts: 17

PostPosted: Thu Oct 12, 2006 3:25 pm    Post subject: Infromix tuning notes from IBM for Linux on 32bit systems Reply with quote

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    HowToForums.net Forum Index -> Informix All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group