Originally posted by: Sarbjit_Singh_Gill

Experts,

I need to monitor memory, cpu, disk, and network for few db2 V8.2 and db2 V9.1 servers on AIX 5.3.
This has to be monitored for a week to capture peak hour stats.

Can someone help me with any commands/scripts for this.

Thanks

DBFinder
#AIX-Forum

Originally posted by: CristianLagos

Yo could use nmon:

"

1. nmon -F /tmp/aa -s 5 -c 1 -D -E -I 100 -J

1. sort /tmp/aa | grep -e "CPU_ALL," -e "NET," -e "MEM," -e "DISKBUSY"

CPU_ALL,CPU Total apawas72,User%,Sys%,Wait%,Idle%,Busy,PhysicalCPUs
CPU_ALL,T0001,65.8,32.6,0.1,1.5,,4
DISKBUSY,Disk %Busy apawas72,hdisk0,hdisk1
DISKBUSY,T0001,21.8,0.9
MEM,Memory apawas72,Real Free %,Virtual free %,Real free(MB),Virtual free(MB),Real total(MB),Virtual total(MB)
MEM,T0001,13.2,99.8,942.7,8686.4,7168.0,8704.0
NET,Network I/O apawas72,en0-read-KB/s,en1-read-KB/s,lo0-read-KB/s,en0-write-KB/s,en1-write-KB/s,lo0-write-KB/s
NET,T0001,41.7,63.9,175.2,89.8,45.2,175.2
"

Notice, though, that the "Real Free %" in the memory section, doesn't takes into account that some memory is used for file cache. Some people recomends to look out for the active virtual memory in use:

"

1. vmstat 1 1

System configuration: lcpu=4 mem=7168MB ent=1.00

kthr memory page faults cpu

---

-----------

---

------------

---

r b avm fre re pi po fr sr cy in sy cs us sy id wa pc ec
6 0 1223760 239721 0 0 0 0 0 0 846 12609 6525 71 6 23 0 0.77 77.4
"

The avm value is in 4kb, so to compare it to the fisical RAM:

Used avm = 1223760 * 4 / 1024 = 4780 MB
RAM = 7168 MB

avm should not be greater than the ram, or you'll surely have paging in/out
#AIX-Forum

Originally posted by: Sarbjit_Singh_Gill

Thanks,

I like it, but seems hard understanding the output file. Is there any refrence that can be helpful interpretting the output ??

Regards
#AIX-Forum

Originally posted by: ostost

You can use NMON Analyzer to produce graphics from the NMON data. These will be easier to interpret. You'll find more details here:

http://www.ibm.com/developerworks/aix/library/au-nmon_analyser/
#AIX-Forum

Originally posted by: shansun0

Better try to use this command (topas) ,it will help u to monitor memory, cpu, disk, and network
#AIX-Forum

Originally posted by: Sarbjit_Singh_Gill

topas : Can we log the output of topas in text file. How ?

My purpose is to log the values for history trail.

Regards
#AIX-Forum

Originally posted by: alethad

I don't think you can capture the topas output into a file. The topas command is really just using the normal performance commands such as vmstat, iostat...etc.

Read the man page for this command to get the whole list. You can write your own script to capture output.

I would also recommend Nmon if you don't want to re-invent the wheel. It's not hard to install so give it a try. If you don't like it just uninstall it. Don't forget to get the analyzer though. It creates a really nice report for you.
Good luck.
#AIX-Forum

Originally posted by: PopeyeSailor

sar command is good for system activity reporting .. you can store in files as well.

http://publib.boulder.ibm.com/infocenter/pseries/v5r3/index.jsp?topic=/com.ibm.aix.cmds/doc/aixcmds5/sar.htm
#AIX-Forum