SUMMARY: Tru64 and Informix

From: Smith, Lawrie <Lawrie.Smith_at_capita.co.uk>
Date: Tue, 02 Apr 2002 09:56:46 +0100

Many thanks to Colin Bull and Niklas Axelsson.

In addition IBM has offered advice. Waiting with anticipation.

 

For Tuning http://www.iiug.org/ver3/index.html
<http://www.iiug.org/ver3/index.html> and /or subscribe to
comp.databases.informix. Very helpful very informative.

Performance tuning is same as on standalone server.

 

For configuration - Unless you are using a version 8.xx Informix you cannot
run as a clustered application.

Therefore run an application on a prefered server with a failover server.

 

Items to check in /etc/sysconfigtab

ipc:
        shm_mni = 1024
        shm_seg = 256
        shm_max=2147283647
        sem_mni=400

 

        sem_msl=1600
proc:
        max_proc_per_user=256
        max_threads_per_user=512
        per_proc_stack_size=4294967296
        max_per_proc_stack_size=4294967296
        per_proc_address_space=4398046511104
        max_per_proc_address_space=4398046511104

 

rt:
        aio-max-percent=5
        aio-max-retry=20
        aio-retry-scale=5
        aio-task-max-num=2048
        sigqueue-max-num=128

 

informix.scr and informix.cap files attached as per our setup.

In informix.scr there are an ifconfig commands to start and abort an IP
alias for informix application. We found using the cluster alias did not
work properly and gave up with it. This works very well. We have been
running with this set up for about 6 months in live environment.

 

We have had problems with GATED parameter in /etc/rc.config, this has been
set to 'no'

and we have set servers not to autoboot, because on 3 instances a crashed
server has brought the standby down because of

trying and failing to agree cluster status over and over again.

 

 

 

But I got a couple of links about Informix that you could checkout and I
know there's a a Performance Guide for
every version of the Informix DB engine (download it from IBM's website).

http://www.markscranton.com/informix/informix.htm

http://www.palslib.com/Informix/Informix.html

http://www.prstech.com/index.shtml

Also, check out these PDF-files that I've found somewhere on the net. I've
got some useful hints, maybe you'll find
them useful. I've got a T64 system aswell, but I'm no expert on T64 and
performance, yet ! ;-)

 

Kind regards

Lawrie Smith
Tru64 UNIX Systems Manager
Capita Technical Services
West Malling

email: lawrie.smith_at_capita.co.uk
Tel: 01732 877266
Mob: 0774 082 5468

 



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
Received on Tue Apr 02 2002 - 10:02:24 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:43 NZDT