- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Informix 7.24 on HP 10.20. Performance degradatio...
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
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
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
тАО03-08-2001 02:25 AM
тАО03-08-2001 02:25 AM
we have a system with Informix 7.24 on HP10.20.
Three months ago we migrated our applications from other database system to Infomix. Since this change our users noticed that the applications run very slow. The users works directly in the server, there above 200 users. We detected using glance that there was CPU and disk bottleneck. We added a CPU and four disks and the bottlenecks dissapeared, but some problems persists. Users still notice that application run slow and we verify this. We detected that the application slows after situations of high load, even when systems resources are free and we must restart Informix to get the application run normal.
The connection between the application and Informix is by sockets (trough the loopback interface). We are thinking in change this connection to shared memory to reduce the system overhead.
What do you think about this change?
Do you have any idea about the cause of this problem?
Any help will be apreciated.
Thanks in advantage.
Juan Gonzalez
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 02:34 AM
тАО03-08-2001 02:34 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
Do you verify database indexes ?
During the migration, maybe someone forgot to create some indexes.
This arrived very often ...
Regards,
Patrice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 02:48 AM
тАО03-08-2001 02:48 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
thanks for answer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 03:04 AM
тАО03-08-2001 03:04 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
My problem is I cannot remember which one :-(
It had to do with locking the main processes into memory, because I think your problem is the system is swaping or de-activating the Informix processes.
I think the file was called oninit, but may be wrong.
If you post your Informix profile I may rememeber which one, otherwise Informix SHOULD know of the issue and it's fix.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 03:10 AM
тАО03-08-2001 03:10 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
what about database statistics ?
Informix 7.24 uses a cost-based optimizer.
This one needs calculated statistics (as oracle CBO as well) to provide correct access
path to the data.
I do not recall how the program is called.
On SAP you have a program infupdstat, but I do not recall if it is SAP or informix tool.
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 04:07 AM
тАО03-08-2001 04:07 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
It could be lots of things actually - long checkpoints, sequential scans, patching. If you have new tables being populated, run update statistics often on them. If you have a mixture of batch and on-line processes, keep the batch ones thru the socket and set the on-line user processes to go thru ipcshm. This will bypass a saturated socket and make it quicker for the users.
By the way, 7.24 has a few tcp socket related bugs which makes it crash a lot - I suggest upgrading to 7.31 asap.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 04:48 AM
тАО03-08-2001 04:48 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
Melvyn
I attach the configuration file of Informix, could you take a look?
Volker
We run the update stadistics process weekly
Steve
The parameter NOAGE=0, and we have no sequential scans. We will follow your advice of divide the users in two groups if we migrate to shared memory
Best Regards
Juan Gonzalez
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-08-2001 05:02 AM
тАО03-08-2001 05:02 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
RESIDENT I believe needs to be a 1, this ensures the main Informx processes stay locked in memory.
Again, it was about 2 years ago I found out about this, and recommend you discuss with Informix to be sure, as I do not have the information to hand.
Also and additional thought, have you installed the recommended patches for Informix?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2001 01:41 AM
тАО04-04-2001 01:41 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
I just found this month old thread. There are a number of significant problems with your configuration file. If you are still watching this thread let me know and I'll post my thoughts.
You might also wish to study my notes on the subject... http://www.bamph.com/informix.htm
Enjoy,
Bill
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-04-2001 07:49 AM
тАО04-04-2001 07:49 AM
Re: Informix 7.24 on HP 10.20. Performance degradation.
yes I am still attending this thread. Could you post your conclusions about the configuration?
Thanks in advance