[lawrenzo]

I am having performance issues from 08:15 this morning, I have run various performance commands such as ps, vmstat, iostat, sar, svmon etc

The issue is oninit is showing 100% CPU utilization, everything else memory paging, disk writes etc are fine.

anyone have any idea how I can identify what is hammering the informix process?

cheers

[ScriptDaddy]

Bug in the Informix code?

Has the run queue increased somewhat? VMSTAT will provide that information.

Also ... is it restricted to just one parent process or multiple child processes?

A good tool to use for monitoring i/o, memory and cpu usage is NMON.

Do the Informix logs give any clues to errors etc?

Ben

[rvannoy]

Originally Posted by lawrenzo

I am having performance issues from 08:15 this morning, I have run various performance commands such as ps, vmstat, iostat, sar, svmon etc

The issue is oninit is showing 100% CPU utilization, everything else memory paging, disk writes etc are fine.

anyone have any idea how I can identify what is hammering the informix process?

cheers

Sounds like another typical database server issue. Post your vmstat detail so we can see what is chewing up cpu. What do the average % breakdowns look like in your vmstat (%usr %sys %wa %idle). Also, is this a constant level of utilization or does it peak at certain times? We need more data to help. Also post a prtconf so we can see what your cpu and mem alocation is.

Regards,

Rick Vannoy
Sr. Open Systems Architect, Consulting Engineer
Cornerstone Systems Inc,
An IBM Business Partner

[ashokvats]

I have legato client doing backup of my AIX 5200-07 mksysb file from a disk. nsrmmd process is paging very high , we get paging space 100% full and after the backup it doesn't release the paging space. We use SAN ( storage node) to do backup ...

Has any body seen this issue ? any suggestions ?

thanks,
Ashok

[MorningRush]

-If I run # ps gu |head -n 10 --> I can see the top 10 process that consume the CPU
- If this is a Dev or Test DB server then a program or script might be running in a loop.
- With Oracle, I used Toad to view and kill current sessions and running scripts, there might be some tool w/ Informix.