SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:38 PM
| ||||
| ||||
 Re: Tuning IDS 9.30 after migration from IDS7.31 dthacker@omnihotels.com (Dave Thacker) wrote in message news:<554c618d.0308280657.2c8627bd@posting.google. com>... > We've recently migrated from 7.31UC5 to 9.30UC5. Our platform is AIX 4.3.3. > The hardware is an S7A with twelve CPU's. KAIO is enabled. The machine runs > both the database and 4gl, c, and perl applications that connect to the > database. There are also many remote applications that connect to the > database via tcp/ip. The application is heavily OLTP, there is little DSS > work running on the box. After the upgrade, we've experienced a 50% increase > in the response time to one of our key applications. We'd been running 7.3x > for a long time and had our tuning down pretty well, we kept database > structure and applications static while the upgrade took place, so my feeling > is that I'm just not tuned properly. I'll throw this before the group with as > many onstat commands as I can remember being requested on previous cases. > Please take a look and see if you can see any fatal flaws. > <original output snipped> This morning I received a request for more diagnostics.. >>Post an onstat -g seg, onstat -g ntu, onstat -d, onstat -g iof, onstat -g ioq >>How much memory can you use for the Informix instance? 2-3GB out of 4GB total. >>How much is on the box? 4GB >>Do your users connect via shared memory or soc? Both. Diag output follows onstat -g seg Informix Dynamic Server Version 9.30.UC5 -- On-Line -- Up 3 days 10:26:39 -- 953968 Kbytes Segment Summary: id key addr size ovhd class blkused blkfree 96469010 1388660737 30000000 632242176 234076 R 154331 25 899940362 1388660738 60000000 335872000 10856 V 49958 32042 71565323 1388660739 80000000 1458176 648 M 330 26 2097168 1388660740 90000000 1458176 648 M 324 32 5373965 1388660741 a0000000 1458176 648 M 324 32 21889036 1388660742 b0000000 1458176 648 M 324 32 1572881 1388660743 c0000000 1458176 648 M 324 32 3801097 1388660744 e0000000 1458176 648 M 324 32 Total: - - 976863232 - - 206239 32253 (* segment locked in memory) onstat -g ntu Informix Dynamic Server Version 9.30.UC5 -- On-Line -- Up 3 days 10:27:54 -- 953968 Kbytes global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 307/ 330 44270 92485769 96145565 9/ 66 170/ 10 0/ 9 114/ 114 Individual thread network information (basic): netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp 61d1a080 soctcp sqlexec 210567 72 5 89 88 0/ 1 0/ 1 0/ 0 64f72df0 ipcshm sqlexec 210553 0 0 41 50 -10/ 0 0/ 0 0/ 0 60f2f8e0 soctcp sqlexec 210554 103 5 52 52 0/ 1 1/ 1 0/ 0 68e76498 ipcshm sqlexec 210411 0 0 16 20 -4/ 0 0/ 0 0/ 0 6248de18 ipcshm sqlexec 210410 0 0 893 958 -236/ 0 0/ 0 0/ 0 694bbe50 soctcp sqlexec 210295 106 6 202 202 0/ 1 1/ 1 0/ 0 61daa6a0 soctcp sqlexec 210076 94 5 210215 210216 0/ 1 0/ 1 0/ 0 66388790 ipcshm sqlexec 210073 0 0 215 234 -75/ 0 0/ 0 0/ 0 68f06c18 ipcshm sqlexec 210049 0 0 16 20 -1/ 0 0/ 0 0/ 0 6374d0e8 ipcshm sqlexec 210037 0 0 2426 2696 -605/ 0 0/ 0 0/ 0 6609bd68 ipcshm sqlexec 209946 0 0 696 2742 -423/ 0 0/ 0 0/ 0 632db5d0 ipcshm sqlexec 209932 0 0 2886 3002 -1096/ 0 0/ 0 0/ 0 63680580 ipcshm sqlexec 209813 0 0 178 199 -49/ 0 0/ 0 0/ 0 60dc1128 ipcshm sqlexec 209805 0 0 1572 1615 -385/ 0 0/ 0 0/ 0 631bedd8 ipcshm sqlexec 209719 0 0 13562 13726 -5895/ 0 0/ 0 0/ 0 677fce10 soctcp sqlexec 209672 105 5 1530 1530 0/ 1 1/ 1 0/ 0 66fbad50 soctcp sqlexec 209660 89 5 559 559 0/ 1 1/ 1 0/ 0 68e27488 soctcp sqlexec 209656 82 6 713 713 0/ 1 1/ 1 0/ 0 61f94df0 soctcp sqlexec 209653 79 5 710 710 0/ 1 1/ 1 0/ 0 63f7b0a0 soctcp sqlexec 209643 69 5 1390 1390 0/ 1 1/ 1 0/ 0 68f51b20 soctcp sqlexec 209633 60 6 1986 1986 0/ 1 1/ 1 0/ 0 6108f4b0 soctcp sqlexec 209629 62 5 731 731 0/ 1 1/ 1 0/ 0 6375db20 soctcp sqlexec 209626 66 6 330 330 0/ 1 1/ 1 0/ 0 6d3d4518 soctcp sqlexec 209617 61 6 2790 2790 0/ 1 1/ 1 0/ 0 69a32bf8 soctcp sqlexec 209612 59 6 936 936 0/ 1 1/ 1 0/ 0 635860f0 soctcp sqlexec 209604 55 5 1204 1204 0/ 1 1/ 1 0/ 0 62924608 soctcp sqlexec 209598 58 6 701 701 0/ 1 1/ 1 0/ 0 631be5a0 soctcp sqlexec 209592 57 6 829 829 0/ 1 1/ 1 0/ 0 62a74b00 soctcp sqlexec 209588 56 5 835 835 0/ 1 1/ 1 0/ 0 60b50e28 soctcp sqlexec 209578 51 5 958 958 0/ 1 1/ 1 0/ 0 63f81d98 soctcp sqlexec 209574 54 6 806 806 0/ 1 1/ 1 0/ 0 6108fd10 soctcp sqlexec 209565 42 6 698 698 0/ 1 1/ 1 0/ 0 62441218 soctcp sqlexec 209549 48 6 780 780 0/ 1 1/ 1 0/ 0 62a28db8 soctcp sqlexec 209543 50 6 756 756 0/ 1 1/ 1 0/ 0 64e91080 soctcp sqlexec 209541 49 5 917 917 0/ 1 1/ 1 0/ 0 64930520 soctcp sqlexec 209528 38 5 830 830 0/ 1 1/ 1 0/ 0 6202b708 soctcp sqlexec 209526 39 5 708 708 0/ 1 1/ 1 0/ 0 64cd2d48 soctcp sqlexec 209522 24 5 639 639 0/ 1 1/ 1 0/ 0 62981030 soctcp sqlexec 209515 23 6 1303 1303 0/ 1 1/ 1 0/ 0 684cc658 soctcp sqlexec 209514 11 5 911 911 0/ 1 1/ 1 0/ 0 663881f0 soctcp sqlexec 209510 32 6 1437 1437 0/ 1 1/ 1 0/ 0 620b9080 soctcp sqlexec 209501 29 5 833 833 0/ 1 1/ 1 0/ 0 61d3b4d0 soctcp sqlexec 209499 26 6 704 704 0/ 1 1/ 1 0/ 0 60009a58 soctcp sqlexec 209496 17 5 815 815 0/ 1 1/ 1 0/ 0 624dc568 soctcp sqlexec 209484 13 6 1054 1054 0/ 1 1/ 1 0/ 0 6202b030 soctcp sqlexec 209475 18 5 931 931 0/ 1 1/ 1 0/ 0 627bce60 soctcp sqlexec 209464 14 6 827 827 0/ 1 1/ 1 0/ 0 60b40080 soctcp sqlexec 209461 20 6 848 848 0/ 1 1/ 1 0/ 0 6bc59ac8 soctcp sqlexec 209450 10 5 862 862 0/ 1 1/ 1 0/ 0 6252b7a8 ipcshm sqlexec 209298 0 0 1803 1833 -743/ 0 0/ 0 0/ 0 608228a8 soctcp sqlexec 209296 9 5 459 620 0/ 1 1/ 1 0/ 0 6491a3c0 soctcp sqlexec 209282 2 5 12 12 0/ 1 1/ 1 0/ 0 67120df0 ipcshm sqlexec 209027 0 0 5380 5701 -1507/ 0 0/ 0 0/ 0 65f9b5a8 ipcshm sqlexec 208661 0 0 781 810 -122/ 0 0/ 0 0/ 0 64e81178 ipcshm sqlexec 208621 0 0 4388 4567 -1286/ 0 0/ 0 0/ 0 68bb7b50 ipcshm sqlexec 208307 0 0 18793 19108 -6363/ 0 0/ 0 0/ 0 640da710 ipcshm sqlexec 208116 0 0 4656 4721 -1481/ 0 0/ 0 0/ 0 62734080 soctcp sqlexec 207968 104 5 27 27 0/ 1 1/ 1 0/ 0 6609bb20 ipcshm sqlexec 207916 0 0 7 8 0/ 0 0/ 0 0/ 0 6ae2a080 ipcshm sqlexec 207874 0 0 3129 3681 -1108/ 0 0/ 0 0/ 0 6248d030 soctcp sqlexec 207858 100 5 7 7 0/ 1 1/ 1 0/ 0 62b70bd8 ipcshm sqlexec 207870 0 0 319822 332066 -135029/ 0 0/ 0 0/ 0 62c19080 ipcshm sqlexec 207868 0 0 334561 347046 -144736/ 0 0/ 0 0/ 0 6ac10938 ipcshm sqlexec 207859 0 0 348290 360843 -141067/ 0 0/ 0 0/ 0 61de6e00 ipcshm sqlexec 207867 0 0 324956 336622 -127778/ 0 0/ 0 0/ 0 61f60060 ipcshm sqlexec 207866 0 0 335222 347622 -128726/ 0 0/ 0 0/ 0 62ac38e0 ipcshm sqlexec 207865 0 0 2632 3132 -1100/ 0 0/ 0 0/ 0 627bc850 ipcshm sqlexec 207864 0 0 6 10 -1/ 0 0/ 0 0/ 0 63f96b70 ipcshm sqlexec 207860 0 0 12602 13963 -4258/ 0 0/ 0 0/ 0 62111dd8 ipcshm sqlexec 207863 0 0 3066 3606 -1053/ 0 0/ 0 0/ 0 6462bba0 ipcshm sqlexec 207850 0 0 2774 3318 -1185/ 0 0/ 0 0/ 0 637a71d8 ipcshm sqlexec 207861 0 0 120 148 -44/ 0 0/ 0 0/ 0 6b3d8c88 ipcshm sqlexec 207855 0 0 28408 30610 -10362/ 0 0/ 0 0/ 0 63564d38 ipcshm sqlexec 207856 0 0 3754 4058 -1461/ 0 0/ 0 0/ 0 6acaf080 ipcshm sqlexec 207857 0 0 2966 3339 -1100/ 0 0/ 0 0/ 0 669ca680 ipcshm sqlexec 207766 0 0 100 189 -6/ 0 0/ 0 0/ 0 6697b968 ipcshm sqlexec 207740 0 0 18299 18665 -5325/ 0 0/ 0 0/ 0 6217c030 ipcshm sqlexec 207681 0 0 19242 19821 -5913/ 0 0/ 0 0/ 0 635b3080 ipcshm sqlexec 207632 0 0 370 440 -84/ 0 0/ 0 0/ 0 6aa57bb0 ipcshm sqlexec 207626 0 0 464 483 -131/ 0 0/ 0 0/ 0 6697bbb0 ipcshm sqlexec 207434 0 0 4035 4440 -1253/ 0 0/ 0 0/ 0 6c4d4bf0 ipcshm sqlexec 207365 0 0 908 945 -175/ 0 0/ 0 0/ 0 688c1350 ipcshm sqlexec 207232 0 0 13863 14116 -3120/ 0 0/ 0 0/ 0 6c179478 ipcshm sqlexec 207197 0 0 25821 26485 -6852/ 0 0/ 0 0/ 0 6d3d4ca0 ipcshm sqlexec 207134 0 0 2312 2381 -619/ 0 0/ 0 0/ 0 61d20080 ipcshm sqlexec 207079 0 0 156 173 -32/ 0 0/ 0 0/ 0 6ac73da8 ipcshm sqlexec 207057 0 0 21641 22210 -8169/ 0 0/ 0 0/ 0 6d3cad98 ipcshm sqlexec 206950 0 0 27299 28040 -8051/ 0 0/ 0 0/ 0 693b2c18 ipcshm sqlexec 206883 0 0 37 43 -4/ 0 0/ 0 0/ 0 679cbcb0 ipcshm sqlexec 206684 0 0 4501 4840 -1803/ 0 0/ 0 0/ 0 66784350 ipcshm sqlexec 206675 0 0 240 298 -10/ 0 0/ 0 0/ 0 65838de0 ipcshm sqlexec 206648 0 0 21 26 0/ 0 0/ 0 0/ 0 6ae8f080 ipcshm sqlexec 206620 0 0 27162 27984 -7395/ 0 0/ 0 0/ 0 63f90338 ipcshm sqlexec 206545 0 0 7535 7702 -1877/ 0 0/ 0 0/ 0 6bf00ce0 ipcshm sqlexec 206492 0 0 33 56 0/ 0 0/ 0 0/ 0 6b3d8ac8 ipcshm sqlexec 206447 0 0 1273 1308 -515/ 0 0/ 0 0/ 0 6437fdd8 ipcshm sqlexec 206381 0 0 13323 13584 -4739/ 0 0/ 0 0/ 0 6b8dcc20 ipcshm sqlexec 206191 0 0 1375 1489 -294/ 0 0/ 0 0/ 0 68d465f8 ipcshm sqlexec 206175 0 0 90 98 -20/ 0 0/ 0 0/ 0 63612678 ipcshm sqlexec 206042 0 0 9 13 0/ 0 0/ 0 0/ 0 6bc59ca8 ipcshm sqlexec 205903 0 0 237 293 -39/ 0 0/ 0 0/ 0 66784b20 ipcshm sqlexec 205651 0 0 795 848 -182/ 0 0/ 0 0/ 0 61df8d18 ipcshm sqlexec 205210 0 0 1333 1403 -408/ 0 0/ 0 0/ 0 63f6c810 ipcshm sqlexec 205197 0 0 901 942 -292/ 0 0/ 0 0/ 0 66784730 ipcshm sqlexec 205054 0 0 3271 3363 -959/ 0 0/ 0 0/ 0 6aa57e50 soctcp sqlexec 204821 35 5 237 239 0/ 1 1/ 1 0/ 0 694e0258 ipcshm sqlexec 204716 0 0 56199 57524 -15488/ 0 0/ 0 0/ 0 635b37b0 ipcshm sqlexec 204253 0 0 78056 79478 -22412/ 0 0/ 0 0/ 0 67e1e458 ipcshm sqlexec 204266 0 0 2485 2573 -694/ 0 0/ 0 0/ 0 6ba3c320 ipcshm sqlexec 204245 0 0 22769 23408 -6461/ 0 0/ 0 0/ 0 69213dd8 ipcshm sqlexec 203401 0 0 766 807 -241/ 0 0/ 0 0/ 0 6b553620 ipcshm sqlexec 203346 0 0 31238 32162 -9667/ 0 0/ 0 0/ 0 63f6c9c8 ipcshm sqlexec 203232 0 0 2519 2645 -638/ 0 0/ 0 0/ 0 61d2f208 ipcshm sqlexec 202958 0 0 13835 14109 -4185/ 0 0/ 0 0/ 0 6acaf608 ipcshm sqlexec 202855 0 0 121 121 -45/ 0 0/ 0 0/ 0 636d1d18 ipcshm sqlexec 202767 0 0 13892 14355 -3079/ 0 0/ 0 0/ 0 636d1080 ipcshm sqlexec 202735 0 0 29525 31199 -9792/ 0 0/ 0 0/ 0 678f5b40 ipcshm sqlexec 202711 0 0 25640 26637 -7759/ 0 0/ 0 0/ 0 6bef0d10 ipcshm sqlexec 202663 0 0 664 694 -174/ 0 0/ 0 0/ 0 68ad3b70 ipcshm sqlexec 202618 0 0 12110 12550 -4299/ 0 0/ 0 0/ 0 671204b0 soctcp sqlexec 202562 110 6 235 251 0/ 1 1/ 1 0/ 0 6bef0b20 ipcshm sqlexec 202458 0 0 1096 1121 -320/ 0 0/ 0 0/ 0 62ab8e60 ipcshm sqlexec 202412 0 0 23557 24335 -7248/ 0 0/ 0 0/ 0 628cbcd0 ipcshm sqlexec 201800 0 0 558 600 -182/ 0 0/ 0 0/ 0 68b75080 ipcshm sqlexec 201769 0 0 14051 14474 -3675/ 0 0/ 0 0/ 0 6bdd4e28 ipcshm sqlexec 201421 0 0 374 399 -67/ 0 0/ 0 0/ 0 68da1db8 ipcshm sqlexec 201077 0 0 3761 3846 -1410/ 0 0/ 0 0/ 0 63d263a0 ipcshm sqlexec 200841 0 0 5931 6222 -2120/ 0 0/ 0 0/ 0 6563a4b0 ipcshm sqlexec 200367 0 0 914 961 -293/ 0 0/ 0 0/ 0 6604b2d8 ipcshm sqlexec 200168 0 0 1310 1359 -563/ 0 0/ 0 0/ 0 660f4a18 ipcshm sqlexec 199082 0 0 16 20 -1/ 0 0/ 0 0/ 0 66161b70 ipcshm sqlexec 199039 0 0 9468 9764 -3014/ 0 0/ 0 0/ 0 62620d28 ipcshm sqlexec 198523 0 0 2220 2314 -672/ 0 0/ 0 0/ 0 620b9698 ipcshm sqlexec 198270 0 0 52735 54605 -16795/ 0 0/ 0 0/ 0 6077a510 ipcshm sqlexec 198241 0 0 16 20 0/ 0 0/ 0 0/ 0 6b2a61d8 soctcp sqlexec 198024 98 5 12 12 0/ 1 1/ 1 0/ 0 620b9aa0 ipcshm sqlexec 197681 0 0 15162 15978 -4025/ 0 0/ 0 0/ 0 61fac638 ipcshm sqlexec 197635 0 0 43105 44680 -12684/ 0 0/ 0 0/ 0 61d7d560 ipcshm sqlexec 197626 0 0 5106 5421 -1288/ 0 0/ 0 0/ 0 6077a018 ipcshm sqlexec 197579 0 0 104 137 -10/ 0 0/ 0 0/ 0 627ca138 ipcshm sqlexec 197531 0 0 41285 42001 -15479/ 0 0/ 0 0/ 0 6780b4e8 ipcshm sqlexec 197095 0 0 2249 2330 -771/ 0 0/ 0 0/ 0 66377c80 ipcshm sqlexec 197103 0 0 90713 93047 -30841/ 0 0/ 0 0/ 0 6755a5c0 ipcshm sqlexec 197027 0 0 67 79 -18/ 0 0/ 0 0/ 0 6011f918 soctcp sqlexec 197004 7 5 12 12 0/ 1 1/ 1 0/ 0 66377a40 ipcshm sqlexec 196978 0 0 6937 7104 -2465/ 0 0/ 0 0/ 0 660f44e0 ipcshm sqlexec 196924 0 0 12188 12461 -3594/ 0 0/ 0 0/ 0 640da350 soctcp sqlexec 196942 19 5 12 12 0/ 1 1/ 1 0/ 0 6780b6d0 soctcp sqlexec 196935 102 6 8 8 0/ 1 1/ 1 0/ 0 68ed2878 ipcshm sqlexec 196832 0 0 101943 104235 -31366/ 0 0/ 0 0/ 0 6706cd38 ipcshm sqlexec 196797 0 0 735 788 -182/ 0 0/ 0 0/ 0 67bf6940 ipcshm sqlexec 196774 0 0 48544 49878 -16074/ 0 0/ 0 0/ 0 6aca2080 ipcshm sqlexec 196769 0 0 6937 7319 -2033/ 0 0/ 0 0/ 0 610e4bd8 ipcshm sqlexec 196701 0 0 14059 14151 -4568/ 0 0/ 0 0/ 0 633a9d58 ipcshm sqlexec 196562 0 0 11073 11347 -4002/ 0 0/ 0 0/ 0 6aca29c0 ipcshm sqlexec 196486 0 0 28236 29038 -7561/ 0 0/ 0 0/ 0 60b80ba0 soctcp sqlexec 196353 101 6 1405 1406 0/ 1 1/ 1 0/ 0 6b5537d8 ipcshm sqlexec 196080 0 0 57200 59480 -17989/ 0 0/ 0 0/ 0 62071e58 ipcshm sqlexec 196067 0 0 16 20 -7/ 0 0/ 0 0/ 0 61d3b8c8 ipcshm sqlexec 196038 0 0 5332 5471 -2060/ 0 0/ 0 0/ 0 64fd1350 ipcshm sqlexec 196014 0 0 51315 52602 -14521/ 0 0/ 0 0/ 0 648b53b0 ipcshm sqlexec 196011 0 0 26355 28120 -7876/ 0 0/ 0 0/ 0 64e913b8 ipcshm sqlexec 195995 0 0 42360 44103 -12216/ 0 0/ 0 0/ 0 6604b080 ipcshm sqlexec 195990 0 0 16 20 0/ 0 0/ 0 0/ 0 68e27d90 ipcshm sqlexec 195934 0 0 93674 95794 -28339/ 0 0/ 0 0/ 0 6217c780 ipcshm ontape 195849 0 0 4605 4604 -11/ 0 0/ 0 0/ 0 61d41cf8 ipcshm sqlexec 195829 0 0 12685 13380 -3773/ 0 0/ 0 0/ 0 663136e8 ipcshm sqlexec 195787 0 0 59231 60695 -20331/ 0 0/ 0 0/ 0 68c31d90 ipcshm sqlexec 195759 0 0 44066 45235 -13865/ 0 0/ 0 0/ 0 668589e8 ipcshm sqlexec 195360 0 0 48829 51069 -14949/ 0 0/ 0 0/ 0 61d3b688 ipcshm sqlexec 195302 0 0 79722 82515 -22137/ 0 0/ 0 0/ 0 68b0e858 ipcshm sqlexec 195251 0 0 21648 22958 -7604/ 0 0/ 0 0/ 0 6bb80750 ipcshm sqlexec 195079 0 0 4911 5143 -1608/ 0 0/ 0 0/ 0 6643de20 ipcshm sqlexec 195074 0 0 3601 3646 -1194/ 0 0/ 0 0/ 0 69a32248 ipcshm sqlexec 195044 0 0 73739 75804 -24375/ 0 0/ 0 0/ 0 660c9330 ipcshm sqlexec 195040 0 0 65133 67331 -19971/ 0 0/ 0 0/ 0 648b0250 soctcp sqlexec 194967 27 5 12 12 0/ 1 1/ 1 0/ 0 6ba3ce60 ipcshm sqlexec 194933 0 0 27446 28329 -8169/ 0 0/ 0 0/ 0 6938ca60 ipcshm sqlexec 194926 0 0 77738 79674 -26115/ 0 0/ 0 0/ 0 66858080 ipcshm sqlexec 194832 0 0 15075 15482 -4894/ 0 0/ 0 0/ 0 6a179b20 ipcshm sqlexec 194530 0 0 45751 47134 -14923/ 0 0/ 0 0/ 0 66313900 ipcshm sqlexec 194239 0 0 29817 30260 -10069/ 0 0/ 0 0/ 0 660c9178 ipcshm sqlexec 194207 0 0 1698 1769 -684/ 0 0/ 0 0/ 0 6b3d8258 ipcshm sqlexec 194095 0 0 129586 135005 -47827/ 0 0/ 0 0/ 0 661236f8 ipcshm sqlexec 193914 0 0 117532 120537 -39679/ 0 0/ 0 0/ 0 691b8650 ipcshm sqlexec 193797 0 0 100738 105446 -34231/ 0 0/ 0 0/ 0 64898890 ipcshm sqlexec 193746 0 0 26005 26762 -9402/ 0 0/ 0 0/ 0 62c1fb30 ipcshm sqlexec 193637 0 0 804 914 -181/ 0 0/ 0 0/ 0 63f73620 ipcshm sqlexec 193609 0 0 78831 81198 -25589/ 0 0/ 0 0/ 0 623328b8 ipcshm sqlexec 193507 0 0 17059 17665 -5614/ 0 0/ 0 0/ 0 68b75670 ipcshm sqlexec 193452 0 0 16 20 -3/ 0 0/ 0 0/ 0 65b88db0 ipcshm sqlexec 193428 0 0 49651 51665 -15467/ 0 0/ 0 0/ 0 61eb4168 ipcshm sqlexec 193307 0 0 107 176 -18/ 0 0/ 0 0/ 0 61ff06c8 ipcshm sqlexec 193286 0 0 101892 104156 -30484/ 0 0/ 0 0/ 0 6217cb18 ipcshm sqlexec 193268 0 0 40187 41436 -13828/ 0 0/ 0 0/ 0 64898080 ipcshm sqlexec 193259 0 0 15642 16036 -4421/ 0 0/ 0 0/ 0 6bdbe080 ipcshm sqlexec 193233 0 0 87080 88824 -36506/ 0 0/ 0 0/ 0 62004478 ipcshm sqlexec 193204 0 0 7117 7222 -1690/ 0 0/ 0 0/ 0 68011080 ipcshm sqlexec 193206 0 0 23947 25994 -7451/ 0 0/ 0 0/ 0 6bdbee40 ipcshm sqlexec 193096 0 0 50957 52196 -20014/ 0 0/ 0 0/ 0 60c01798 ipcshm sqlexec 193086 0 0 20076 20816 -6125/ 0 0/ 0 0/ 0 6643d540 ipcshm sqlexec 193073 0 0 40624 42098 -12940/ 0 0/ 0 0/ 0 63f3bdf0 ipcshm sqlexec 193003 0 0 664 757 -138/ 0 0/ 0 0/ 0 6b3d88a8 soctcp sqlexec 192963 90 6 153758 172966 0/ 1 1/ 1 0/ 0 68b0e228 soctcp sqlexec 192962 46 5 13 13 0/ 1 1/ 1 0/ 0 6344f080 ipcshm sqlexec 192959 0 0 8386 8730 -1833/ 0 0/ 0 0/ 0 63fb4da0 ipcshm sqlexec 192889 0 0 26394 27329 -8874/ 0 0/ 0 0/ 0 65f46d40 ipcshm sqlexec 192824 0 0 16 20 -1/ 0 0/ 0 0/ 0 62c04da0 ipcshm sqlexec 192802 0 0 46863 48621 -16754/ 0 0/ 0 0/ 0 6277c9a8 ipcshm sqlexec 192749 0 0 56510 58808 -16978/ 0 0/ 0 0/ 0 69a32080 ipcshm sqlexec 192753 0 0 52512 53779 -19583/ 0 0/ 0 0/ 0 626d7080 soctcp sqlexec 192288 92 6 1927 1927 0/ 1 1/ 1 0/ 0 61ea0e00 soctcp sqlexec 192274 99 6 229 233 0/ 1 1/ 1 0/ 0 671168c0 soctcp sqlexec 192254 85 5 56 56 0/ 1 1/ 1 0/ 0 683b5df0 soctcp sqlexec 192221 95 6 12 12 0/ 1 1/ 1 0/ 0 62924b38 soctcp sqlexec 192088 96 5 12 12 0/ 1 1/ 1 0/ 0 62e71e58 soctcp sqlexec 192084 36 6 8 8 0/ 1 1/ 1 0/ 0 664ddc18 soctcp sqlexec 191294 47 6 2409 2239 0/ 2 1/ 1 0/ 0 67103030 soctcp sqlexec 191121 25 6 12 12 0/ 1 1/ 1 0/ 0 693f2408 ipcshm sqlexec 191004 0 0 41205 42331 -14488/ 0 0/ 0 0/ 0 63fcbdf0 ipcshm sqlexec 190173 0 0 11138 11670 -4214/ 0 0/ 0 0/ 0 6377fe40 soctcp sqlexec 190189 34 5 2985 2985 0/ 1 1/ 1 0/ 0 62ed5250 soctcp sqlexec 189855 41 6 2611 2611 0/ 1 1/ 1 0/ 0 66de0e48 ipcshm sqlexec 187459 0 0 14411 14837 -5171/ 0 0/ 0 0/ 0 67bf6b80 soctcp sqlexec 187415 70 5 33614 33654 0/ 1 1/ 1 0/ 0 649e7e58 soctcp sqlexec 187405 33 5 56 56 0/ 1 1/ 1 0/ 0 69b1b4d8 soctcp sqlexec 187185 93 5 11143 11143 0/ 1 1/ 1 0/ 0 64658060 ipcshm sqlexec 186696 0 0 19738 21393 -7391/ 0 0/ 0 0/ 0 628e2030 ipcshm sqlexec 186087 0 0 16 16 -2/ 0 0/ 0 0/ 0 62021080 soctcp sqlexec 185750 6 5 5809 5439 0/ 2 1/ 1 0/ 0 62f01450 soctcp sqlexec 185620 86 6 12 12 0/ 1 1/ 1 0/ 0 6252b208 soctcp sqlexec 185424 74 6 7857 8029 0/ 1 1/ 1 0/ 0 61e6c918 soctcp sqlexec 185268 84 6 15778 15775 0/ 1 1/ 1 0/ 0 63f928e0 soctcp sqlexec 184819 88 5 16051 15991 0/ 1 1/ 1 0/ 0 65c18ab0 soctcp sqlexec 184796 73 6 2311 2311 0/ 1 1/ 1 0/ 0 666d0208 ipcshm sqlexec 184683 0 0 7225 7438 -2518/ 0 0/ 0 0/ 0 69310d08 ipcshm sqlexec 184089 0 0 2746 2963 -807/ 0 0/ 0 0/ 0 63f7bd20 soctcp sqlexec 183838 65 6 6552 6191 0/ 1 1/ 1 0/ 0 62767710 soctcp sqlexec 183810 28 6 7063 7063 0/ 1 1/ 1 0/ 0 6b9425d0 soctcp sqlexec 183702 78 5 7871 7871 0/ 1 1/ 1 0/ 0 66fba9c8 soctcp sqlexec 183560 8 5 18476 18463 0/ 2 1/ 1 0/ 0 62ac3030 soctcp sqlexec 183559 71 6 9133 8479 0/ 2 1/ 1 0/ 0 610e4d90 soctcp sqlexec 183334 91 6 7794 7775 0/ 2 1/ 1 0/ 0 62332bd0 soctcp sqlexec 183062 68 5 8 8 0/ 1 1/ 1 0/ 0 67ab84b0 soctcp sqlexec 182836 76 6 17291 17191 0/ 2 1/ 1 0/ 0 648b0060 soctcp sqlexec 182832 64 5 6466 5919 0/ 2 1/ 1 0/ 0 624e1428 soctcp sqlexec 182725 87 6 2690 2511 0/ 2 1/ 1 0/ 0 6584a650 soctcp sqlexec 182669 75 6 11794 11152 0/ 2 1/ 1 0/ 0 62f5ace0 soctcp sqlexec 182640 67 6 12194 11359 0/ 2 1/ 1 0/ 0 62b548e8 soctcp sqlexec 181942 80 6 12867 12867 0/ 1 1/ 1 0/ 0 60b40de8 soctcp sqlexec 181790 81 5 9167 9167 0/ 1 1/ 1 0/ 0 63083e28 soctcp sqlexec 181780 30 6 6256 5847 0/ 2 1/ 1 0/ 0 621a27c0 soctcp sqlexec 181740 37 5 13898 12991 0/ 2 1/ 1 0/ 0 631e3b08 soctcp sqlexec 181738 5 5 13727 13727 0/ 1 1/ 1 0/ 0 6623e030 soctcp sqlexec 181037 15 5 15453 15303 0/ 1 1/ 1 0/ 0 62c54e60 soctcp sqlexec 180906 3 5 12428 11855 0/ 2 1/ 1 0/ 0 627a0228 soctcp sqlexec 180258 31 5 19325 19325 0/ 1 1/ 1 0/ 0 6374d410 soctcp sqlexec 180113 22 6 17161 17103 0/ 1 1/ 1 0/ 0 624e1080 soctcp sqlexec 179778 45 6 20107 18943 0/ 2 1/ 1 0/ 0 6308e620 soctcp sqlexec 178399 53 6 7526 7519 0/ 1 1/ 1 0/ 0 62529030 soctcp sqlexec 176605 52 6 15359 15351 0/ 2 1/ 1 0/ 0 6339b5b8 soctcp sqlexec 171545 44 6 46092 45935 0/ 2 1/ 1 0/ 0 62a76460 soctcp sqlexec 167564 40 5 11407 11407 0/ 1 1/ 1 0/ 0 61decd10 soctcp sqlexec 155553 43 5 0 0 0/ 0 1/ 1 0/ 0 6376a648 soctcp sqlexec 139690 12 5 0 0 0/ 0 1/ 1 0/ 0 63612e58 soctcp sqlexec 138347 16 5 9320 9320 0/ 1 1/ 1 0/ 0 63312b20 soctcp sqlexec 137385 63 5 11416 11416 0/ 1 1/ 1 0/ 0 61d3e030 soctcp sqlexec 15338 77 6 23943 23943 0/ 1 1/ 1 0/ 0 631e3cc0 soctcp sqlexec 15298 83 6 14764 14764 0/ 1 1/ 1 0/ 0 628e0e20 ipcshm sqlexec 186 0 0 41884 41884 -49171/-42391 0/ 0 0/ 0 60bc17f0 ipcshm sqlexec 179 0 0 41374 41374 -43363/-37265 0/ 0 0/ 0 60b70d70 ipcshm sqlexec 178 0 0 410220 430343 -661796/-519919 0/ 0 0/ 0 62814ca0 ipcshm sqlexec 176 0 0 84146 84146 -45466/-39281 0/ 0 0/ 0 6248d6c8 ipcshm sqlexec 163 0 0 57075 57171 -90781/-76232 0/ 0 0/ 0 62529ac8 ipcshm sqlexec 162 0 0 14708 15392 -46686/-42206 0/ 0 0/ 0 61ec46b8 soctcp sqlexec 149 21 6 1152 1152 0/ 1 1/ 1 0/ 0 61eb4cf8 ipcshm sqlexec 158 0 0 536449 471930 -1459472/-1236753 0/ 0 0/ 0 624de630 ipcshm sqlexec 156 0 0 4549353 4592927 -12599803/-10793631 0/ 0 0/ 0 61f2c8e8 ipcshm sqlexec 155 0 0 67372 67372 -34495/-29514 0/ 0 0/ 0 62389c10 ipcshm sqlexec 152 0 0 4162 4164 -5890/-5138 0/ 0 0/ 0 6236c658 ipcshm sqlexec 151 0 0 5565 6259 -9221/-7966 0/ 0 0/ 0 60ee4ab0 ipcshm sqlexec 150 0 0 6066 6066 -11486/-9925 0/ 0 0/ 0 610734b0 ipcshm sqlexec 25 0 0 47118622 47747670 -191685147/-172149722 0/ 0 0/ 0 6103a9b8 ipcshm sqlexec 57 0 0 4863 4873 -5596/-4788 0/ 0 0/ 0 6103a658 ipcshm sqlexec 141 0 0 33553 33757 -56441/-44391 0/ 0 0/ 0 60f2fe58 soctcp CDRNsT70 112 4 6 409339 454269 0/ 7 1/ 1 0/ 0 60825e38 ipcshm sm_discon 29 0 0 0 0 0/ 0 0/ 0 0/ 0 60871118 ipcshm sm_listen 27 0 0 2563 0 0/ 0 0/ 0 0/ 0 608bb018 ipcshm sm_discon 26 0 0 0 0 0/ 0 0/ 0 0/ 0 6080afd0 ipcshm sm_listen 24 0 0 2504 0 0/ 0 0/ 0 0/ 0 6080ae18 ipcshm sm_discon 23 0 0 0 0 0/ 0 0/ 0 0/ 0 60847210 ipcshm sm_listen 21 0 0 2562 0 0/ 0 0/ 0 0/ 0 608236c0 ipcshm sm_discon 20 0 0 0 0 0/ 0 0/ 0 0/ 0 60809d90 ipcshm sm_listen 18 0 0 2567 0 0/ 0 0/ 0 0/ 0 608462e8 ipcshm sm_discon 17 0 0 0 0 0/ 0 0/ 0 0/ 0 60821528 ipcshm sm_listen 14 0 0 2599 0 0/ 0 0/ 0 0/ 0 60820f40 ipcshm sm_discon 13 0 0 0 0 0/ 0 0/ 0 0/ 0 608104c8 ipcshm sm_listen 11 0 0 2597 0 0/ 0 0/ 0 0/ 0 607c5bf0 soctcp soctcplst 10 1 5 28878 0 0/ 0 0/ 0 0/ 0 607e7448 ipcshm sm_poll 9 0 0 2762877 0 0/ 0 0/ 0 0/ 0 60797db8 ipcshm sm_poll 8 0 0 31638668 0 0/ 0 0/ 0 0/ 0 607c5448 ipcshm sm_poll 7 0 0 6553964 0 0/ 0 0/ 0 0/ 0 60797b50 ipcshm sm_poll 6 0 0 1921117 0 0/ 0 0/ 0 0/ 0 607a6e50 ipcshm sm_poll 5 0 0 4801434 0 0/ 0 0/ 0 0/ 0 60781e50 ipcshm sm_poll 4 0 0 1456190 0 0/ 0 0/ 0 0/ 0 60781460 soctcp soctcppoll 3 0 6 3705968 0 0/ 0 0/ 0 0/ 0 605c5da0 soctcp soctcppoll 2 0 5 8277616 0 0/ 0 0/ 0 0/ 0 onstat -d Chunks address chk/dbs offset size free bpages flags pathname 60105928 1 1 1 50000 34058 PO- /usr/informix/__links/rootdbs 60c488f0 2 2 1 303750 4057 PO- /usr/informix/__links/logdbs1 60c48a60 3 3 1 255750 139689 PO- /usr/informix/__links/stats2 60c48bd0 4 4 1 255750 33804 PO- /usr/informix/__links/stats3 60c48d40 5 5 1 495750 394697 PO- /usr/informix/__links/freqgst2 60dc5018 6 6 1 128000 67179 PO- /usr/informix/__links/queues 60dc5188 7 7 1 495750 378250 PO- /usr/informix/__links/data2 60dc52f8 8 8 1 495750 97697 PO- /usr/informix/__links/resarcv2 60dc5468 9 9 1 495750 45697 PO- /usr/informix/__links/resarcv3 60dc55d8 10 10 1 495750 475697 PO- /usr/informix/__links/resfiles2 60dc5748 11 11 1 495750 95697 PO- /usr/informix/__links/resarcv1 60dc58b8 12 12 1 255750 82849 PO- /usr/informix/__links/invty2 60dc5a28 13 13 0 500000 276947 PO- /usr/informix/__links/avlog 60dc5b98 14 14 1 255750 131185 PO- /usr/informix/__links/invty1 60dc5d08 15 15 1 63750 63029 PO- /usr/informix/__links/tmp3 60dc5e78 16 16 1 239750 152570 PO- /usr/informix/__links/data3 60dc6018 17 17 1 127750 72199 PO- /usr/informix/__links/cfgmaint 60dc6188 18 18 1 255750 166469 PO- /usr/informix/__links/data5 60dc62f8 19 19 1 495750 180697 PO- /usr/informix/__links/resfiles1 60dc6468 20 20 1 63750 63149 PO- /usr/informix/__links/tmp4 60dc65d8 21 21 1 63750 61847 PO- /usr/informix/__links/tmp1 60dc6748 22 22 1 495750 196330 PO- /usr/informix/__links/stats1 60dc68b8 23 23 1 258000 119478 PO- /usr/informix/__links/data6 60dc6a28 24 24 1 63750 63037 PO- /usr/informix/__links/tmp5 60dc6b98 25 25 1 63750 62869 PO- /usr/informix/__links/tmp2 60dc6d08 26 26 1 112000 111947 PO- /usr/informix/__links/logdbs2 60dc6e78 27 27 1 495750 394797 PO- /usr/informix/__links/freqgst1 60df2018 28 28 1 255750 230177 PO- /usr/informix/__links/data4 60df2188 29 29 0 32000 ~32000 32000 POB /usr/informix/__links/blob1 60df22f8 30 30 1 255750 222497 PO- /usr/informix/__links/invty3 60df2468 31 31 0 500000 197447 PO- /usr/informix/__links/eod 60df25d8 32 32 0 168000 115947 PO- /usr/informix/__links/reslookup 60df2748 33 33 1 500000 199947 PO- /usr/informix/__links/stats4 60df28b8 34 34 1 500000 355935 PO- /usr/informix/__links/stats5 60df2a28 35 35 1 500000 439947 PO- /usr/informix/__links/cfgmaint2 60df2b98 36 36 1 500000 149947 PO- /usr/informix/__links/resfiles3 60df2d08 37 37 1 500000 50487 PO- /usr/informix/__links/logdbs3 60df2e78 38 38 1 500000 547 PO- /usr/informix/__links/logdbs4 60df3018 39 39 1 500000 50487 PO- /usr/informix/__links/logdbs5 60df3188 40 40 0 450000 444131 PO- /usr/informix/__links/repque 60df32f8 41 41 0 450000 394615 394616 POS /usr/informix/__links/repblob Metadata 55331 36569 55331 41 active, 2047 maximum onstat -g iof (some dbspaces are "hot" but load has not changed since upgrade. data2 has it's own disk) Informix Dynamic Server Version 9.30.UC5 -- On-Line -- Up 3 days 10:29:44 -- 953968 Kbytes AIO global files: gfd pathname totalops dskread dskwrite io/s 3 rootdbs 42546 24217 18329 1.0 4 logdbs1 18732 18732 0 0.5 5 stats2 61837 61125 712 1.5 6 stats3 104178 103738 440 2.5 7 freqgst2 270089 266893 3196 6.6 8 queues 36857 29477 7380 0.9 9 data2 1393796 1392205 1591 34.0 10 resarcv2 955345 890033 65312 23.3 11 resarcv3 108737 87059 21678 2.6 12 resfiles2 13159 12971 188 0.3 13 resarcv1 119625 95082 24543 2.9 14 invty2 305121 274490 30631 7.4 15 avlog 41481 32845 8636 1.0 16 invty1 388102 359198 28904 9.5 17 tmp3 30032 11144 18888 0.7 18 data3 35000 34637 363 0.9 19 cfgmaint 26876 23109 3767 0.7 20 data5 100786 58054 42732 2.5 21 resfiles1 364910 292830 72080 8.9 22 tmp4 29115 10604 18511 0.7 23 tmp1 0 0 0 0.0 24 stats1 212577 208248 4329 5.2 25 data6 76202 43340 32862 1.9 26 tmp5 29833 11020 18813 0.7 27 tmp2 30617 11161 19456 0.7 28 logdbs2 0 0 0 0.0 29 freqgst1 1097186 1076397 20789 26.7 30 data4 44378 19716 24662 1.1 31 blob1 8051 8051 0 0.2 32 invty3 454589 443582 11007 11.1 33 eod 89228 89221 7 2.2 34 reslookup 152588 108245 44343 3.7 35 stats4 94058 87712 6346 2.3 36 stats5 59724 56526 3198 1.5 37 cfgmaint2 12064 8496 3568 0.3 38 resfiles3 414719 317202 97517 10.1 39 logdbs3 68002 28131 39871 1.7 40 logdbs4 79258 25008 54250 1.9 41 logdbs5 0 0 0 0.0 42 repque 0 0 0 0.0 43 repblob 0 0 0 0.0 onstat -g ioq Informix Dynamic Server Version 9.30.UC5 -- On-Line -- Up 3 days 10:32:16 -- 953968 Kbytes AIO I/O queues: q name/id len maxlen totalops dskread dskwrite dskcopy kio 0 0 20 5952032 5862275 89757 0 kio 1 0 20 4380032 4296058 83974 0 kio 2 0 20 3186142 3093175 92967 0 kio 3 0 21 3359146 3277278 81868 0 kio 4 0 20 694328 640887 53441 0 kio 5 0 20 976372 918326 58046 0 kio 6 0 20 2199413 2122225 77188 0 kio 7 0 20 1420582 1343674 76908 0 kio 8 0 20 810242 756759 53483 0 kio 9 0 20 552346 502860 49486 0 kio 10 0 20 499388 450032 49356 0 adt 0 0 0 0 0 0 0 msc 0 0 4 201898 0 0 0 aio 0 0 1 31770 10590 0 0 pio 0 0 0 0 0 0 0 lio 0 0 0 0 0 0 0 gfd 3 0 0 0 0 0 0 gfd 4 0 0 0 0 0 0 gfd 5 0 0 0 0 0 0 gfd 6 0 0 0 0 0 0 gfd 7 0 0 0 0 0 0 gfd 8 0 0 0 0 0 0 gfd 9 0 0 0 0 0 0 gfd 10 0 0 0 0 0 0 gfd 11 0 0 0 0 0 0 gfd 12 0 0 0 0 0 0 gfd 13 0 0 0 0 0 0 gfd 14 0 0 0 0 0 0 gfd 15 0 0 0 0 0 0 gfd 16 0 0 0 0 0 0 gfd 17 0 0 0 0 0 0 gfd 18 0 0 0 0 0 0 gfd 19 0 0 0 0 0 0 gfd 20 0 0 0 0 0 0 gfd 21 0 0 0 0 0 0 gfd 22 0 0 0 0 0 0 gfd 23 0 0 0 0 0 0 gfd 24 0 0 0 0 0 0 gfd 25 0 0 0 0 0 0 gfd 26 0 0 0 0 0 0 gfd 27 0 0 0 0 0 0 gfd 28 0 0 0 0 0 0 gfd 29 0 0 0 0 0 0 gfd 30 0 0 0 0 0 0 gfd 31 0 0 0 0 0 0 gfd 32 0 0 0 0 0 0 gfd 33 0 0 0 0 0 0 gfd 34 0 0 0 0 0 0 gfd 35 0 0 0 0 0 0 gfd 36 0 0 0 0 0 0 gfd 37 0 0 0 0 0 0 gfd 38 0 0 0 0 0 0 gfd 39 0 0 0 0 0 0 gfd 40 0 0 0 0 0 0 gfd 41 0 0 0 0 0 0 gfd 42 0 0 0 0 0 0 gfd 43 0 0 0 0 0 0 and since we've retuned, I'll resend the others onstat -p approx 11.5 hours since stat clear Informix Dynamic Server Version 9.30.UC5 -- On-Line -- Up 3 days 10:33:57 -- 953968 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 23245973 32442893 2832556317 99.18 769570 1498093 28068635 97.26 isamtot open start read write rewrite delete commit rollbk 2496656589 115052887 291084280 1546640140 6196188 2851708 733662 3702965 2170 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 138865.65 7966.15 136 408 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 1661253 926 2286035319 0 0 2502 608340 6095177 ixda-RA idx-RA da-RA RA-pgsused lchwaits 3031026 2303865 15672002 20890106 6584586 onconfig file #************************************************* ************************* # # INFORMIX SOFTWARE, INC. # # Title : onconfig.prod # Last Modified : November 10, 2000 # Description : Informix Dynamic Server Configuration Parameters # Configured by : Dave Thacker # #************************************************* ************************* # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /usr/informix/__links/rootdbs # Path for device # containing root dbspace ROOTOFFSET 4 # Offset of root dbspace into device (Kbytes) ROOTSIZE 200000 # Size of root dbspace (Kbytes) # Disk Mirroring Configuration Parameters MIRROR 0 # Mirroring flag (Yes = 1, No = 0) MIRRORPATH # Path for device containing mirrored root MIRROROFFSET 0 # Offset into mirrored device (Kbytes) # Physical Log Configuration PHYSDBS rootdbs # Location (dbspace) of physical log PHYSFILE 40000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 34 # Number of logical log files LOGSIZE 2000 # Logical log size (Kbytes) # Diagnostics MSGPATH /logs/online.prod.log # System message log file path CONSOLE /logs/online.prod.con # System console message path ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path TBLSPACE_STATS 1 # System Archive Tape Device #TAPEDEV /dev/rmt2 # Tape device path #TAPEBLK 4096 # Tape block size (Kbytes) #TAPESIZE 9500000 # Maximum amount of data to put on tape (Kbytes) TAPEDEV /dev/rmt2 # Tape device path TAPEBLK 4096 # Tape block size (Kbytes) TAPESIZE 9500000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt0 # Log tape device path LTAPEBLK 1024 # Log tape block size (Kbytes) LTAPESIZE 6000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB # Informix Dynamic Server/Optical staging area # System Configuration SERVERNUM 111 # Unique id corresponding to a Dynamic Server instance DBSERVERNAME prod_tcp # Name of default database server DBSERVERALIASES prod # List of alternate dbservernames NETTYPE ipcshm,6,125,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,2,100,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) (AIX does not support # forced residency-DT 09/05/2003) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 11 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 250000 # Maximum number of locks BUFFERS 144000 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps PHYSBUFF 56 # Physical log buffer size (Kbytes) LOGBUFF 48 # Logical log buffer size (Kbytes) CLEANERS 60 # Number of buffer cleaner processes SHMBASE 0x30000000 # Shared memory base address SHMVIRTSIZE 328000 # initial virtual shared memory segment size SHMADD 81920 # Size of new shared memory segments (Kbytes) SHMTOTAL 2000000 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 300 # Check point interval (in sec) LRUS 60 # Number of LRU queues LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water mark percentage LTXEHWM 60 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) # System Page Size # BUFFSIZE - Dynamic Server no longer supports this configuration parameter. # To determine the page size used by Dynamic Server on your platform # see the last line of output from the command, 'onstat -b'. # Recovery Variables # OFF_RECVRY_THREADS: # Number of parallel worker threads during fast recovery or an offline restore. # ON_RECVRY_THREADS: # Number of parallel worker threads during an online restore. OFF_RECVRY_THREADS 10 # Default number of offline worker threads ON_RECVRY_THREADS 1 # Default number of online worker threads # Data Replication Variables # DRAUTO: 0 manual, 1 retain type, 2 reverse type DRINTERVAL 30 # DR max time between DR buffer flushes (in sec) DRTIMEOUT 30 # DR network timeout (in sec) DRLOSTFOUND /usr/informix/etc/dr.lostfound # DR lost+found file path # CDR Variables CDR_EVALTHREADS 1,2 # evaluator threads (per-cpu-vp,additional) CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds) CDR_QUEUEMEM 24576 # Maximum amount of memory for any CDR queue (Kbytes) CDR_NIFCOMPRESS 0 CDR_SERIAL 0,0 CDR_DBSPACE CDR_QHDR_DBSPACE repque CDR_QDATA_SBSPACE repblob CDR_QDATA_SBFLAGS 0 # Backup/Restore variables BAR_ACT_LOG /tmp/bar_act.log BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 # Informix Storage Manager variables ISM_DATA_POOL ISMData # If the data pool name is changed, be sure to # update $INFORMIXDIR/bin/onbar. Change to # ism_catalog -create_bootstrap -pool <new name> ISM_LOG_POOL ISMLogs # Read Ahead Variables RA_PAGES 20 # Number of pages to attempt to read ahead RA_THRESHOLD 16 # Number of pages left before next group # DBSPACETEMP: # Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces # that the Dynamic Server SQL Engine will use to create temp tables etc. # If specified it must be a colon separated list of dbspaces that exist # when the Dynamic Server system is brought online. If not specified, or if # all dbspaces specified are invalid, various ad hoc queries will create # temporary files in /tmp instead. DBSPACETEMP tmp2,tmp3,tmp4,tmp5 # Default temp dbspaces # DUMP*: # The following parameters control the type of diagnostics information which # is preserved when an unanticipated error condition (assertion failure) occurs # during Dynamic Server operations. # For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No. DUMPDIR /tmp # Preserve diagnostics in this directory DUMPSHMEM 0 # Dump a copy of shared memory DUMPGCORE 0 # Dump a core image using 'gcore' DUMPCORE 0 # Dump a core image (Warning:this aborts Dynamic Server) DUMPCNT 1 # Number of shared memory or gcore dumps for # a single user's session FILLFACTOR 90 # Fill factor for building indexes # method for Dynamic Server to use when determining current time USEOSTIME 0 # 0: use internal time(fast), 1: get time from OS(slow) # Parallel Database Queries (pdq) MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority DS_MAX_QUERIES 6230 # Maximum number of decision support queries DS_TOTAL_MEMORY 797448 # Decision support memory (Kbytes) DS_MAX_SCANS 1048576 # Maximum number of decision support scans DATASKIP off # List of dbspaces to skip # OPTCOMPIND # 0 => Nested loop joins will be preferred (where # possible) over sortmerge joins and hash joins. # 1 => If the transaction isolation mode is not # "repeatable read", optimizer behaves as in (2) # below. Otherwise it behaves as in (0) above. # 2 => Use costs regardless of the transaction isolation # mode. Nested loop joins are not necessarily # preferred. Optimizer bases its decision purely # on costs. OPTCOMPIND 0 # To hint the optimizer ONDBSPACEDOWN 0 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAIT OPCACHEMAX 0 # Maximum optical cache size (Kbytes) # HETERO_COMMIT (Gateway participation in distributed transactions) # 1 => Heterogeneous Commit is enabled # 0 (or any other value) => Heterogeneous Commit is disabled HETERO_COMMIT 0 # Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS OPT_GOAL -1 # Optimizer DIRECTIVES ON (1/Default) or OFF (0) DIRECTIVES 1 # Status of restartable restore RESTARTABLE_RESTORE off DYNAMIC_LOGS 2 BAR_DEBUG_LOG /tmp/bar_dbug.log # ON-Bar Debug Log - not in /tmp please BAR_PROGRESS_FREQ 0 SBSPACENAME # Default smartblob space name - this is where blobs SYSSBSPACENAME # Default smartblob space for use by the Informix BLOCKTIMEOUT 3600 # Default timeout for system block ALLOW_NEWLINE 0 # embedded newlines(Yes = 1, No = 0 or anything but 1) JVPJAVAHOME # JRE installation root directory JVPHOME # Krakatoa installation directory JVPPROPFILE .jvpprops # JVP property file JVPLOGFILE jvp.log # JVP log file. JDKVERSION # JDK version supported by this server JVPJAVALIB JVPJAVAVM libjava.so JVPCLASSPATH Looking forward to hearing more comments. TIA Dave Thacker      |
|
04-19-2008, 06:38 PM
| ||||
| ||||
| Re: Tuning IDS 9.30 after migration from IDS7.31 All those sequential scans: 6 million from a total of 32 million page reads. Are you *sure* you ran update stats? Also, although you say you could use up to 3GBytes of memory for the database server, you're actually using less than 1 Gbyte, and your buffer cache ("Yes, we speak Oracle!") is only about half a gig in size. Still, your cache rates are pretty good nonetheless .... -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com |
Linear Mode
