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