Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / September 2003

Tip: Looking for answers? Try searching our database.

Tunning

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J.M.Rodriguez - 29 Sep 2003 09:21 GMT
My server is running on a HPUX ver. 11, use KIO and have over 100
concurrent users. Normally it works well, but there are punctual
moments in that which  the system goes very loaded. I see the
processes oninit that consume many CPU. But I am not capable of
verifying that user's sesions are that really are provoking this
consumption. Someone can help me or knows a document that can be
served as guide?

Thank you in advance
Art S. Kagel - 29 Sep 2003 18:36 GMT
> My server is running on a HPUX ver. 11, use KIO and have over 100 concurrent
> users. Normally it works well, but there are punctual moments in that which
[quoted text clipped - 4 lines]
>
> Thank you in advance

We need more to help you!  First you can look in the Performance Guide in the
online manuals, then query the CDI archives for similar tuning problems and see
what advice we have given others, finally post the following and perhaps
someone will spot something:

IDS Version (ex: 7.31UD7, 9.40UC2, etc.)
Contents of your ONCONFIG file (or output from onstat -c).
Output of the following onstat options:
-p, -P (top five and bottom 10 lines only), -d, -D, -L (top section only),
-F, -R, -g iov, -g iof
Time since the engine stats were last zero'd if since startup (onstat -z to
zero engine stats).
Description of your disk farm: BOD (Bunch of Disks), RAID level if any, sizes,
speed, whether filesystems share the same disk structures.
Types of connections (% of users on each): Shared memory, TCP, multiplexor.
Number of CPU & amount of main memory on the machine.
Type of applications/queries: OLTP -versus- DSS -versus- Data Warehouse.

Art S. Kagel
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.