- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Tuning for informix database
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Forums
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2002 11:21 PM
тАО08-29-2002 11:21 PM
Tuning for informix database
We have a systeme L3000 with 3 processor with informix 9.21 on HPUX 11i.
What do you think about tuning of this five informix parameters:
NUMCPUVPS
SINGLE_CPU_VP
MULTIPROCESSOR
NUMCPUVPS
AFF_SPROC
AFF_NPROCS
for the moment we have the following parameters:
MULTIPROCESSOR 1
NUMCPUVPS 3
SINGLE_CPU_VP 0
NOAGE 1
AFF_SPROC 0
AFF_NPROCS 3
thanks in advantage.
Denis Aubert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-29-2002 11:49 PM
тАО08-29-2002 11:49 PM
Re: Tuning for informix database
NUMCPUVPS 2
SINGLE_CPU_VP 0
MULTIPROCESSOR 1
AFF_SPROC 0
AFF_NPROCS 0
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 12:12 AM
тАО08-30-2002 12:12 AM
Re: Tuning for informix database
If you have programs running on the server, or users using telnet to log in locally to access the database, then chop CUMCPUVPS to 2.
If you have a 3-tier architecture or a thick-client 2-tier architecture and the database is the only thing running on this system, then you are quite safe setting NUMCPUVPS to 3.
All the other listed parameters are fine.
The only thing remaining to tune is your memory allocation, in particular buffers and cleaning paramters etc.
If you have many clients then ensure that your shmvirtsize is big enough to put everything in a single segment, maybe increase the number of soctcp VPs if you have over 200 users.
If you have any more questions, then post your onconfig.
Regards,
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 12:57 AM
тАО08-30-2002 12:57 AM
Re: Tuning for informix database
I aggre with Steve in the point regarding NUMCPUVPS
Denis:
If you have perfomance problems with the engine the above parameters will not!!! solve this.
In this case you should look at
BUFFERS
NUMAIOVPS
LRU
CLEANERS
LRU_MAX_DIRTY
LRU_MIN_DIRTY
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 01:13 AM
тАО08-30-2002 01:13 AM
Re: Tuning for informix database
100 users in a call center are working on this system, but this number will increase to 300.
And it is better to tune informix before having performance problem.
Thanks for answer,
Regards,
Denis.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 01:51 AM
тАО08-30-2002 01:51 AM
Re: Tuning for informix database
BUFFERS 50000
NUMAIOVPS 3
LRUS 4
LRU_MAX_DIRTY 15
LRU_MIN_DIRTY 10
CLEANERS 4
What do you think of them?
In fact, it is a cluster with 2 nodes L3000 (3 proc, 4Go RAM), 6 informix packages. Perhaps, it is necessary to increment the parameter AFF_SPROC for each informix engine?
for exemple:
pack1 AFF_SPROC=0
pack2 AFF_SPROC=1
pack3 AFF_SPROC=2
pack4 AFF_SPROC=0
pack5 AFF_SPROC=1
pack6 AFF_SPROC=2
Regards,
Denis.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-30-2002 02:13 AM
тАО08-30-2002 02:13 AM
Re: Tuning for informix database
Denis,
I never did gain any performance
fumbling around with AFF_SPROC.
What you should do is first of all check the performance of the engines and then decide if you have to do something.
If possible change the WSTATS parameter in onconfig to 1 and restart the engine(s).
WSTAT=1 will enable you to monitor the wait statistics of your engine. It will tell you if INFORMIX is waiting for BUFFERS LRU or anything else.
In such a case you can adjust the parameter and restart.
If you are satisfied with the results set WSTATS to 0 again .
(otherwise you will loose some perfomance because the engine is gathering the metrics)
Regards
Rainer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2002 07:00 AM
тАО08-31-2002 07:00 AM
Re: Tuning for informix database
NETTYPE soctcp,X,100,CPU # X=NUMCPUVPS
NETTYPE ipcshm,1,100,NET # If at all, depends on sqlhosts file
Because your machine is 11i I would use KAIO (Kernel Asynchronous IO) so
NUMAIOVPS 3
I would NOT set NOAGE 1, ESPECIALLY if it is in a MC ServiceGuard cluster. You may well find just as the system gets really busy it will fail-over!!! NOAGE only really plays a positive role when the system is running hard & running out of CPU. If this is the case, buy more processes (easier said than done, I know). What actually happens is that Informix hogs ALL the CPU not allowing the machine to run other essential tasks.
I've also put together a perl "Informix Tuning Suite" I'll forward you the URL.
Regards
Tim
Regards
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2002 07:06 AM
тАО08-31-2002 07:06 AM
Re: Tuning for informix database
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x1c204b3ef09fd611abdb0090277a778c,00.html
This SHOULD help you decide if BUFFERS is too low etc...
I'd zero your statistics (onstat -z) & wait 24 hours or 48 hours before running the script to let the stats build up over a KNOWN period of time.
Regards
Tim