informix performance related statistics -- Posted by inturi on Friday, April 24 2009
informix performance related statistics
onstat -g iov # AIO VP statistics
onstat -g ioq # AIO pending request statistics
onstat -g iof # file level statistics
onstat -D #chunk level statistics
onstat -p #cache read and write persentage
onstat -P #buffer pool statistics for each partnum
onstat -g buf #individula buffer pool statistics
onstat -g ckp #check point statistics
onstat -g ppf #table partition statistics
onstat -g tpf #thread level statistics
onstat -g cpu #thread level cpu statistics
onstat -F #foreground writes and LRU cleaner thread(flushers) statistics
onstat -R #LRU queue statistics
onstat -g stm #current active sql statements and their memory consumption
onstat -g sql 0 #current active sql statements
onstat -g his #query drill down hostory. Need to enable sql tracing
onstat -g lsc #for light scan statistics