Re: RE: Which session is using the most cpu resour

Thank you Michaelis. I am also looking similar to this scenario. That is how to find sessions which are using more system resources? Here are few sample output based on instruction in your post: Top command: top - 12:59:22 up 318 days, 20:53, 2 users, load average: 3.19, 3.93, 4.37 Tasks: 1038 total, 4 running, 1034 sleeping, 0 stopped, 0 zombie Cpu(s): 4.4%us, 0.2%sy, 0.0%ni, 95.3%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 396867876k total, 389190032k used, 7677844k free, 180780k buffers Swap: 65535996k total, 391424k used, 65144572k free, 338482608k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 10845 informix 10 -10 185g 131g 131g S 59.5 34.7 26346:14 oninit 10901 informix 10 -10 185g 128g 128g S 52.6 34.0 2905:17 oninit 10894 informix 10 -10 185g 129g 129g R 39.0 34.2 34921:51 oninit 10895 informix 10 -10 185g 129g 129g R 25.5 34.2 20324:31 oninit 10896 informix 10 -10 185g 129g 129g R 24.5 34.2 11841:13 oninit ... $onstat -g glo IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line (Prim) -- Up 172 days 20:35:13 -- 194024048 Kbytes MT global info: sessions threads vps lngspins 451 938 190 7206384 sched calls thread switches yield 0 yield n yield forever total: 868223877 1125682961 4155947712 3397828556 4077377433 per sec: 67312 3369 63964 31 390 Virtual processor summary: class vps usercpu syscpu total cpu 47 11334877.22 122653.68 11457530.90 aio 128 73405.54 536062.87 609468.41 lio 1 93.02 1031.36 1124.38 pio 1 42.59 561.37 603.96 adm 1 2193.20 3359.28 5552.48 soc 8 53813.52 70545.24 124358.76 msc 1 702.50 1131.97 1834.47 jvp 2 4060.03 1461.38 5521.41 fifo 1 27.68 85.75 113.43 total 190 11469215.30 736892.90 12206108.20 Individual virtual processors: vp pid class usercpu syscpu total Thread Eff 1 10845 cpu 1168193.33 32603.78 1200797.11 1200797.11 100% 2 10855 adm 2193.20 3359.28 5552.48 0.00 0% 3 10881 lio 93.02 1031.36 1124.38 6292.26 17% 4 10889 pio 42.59 561.37 603.96 4241.04 14% 5 10890 aio 22094.77 184048.57 206143.34 884370.47 23% 6 10891 msc 702.50 1131.97 1834.47 11933.31 15% 7 10892 fifo 27.68 85.75 113.43 0.00 0% 8 10894 cpu 1561030.73 30491.99 1591522.72 1591522.72 100% 9 10895 cpu 906011.37 16282.53 922293.90 922293.90 100% 10 10896 cpu 523305.16 7572.53 530877.69 530877.69 100% 11 10897 cpu 313457.73 3560.74 317018.47 317018.47 100% 12 10898 cpu 212076.47 1911.06 213987.53 213987.53 100% 13 10899 cpu 152093.84 1170.80 153264.64 153264.64 100% 14 10900 cpu 161025.05 913.38 161938.43 161938.43 100% 15 10901 cpu 131959.07 805.11 132764.18 132764.18 100% 16 10902 cpu 118550.31 756.61 119306.92 119306.92 100% 17 10903 cpu 130188.71 730.42 130919.13 130919.13 100% ... onstat -g act:Running threads: tid tcb rstcb prty status vp-class name 8 20720fbd48 0 1 running 56soc* soctcppoll 9 2072102b60 0 1 running 57soc* soctcppoll 10 20721098b0 0 1 running 58soc* soctcppoll 11 20721108b0 0 1 running 59soc* soctcppoll 12 20721178b0 0 1 running 60soc* soctcppoll 13 207211e8b0 0 1 running 61soc* soctcppoll 14 20721258b0 0 1 running 62soc* soctcppoll 15 207212c8b0 0 1 running 63soc* soctcppoll 71110497 209263e468 20bd0c4290 1 running 8cpu sqlexec 71378770 20ae229d20 20cf7da9e0 1 running 1cpu sqlexec 71378780 209d111028 2076b27f18 1 running 9cpu sqlexec But is there any way, I can extract the session id based on pid or tid from above output? Thanks in advance!!! ~ Pravin Bankar pravinebankar@gmail.com

You can query the syssessions and sysrstcb tables in sysmaster to map the SID, TID and PID: select r.sid, r.tid, s.pid from sysrstcb r, syssessions s where s.sid = r.sid; You can also join to systcblst if you want to see the CPU time consumed by a session, which is kind of handy. Mike Walker Advanced DataTools Corporation -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PRAVIN BANKAR Sent: Tuesday, November 03, 2015 11:16 AM To: ids@iiug.org Subject: Re: RE: Which session is using the most cpu re.... [35990] Thank you Michaelis. I am also looking similar to this scenario. That is how to find sessions which are using more system resources? Here are few sample output based on instruction in your post: Top command: top - 12:59:22 up 318 days, 20:53, 2 users, load average: 3.19, 3.93, 4.37 Tasks: 1038 total, 4 running, 1034 sleeping, 0 stopped, 0 zombie Cpu(s): 4.4%us, 0.2%sy, 0.0%ni, 95.3%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 396867876k total, 389190032k used, 7677844k free, 180780k buffers Swap: 65535996k total, 391424k used, 65144572k free, 338482608k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 10845 informix 10 -10 185g 131g 131g S 59.5 34.7 26346:14 oninit 10901 informix 10 -10 185g 128g 128g S 52.6 34.0 2905:17 oninit 10894 informix 10 -10 185g 129g 129g R 39.0 34.2 34921:51 oninit 10895 informix 10 -10 185g 129g 129g R 25.5 34.2 20324:31 oninit 10896 informix 10 -10 185g 129g 129g R 24.5 34.2 11841:13 oninit .... $onstat -g glo IBM Informix Dynamic Server Version 11.70.FC7 -- On-Line (Prim) -- Up 172days 20:35:13 -- 194024048 Kbytes MT global info: sessions threads vps lngspins 451 938 190 7206384 sched calls thread switches yield 0 yield n yield forever total: 868223877 1125682961 4155947712 3397828556 4077377433 per sec: 67312 3369 63964 31 390 Virtual processor summary: class vps usercpu syscpu total cpu 47 11334877.22 122653.68 11457530.90 aio 128 73405.54 536062.87 609468.41 lio 1 93.02 1031.36 1124.38 pio 1 42.59 561.37 603.96 adm 1 2193.20 3359.28 5552.48 soc 8 53813.52 70545.24 124358.76 msc 1 702.50 1131.97 1834.47 jvp 2 4060.03 1461.38 5521.41 fifo 1 27.68 85.75 113.43 total 190 11469215.30 736892.90 12206108.20 Individual virtual processors: vp pid class usercpu syscpu total Thread Eff 1 10845 cpu 1168193.33 32603.78 1200797.11 1200797.11 100% 2 10855 adm 2193.20 3359.28 5552.48 0.00 0% 3 10881 lio 93.02 1031.36 1124.38 6292.26 17% 4 10889 pio 42.59 561.37 603.96 4241.04 14% 5 10890 aio 22094.77 184048.57 206143.34 884370.47 23% 6 10891 msc 702.50 1131.97 1834.47 11933.31 15% 7 10892 fifo 27.68 85.75 113.43 0.00 0% 8 10894 cpu 1561030.73 30491.99 1591522.72 1591522.72 100% 9 10895 cpu 906011.37 16282.53 922293.90 922293.90 100% 10 10896 cpu 523305.16 7572.53 530877.69 530877.69 100% 11 10897 cpu 313457.73 3560.74 317018.47 317018.47 100% 12 10898 cpu 212076.47 1911.06 213987.53 213987.53 100% 13 10899 cpu 152093.84 1170.80 153264.64 153264.64 100% 14 10900 cpu 161025.05 913.38 161938.43 161938.43 100% 15 10901 cpu 131959.07 805.11 132764.18 132764.18 100% 16 10902 cpu 118550.31 756.61 119306.92 119306.92 100% 17 10903 cpu 130188.71 730.42 130919.13 130919.13 100% .... onstat -g act:Running threads: tid tcb rstcb prty status vp-class name 8 20720fbd48 0 1 running 56soc* soctcppoll 9 2072102b60 0 1 running 57soc* soctcppoll 10 20721098b0 0 1 running 58soc* soctcppoll 11 20721108b0 0 1 running 59soc* soctcppoll 12 20721178b0 0 1 running 60soc* soctcppoll 13 207211e8b0 0 1 running 61soc* soctcppoll 14 20721258b0 0 1 running 62soc* soctcppoll 15 207212c8b0 0 1 running 63soc* soctcppoll 71110497 209263e468 20bd0c4290 1 running 8cpu sqlexec 71378770 20ae229d20 20cf7da9e0 1 running 1cpu sqlexec 71378780 209d111028 2076b27f18 1 running 9cpu sqlexec But is there any way, I can extract the session id based on pid or tid from above output? Thanks in advance!!! ~ Pravin Bankar pravinebankar@gmail.com **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

since 11.50 there is also an onstat available for that purpose - onstat -g cpu

Thank you Mike and Wolfgang.