sysmaster slow

--0-1676693089-1106265736=:84859 Content-Type: text/plain; charset=us-ascii Can anyone tell me why my rootdbs is being hit so hard ? Below is a partial output, sorted by io, of an onstat -g iof. When I try and query tables in sysmaster, it takes forever, and am wondering if the heavily used rootdbs has something to do with it. Is there a way of finding out what is going on in that rootdbs ? Thanks, IBM Informix Dynamic Server Version 9.40.FC3 -- On-Line -- Up 2 days 20:00:12 -- 4585232 Kbytes 171 prod_root_c2 2771643 2757214 14429 175.6 3 prod_root_c1 2141522 2138057 3465 135.7 191 prod_stpx2c1 861237 854256 6981 54.6 201 /dev/prod_stx_c1 553963 550476 3487 35.1 202 /dev/prod_stx_c2 306934 299433 7501 19.4 102 /dev/prod_tmp3c1 303168 14233 288935 19.2 9 prod_stpf6c1 298403 296762 1641 18.9 160 prod_gsid_c4 294784 292434 2350 18.7 74 /dev/prod_tmp1c1 291313 25583 265730 18.5 138 prod_gsid_c1 283731 281398 2333 18.0 100 /dev/prod_tmp2c1 262428 26478 235950 16.6 86 prod_stpf3c1 257166 247665 9501 16.3 159 prod_gsid_c3 243128 241057 2071 15.4 85 prod_stpf2c1 233882 231671 2211 14.8 48 prod_tsub_c4 226468 120469 105999 14.3 87 prod_stpf4c1 216517 210033 6484 13.7 199 /dev/prod_stu_c1 203175 200798 2377 12.9 11 prod_stpf9c1 204380 199285 5095 12.9 143 prod_gsid_c2 200564 198569 1995 12.7 7 prod_stpf7c1 194700 193566 1134 12.3 84 prod_stpf1c1 185105 181710 3395 11.7 8 prod_stpf5c1 161562 160275 1287 10.2 212 prod_gsid_c5 135067 132928 2139 8.6 10 prod_stpf8c1 129790 129127 663 8.2 208 prod_slog_c1 98419 98000 419 6.2 273 prod_dtlf6_c2 95255 95255 0 6.0 195 prod_rptq_c1 90133 32219 57914 5.7 68 prod_ssub_c3 89936 57358 32578 5.7 252 prod_dtlf1_c1 84076 83846 230 5.3 274 prod_dtlf6_c3 80845 80743 102 5.1 257 prod_dtlf2_c2 79902 79902 0 5.1 217 prod_gsid_c6 80946 78658 2288 5.1 256 prod_dtlf2_c1 79018 79018 0 5.0 254 prod_dtlf1_c3 79160 79160 0 5.0 275 prod_dtlf6_c4 77842 74610 3232 4.9 253 prod_dtlf1_c2 76954 76954 0 4.9 259 prod_dtlf2_c4 73451 73451 0 4.7 ======================== -<<Floyd Wellershaus>>-Database Administrator Unix Administrator email: fwellers@yahoo.com Work: 703-733-4126 Pager: 703-705-9241 Email Pager: 7037059241@my2way.com Home: 703-430-0805 Cell: 703-477-6045 ======================== --0-1676693089-1106265736=:84859 Content-Type: text/html; charset=us-ascii <DIV> <DIV>Can anyone tell me why my rootdbs is being hit so hard ?</DIV> <DIV>Below is a partial output, sorted by io, of an onstat -g iof. </DIV> <DIV>&nbsp;</DIV> <DIV>When I try and query tables in sysmaster, it takes forever, and am wondering if the heavily used rootdbs has something to do with it. Is there a way of finding out what is going on in that rootdbs ?</DIV> <DIV>&nbsp;</DIV> <DIV>Thanks,</DIV> <DIV>IBM Informix Dynamic Server Version 9.40.FC3&nbsp;&nbsp;&nbsp;&nbsp; -- On-Line -- Up 2 days 20:00:12 -- 4585232 Kbytes<BR>171 prod_root_c2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2771643&nbsp; 2757214&nbsp;&nbsp;&nbsp; 14429 175.6<BR>&nbsp; 3 prod_root_c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2141522&nbsp; 2138057&nbsp;&nbsp;&nbsp;&nbsp; 3465 135.7<BR>191 prod_stpx2c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 861237&nbsp;&nbsp; 854256&nbsp;&nbsp;&nbsp;&nbsp; 6981&nbsp; 54.6<BR>201 /dev/prod_stx_c1&nbsp;&nbsp; 553963&nbsp;&nbsp; 550476&nbsp;&nbsp;&nbsp;&nbsp; 3487&nbsp; 35.1<BR>202 /dev/prod_stx_c2&nbsp;&nbsp; 306934&nbsp;&nbsp; 299433&nbsp;&nbsp;&nbsp;&nbsp; 7501&nbsp; 19.4<BR>102 /dev/prod_tmp3c1&nbsp;&nbsp; 303168&nbsp;&nbsp;&nbsp; 14233&nbsp;&nbsp; 288935&nbsp; 19.2<BR>&nbsp; 9 prod_stpf6c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 298403&nbsp;&nbsp; 296762&nbsp;&nbsp;&nbsp;&nbsp; 1641&nbsp; 18.9<BR>160 prod_gsid_c4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 294784&nbsp;&nbsp; 292434&nbsp;&nbsp;&nbsp;&nbsp; 2350&nbsp; 18.7<BR>&nbsp;74 /dev/prod_tmp1c1&nbsp;&nbsp; 291313&nbsp;&nbsp;&nbsp; 25583&nbsp;&nbsp; 265730&nbsp; 18.5<BR>138 prod_gsid_c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 283731&nbsp;&nbsp; 281398&nbsp;&nbsp;&nbsp;&nbsp; 2333&nbsp; 18.0<BR>100 /dev/prod_tmp2c1&nbsp;&nbsp; 262428&nbsp;&nbsp;&nbsp; 26478&nbsp;&nbsp; 235950&nbsp; 16.6<BR>&nbsp;86 prod_stpf3c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 257166&nbsp;&nbsp; 247665&nbsp;&nbsp;&nbsp;&nbsp; 9501&nbsp; 16.3<BR>159 prod_gsid_c3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 243128&nbsp;&nbsp; 241057&nbsp;&nbsp;&nbsp;&nbsp; 2071&nbsp; 15.4<BR>&nbsp;85 prod_stpf2c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 233882&nbsp;&nbsp; 231671&nbsp;&nbsp;&nbsp;&nbsp; 2211&nbsp; 14.8<BR>&nbsp;48 prod_tsub_c4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 226468&nbsp;&nbsp; 120469&nbsp;&nbsp; 105999&nbsp; 14.3<BR>&nbsp;87 prod_stpf4c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 216517&nbsp;&nbsp; 210033&nbsp;&nbsp;&nbsp;&nbsp; 6484&nbsp; 13.7<BR>199 /dev/prod_stu_c1&nbsp;&nbsp; 203175&nbsp;&nbsp; 200798&nbsp;&nbsp;&nbsp;&nbsp; 2377&nbsp; 12.9<BR>&nbsp;11 prod_stpf9c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 204380&nbsp;&nbsp; 199285&nbsp;&nbsp;&nbsp;&nbsp; 5095&nbsp; 12.9<BR>143 prod_gsid_c2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200564&nbsp;&nbsp; 198569&nbsp;&nbsp;&nbsp;&nbsp; 1995&nbsp; 12.7<BR>&nbsp; 7 prod_stpf7c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 194700&nbsp;&nbsp; 193566&nbsp;&nbsp;&nbsp;&nbsp; 1134&nbsp; 12.3<BR>&nbsp;84 prod_stpf1c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 185105&nbsp;&nbsp; 181710&nbsp;&nbsp;&nbsp;&nbsp; 3395&nbsp; 11.7<BR>&nbsp; 8 prod_stpf5c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 161562&nbsp;&nbsp; 160275&nbsp;&nbsp;&nbsp;&nbsp; 1287&nbsp; 10.2<BR>212 prod_gsid_c5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 135067&nbsp;&nbsp; 132928&nbsp;&nbsp;&nbsp;&nbsp; 2139&nbsp;&nbsp; 8.6<BR>&nbsp;10 prod_stpf8c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 129790&nbsp;&nbsp; 129127&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 663&nbsp;&nbsp; 8.2<BR>208 prod_slog_c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 98419&nbsp;&nbsp;&nbsp; 98000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 419&nbsp;&nbsp; 6.2<BR>273 prod_dtlf6_c2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 95255&nbsp;&nbsp;&nbsp; 95255&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 6.0<BR>195 prod_rptq_c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90133&nbsp;&nbsp;&nbsp; 32219&nbsp;&nbsp;&nbsp; 57914&nbsp;&nbsp; 5.7<BR>&nbsp;68 prod_ssub_c3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 89936&nbsp;&nbsp;&nbsp; 57358&nbsp;&nbsp;&nbsp; 32578&nbsp;&nbsp; 5.7<BR>252 prod_dtlf1_c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 84076&nbsp;&nbsp;&nbsp; 83846&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 230&nbsp;&nbsp; 5.3<BR>274 prod_dtlf6_c3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80845&nbsp;&nbsp;&nbsp; 80743&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102&nbsp;&nbsp; 5.1<BR>257 prod_dtlf2_c2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79902&nbsp;&nbsp;&nbsp; 79902&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 5.1<BR>217 prod_gsid_c6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80946&nbsp;&nbsp;&nbsp; 78658&nbsp;&nbsp;&nbsp;&nbsp; 2288&nbsp;&nbsp; 5.1<BR>256 prod_dtlf2_c1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 79018&nbsp;&nbsp;&nbsp; 79018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp; 5.0<BR>254 prod

"Floyd Wellershaus" <fwellers@yahoo.com> wrote in message news:1106269813.b17fb35d3b6cac456eec0d6b608d49c8@teranews... > > --0-1676693089-1106265736=:84859 > Content-Type: text/plain; charset=us-ascii > > Can anyone tell me why my rootdbs is being hit so hard ? > Below is a partial output, sorted by io, of an onstat -g iof. > > When I try and query tables in sysmaster, it takes forever, and am > wondering if the heavily used rootdbs has something to do with it. Is > there a way of finding out what is going on in that rootdbs ? Please don't post MIME. Where is your physical log placed, and do you have separate temp dbspaces? oncheck -pe will show you the contents of each dbspace: running this at slowtime may give some clues.