Hi Experts,

I am basically DB2 DBA. But I need to analyze two informix servers (9.4 and 10.x on AIX 5.3)

Please help me find some document that can be helpful.

The situation is such that I do not even know where is the relevant information and how to query this info. Can someone hep me with an example.

eg. tarnsactions per second
Hit ratios
Lock waits
Informix memory usage
disk space alllocations and usage.

Thanks

DBFinder

Hi Db,

for what you want, the start point is the onstat command, logged as informix.
* the main one for what you want: onstat -p
will give you the main 50 main indicators of your instance ( mainly the ones you are looking for )

for disk space, use onstat -d

for memory usage per session, use onstat -g ses

onstat is very simple to use and has many options thatwill give you almost all
the perf counters of your instance.
type onstat -- to have a brief help

Hope this helps

Eric

Thanks Eric,

How can I find the memory allocated to informix ?

Regards

Hi,

on all onstat -<something> commands output, at the first line on the right you have the current Shared Memory allocated size in Kb.

if you want more details, onstat -g mem and onstat -g seg are good candidates.

To have all the options of onstat, type onstat -- | more.

And if you are furious for coding SQL, explore the sysmaster database, but sincerely onstat is so practical and useful when you are in a rush.

Regards,

Eric

Thanks for quick response.

I can find my way around now.

Regards