sessions multiple Informix driver

Hello guys. I have a question. In my environment i have a windows server that connect to informix via odbc. I have informix driver 3.5 and informix 11.5. There are remotes pc's that connect to this server. The response time is very slow. Independ to the internet trafic is there any problem that several users create several sessions with this driver in only one server?

There´s no problem with several connections, supposing you have a good network configuration to support them. Suggestions? Maybe, if you could send us the following outputs (from server side): 1) onstat -c |grep NETTYPE 2) onstat -g ntu 3) last line of "onstat -u" should also help.... 4) almost forgot: your $INFORMIXDIR/etc/sqlhosts file (or custom one) - server side Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: licu99@gmail.com > Subject: sessions multiple Informix driver [28367] > Date: Wed, 26 Sep 2012 13:35:03 -0400 > > Hello guys. I have a question. In my environment i have a windows server that > connect to informix via odbc. I have informix driver 3.5 and informix 11.5. > There are remotes pc's that connect to this server. The response time is very > slow. Independ to the internet trafic is there any problem that several users > create several sessions with this driver in only one server? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Thanks. I have that. onstat -c | grep NETTYPE NETTYPE soctcp,1,200,CPU onstat -g ntu global network information: #netscb connects read write q-free q-limits q-exceed alloc/max 125/ 138 416 2747863 2688277 15/ 16 240/ 10 0/1542 138/ 138 Individual thread network information (basic): netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp 4ce01180 soctcp sqlexec 439 18 5 9336 9799 0/ 1 1/ 1 0/ 0 4d391260 soctcp sqlexec 438 17 5 110 111 0/ 1 1/ 1 0/ 0 54accc88 soctcp sqlexec 433 54 5 29 67 0/ 1 1/ 1 0/ 0 4f4e0028 soctcp sqlexec 431 12 5 7976 8561 0/ 1 1/ 1 0/ 0 52b08a18 soctcp sqlexec 430 11 5 106 107 0/ 1 1/ 1 0/ 0 5ac626d0 soctcp sqlexec 424 136 5 13884 14658 0/ 1 1/ 1 0/ 0 5ab3ca78 soctcp sqlexec 423 135 5 112 113 0/ 1 1/ 1 0/ 0 544190a8 soctcp sqlexec 419 132 5 3954 4067 0/ 1 1/ 1 0/ 0 5f94d360 soctcp sqlexec 418 131 5 102 103 0/ 1 1/ 1 0/ 0 5637e6e8 soctcp sqlexec 417 130 5 100 112 0/ 1 1/ 1 0/ 0 52ea69a0 soctcp sqlexec 412 129 5 600 630 0/ 1 1/ 1 0/ 0 5433d050 soctcp sqlexec 411 89 5 1273 1321 0/ 1 1/ 1 0/ 0 538eb1d8 soctcp sqlexec 410 124 5 4019 4114 0/ 1 1/ 1 0/ 0 5637ebc8 soctcp sqlexec 409 123 5 102 103 0/ 1 1/ 1 0/ 0 564ac948 soctcp sqlexec 408 73 5 19 19 0/ 1 1/ 1 0/ 0 5f97f5f0 soctcp sqlexec 407 105 5 4506 4637 0/ 1 1/ 1 0/ 0 5dec00c0 soctcp sqlexec 406 101 5 102 103 0/ 1 1/ 1 0/ 0 5d488760 soctcp sqlexec 405 76 5 163 178 0/ 1 1/ 1 0/ 0 5a0940f8 soctcp sqlexec 399 90 5 27 43 0/ 1 1/ 1 0/ 0 4cea70c8 soctcp sqlexec 376 99 5 22556 23142 0/ 1 1/ 1 0/ 0 559a7a58 soctcp sqlexec 375 98 5 128 129 0/ 1 1/ 1 0/ 0 5a78b830 soctcp sqlexec 374 92 5 8096 8270 0/ 1 1/ 1 0/ 0 54535348 soctcp sqlexec 373 91 5 112 113 0/ 1 1/ 1 0/ 0 561338b8 soctcp sqlexec 370 95 5 510 537 0/ 1 1/ 1 0/ 0 53092ce0 soctcp sqlexec 368 66 5 20737 21719 0/ 1 1/ 1 0/ 0 53094050 soctcp sqlexec 367 65 5 124 125 0/ 1 1/ 1 0/ 0 56bae028 soctcp sqlexec 364 35 5 61 61 0/ 1 1/ 1 0/ 0 4ce3b450 soctcp sqlexec 351 23 5 41972 43613 0/ 1 1/ 1 0/ 0 5d7349e8 soctcp sqlexec 350 22 5 126 127 0/ 1 1/ 1 0/ 0 5d7d4488 soctcp sqlexec 335 128 5 807 892 0/ 1 1/ 1 0/ 0 5b63b7a8 soctcp sqlexec 334 127 5 108 109 0/ 1 1/ 1 0/ 0 53326478 soctcp sqlexec 327 119 5 26 7910 0/ 1 1/ 1 0/ 0 4ea3fbe8 soctcp sqlexec 323 62 5 20211 20535 0/ 1 1/ 1 0/ 0 5e621140 soctcp sqlexec 322 61 5 132 133 0/ 1 1/ 1 0/ 0 5a65ea98 soctcp sqlexec 319 100 5 180 232 0/ 1 1/ 1 0/ 0 53f68b20 soctcp sqlexec 297 120 5 25978 26775 0/ 1 1/ 1 0/ 0 54017218 soctcp sqlexec 296 49 5 104 105 0/ 1 1/ 1 0/ 0 547fb6d0 soctcp sqlexec 295 48 5 821 897 0/ 1 1/ 1 0/ 0 51755640 soctcp sqlexec 293 118 5 19976 20897 0/ 1 1/ 1 0/ 0 5720f0a0 soctcp sqlexec 292 117 5 102 103 0/ 1 1/ 1 0/ 0 573596b8 soctcp sqlexec 290 116 5 39355 40348 0/ 1 1/ 1 0/ 0 573f1470 soctcp sqlexec 289 115 5 122 123 0/ 1 1/ 1 0/ 0 5d8790a8 soctcp sqlexec 288 114 5 661 762 0/ 1 1/ 1 0/ 0 594cb990 soctcp sqlexec 287 113 5 102 110 0/ 1 1/ 1 0/ 0 5215d850 soctcp sqlexec 286 112 5 291 310 0/ 1 1/ 1 0/ 0 5c5d2100 soctcp sqlexec 285 111 5 26082 26866 0/ 1 1/ 1 0/ 0 5a9ed510 soctcp sqlexec 284 110 5 118 119 0/ 1 1/ 1 0/ 0 5848dcb0 soctcp sqlexec 283 109 5 921 1015 0/ 1 1/ 1 0/ 0 51e56220 soctcp sqlexec 280 108 5 558 706 0/ 1 1/ 1 0/ 0 4ce092c0 soctcp sqlexec 278 14 5 21339 22285 0/ 1 1/ 1 0/ 0 5b96c840 soctcp sqlexec 277 13 5 102 103 0/ 1 1/ 1 0/ 0 4d391d58 soctcp sqlexec 270 102 5 853 981 0/ 1 1/ 1 0/ 0 570d6b40 soctcp sqlexec 264 58 5 111 119 0/ 1 1/ 1 0/ 0 54cf0ce8 soctcp sqlexec 263 57 5 59 61 0/ 1 1/ 1 0/ 0 5af4a050 soctcp sqlexec 256 104 5 48543 50290 0/ 1 1/ 1 0/ 0 5ade1500 soctcp sqlexec 255 103 5 376 398 0/ 1 1/ 1 0/ 0 598094b8 soctcp sqlexec 235 86 5 60 62 0/ 1 1/ 1 0/ 0 56c24c60 soctcp sqlexec 233 97 5 26929 27477 0/ 1 1/ 1 0/ 0 4f07c818 soctcp sqlexec 232 96 5 134 135 0/ 1 1/ 1 0/ 0 53912590 soctcp sqlexec 225 94 5 47590 55434 0/ 1 1/ 1 0/ 0 4ce01638 soctcp sqlexec 224 93 5 120 121 0/ 1 1/ 1 0/ 0 4ce94780 soctcp sqlexec 187 34 5 214 214 0/ 1 1/ 1 0/ 0 4ce5c708 soctcp sqlexec 181 88 5 566 614 0/ 1 1/ 1 0/ 0 590d5358 soctcp sqlexec 179 87 5 980 1046 0/ 1 1/ 1 0/ 0 4ce5c128 soctcp sqlexec 176 85 5 1146 1330 0/ 1 1/ 1 0/ 0 4cebf948 soctcp sqlexec 172 27 5 48093 48882 0/ 1 1/ 1 0/ 0 4ce38828 soctcp sqlexec 171 26 5 224 225 0/ 1 1/ 1 0/ 0 53a08320 soctcp sqlexec 170 84 5 40890 42500 0/ 1 1/ 1 0/ 0 58260730 soctcp sqlexec 169 83 5 365 387 0/ 1 1/ 1 0/ 0 58181148 soctcp sqlexec 168 82 5 34302 35272 0/ 1 1/ 1 0/ 0 4f253028 soctcp sqlexec 167 81 5 122 123 0/ 1 1/ 1 0/ 0 564b6a20 soctcp sqlexec 164 78 5 49541 51060 0/ 1 1/ 1 0/ 0 564b6418 soctcp sqlexec 163 77 5 124 125 0/ 1 1/ 1 0/ 0 56837748 soctcp sqlexec 162 75 5 52358 54060 0/ 1 1/ 1 0/ 0 57e33730 soctcp sqlexec 161 74 5 124 125 0/ 1 1/ 1 0/ 0 56133090 soctcp sqlexec 156 72 5 40260 42354 0/ 1 1/ 1 0/ 0 4fdd0a28 soctcp sqlexec 155 71 5 126 127 0/ 1 1/ 1 0/ 0 57007888 soctcp sqlexec 153 70 5 87654 90293 0/ 1 1/ 1 0/ 0 510498e0 soctcp sqlexec 152 69 5 220 221 0/ 1 1/ 1 0/ 0 5659a0a0 soctcp sqlexec 145 64 5 85484 87448 0/ 1 1/ 1 0/ 0 4fd2b028 soctcp sqlexec 144 63 5 191 192 0/ 1 1/ 1 0/ 0 55a80028 soctcp sqlexec 141 53 5 36853 38083 0/ 1 1/ 1 0/ 0 4fe0c0a0 soctcp sqlexec 140 52 5 108 109 0/ 1 1/ 1 0/ 0 4ef17148 soctcp sqlexec 138 60 5 35062 36168 0/ 1 1/ 1 0/ 0 53471190 soctcp sqlexec 137 59 5 122 123 0/ 1 1/ 1 0/ 0 54bfd450 soctcp sqlexec 134 56 5 24005 24469 0/ 1 1/ 1 0/ 0 54937028 soctcp sqlexec 133 55 5 102 103 0/ 1 1/ 1 0/ 0 51a420a0 soctcp sqlexec 129 51 5 11908 12628 0/ 1 1/ 1 0/ 0 52cae370 soctcp sqlexec 128 50 5 104 105 0/ 1 1/ 1 0/ 0 5214f148 soctcp sqlexec 125 47 5 20235 20860 0/ 1 1/ 1 0/ 0 5159d790 soctcp sqlexec 124 46 5 102 103 0/ 1 1/ 1 0/ 0 52716148 soctcp sqlexec 123 45 5 17923 18404 0/ 1 1/ 1 0/ 0 5304dae8 soctcp sqlexec 122 44 5 102 103 0/ 1 1/ 1 0/ 0 5287c5b0 soctcp sqlexec 121 43 5 16682 17153 0/ 1 1/ 1 0/ 0 528c6188 soctcp sqlexec 120 42 5 110 111 0/ 1 1/ 1 0/ 0 50c4c4e0 soctcp sqlexec 119 41 5 33513 33999 0/ 1 1/ 1 0/ 0 5284daa0 soctcp sqlexec 118 40 5 128 129 0/ 1 1/ 1 0/ 0 527495b0 soctcp sqlexec 117 39 5 55447 57181 0/ 1 1/ 1 0/ 0 526bfb00 soctcp sqlexec 116 38 5 161 162 0/ 1 1/ 1 0/ 0 4cec4dc0 soctcp sqlexec 115 37 5 88997 91516 0/ 1 1/ 1 0/ 0 4cebfdc8 soctcp sqlexec 114 36 5 170 171 0/ 1 1/ 1 0/ 0 4ce9ed78 soctcp sqlexec 111 33 5 44365 45655 0/ 1 1/ 1 0/ 0 4ce958d8 soctcp sqlexec 110 32 5 136 137 0/ 1 1/ 1 0/ 0 4ce8a1a0 soctcp sqlexec 109 31 5 64588 66085 0/ 1 1/ 1 0/ 0 4ce808c0 soctcp sqlexec 108 30 5 143 144 0/ 1 1/ 1 0/ 0 4ce6f4f8 soctcp sqlexec 107 29 5 26237 26895 0/ 1 1/ 1 0/ 0 4ce65c68 soctcp sqlexec 106 28 5 126 127 0/ 1 1/ 1 0/ 0 4ce44d20 soctcp sqlexec 103 25 5 28306 29338 0/ 1 1/ 1 0/ 0 4ce3a418 soctcp sqlexec 102 24 5 102 103

Ok, it seems there is no serious problem regarding your network configurations. You have a low amount of simultaneous users, my only suggestion would be changing from "NETTYPE soctcp,1,200,CPU" to NETTYPE soctcp,1,250,NET Maybe you are in need of some performance tuning, and also a serious security recommendations. (I am not going to enter in security questions, sorry). Have you noticed performance degradation since when? How is your Informix server uptime: "onstat -" output ? Are you regularly updating your database statistics? How is your machine idle time? Could you post an "sar 1 5" output? Is there any other application running on Informix machine, or is it an Informix dedicated server? Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: licu99@gmail.com > Subject: Re: RE: sessions multiple Informix driver [28369] > Date: Wed, 26 Sep 2012 14:31:42 -0400 > > Thanks. > > I have that. > > onstat -c | grep NETTYPE> > NETTYPE soctcp,1,200,CPU> > onstat -g ntu> > global network information: > #netscb connects read write q-free q-limits q-exceed alloc/max > 125/ 138 416 2747863 2688277 15/ 16 240/ 10 0/1542 138/ 138 > > Individual thread network information (basic): > > netscb type thread name sid fd poll reads writes q-nrm q-pvt q-exp > > 4ce01180 soctcp sqlexec 439 18 5 9336 9799 0/ 1 1/ 1 0/ 0 > > 4d391260 soctcp sqlexec 438 17 5 110 111 0/ 1 1/ 1 0/ 0 > > 54accc88 soctcp sqlexec 433 54 5 29 67 0/ 1 1/ 1 0/ 0 > > 4f4e0028 soctcp sqlexec 431 12 5 7976 8561 0/ 1 1/ 1 0/ 0 > > 52b08a18 soctcp sqlexec 430 11 5 106 107 0/ 1 1/ 1 0/ 0 > > 5ac626d0 soctcp sqlexec 424 136 5 13884 14658 0/ 1 1/ 1 0/ 0 > > 5ab3ca78 soctcp sqlexec 423 135 5 112 113 0/ 1 1/ 1 0/ 0 > > 544190a8 soctcp sqlexec 419 132 5 3954 4067 0/ 1 1/ 1 0/ 0 > > 5f94d360 soctcp sqlexec 418 131 5 102 103 0/ 1 1/ 1 0/ 0 > > 5637e6e8 soctcp sqlexec 417 130 5 100 112 0/ 1 1/ 1 0/ 0 > > 52ea69a0 soctcp sqlexec 412 129 5 600 630 0/ 1 1/ 1 0/ 0 > > 5433d050 soctcp sqlexec 411 89 5 1273 1321 0/ 1 1/ 1 0/ 0 > > 538eb1d8 soctcp sqlexec 410 124 5 4019 4114 0/ 1 1/ 1 0/ 0 > > 5637ebc8 soctcp sqlexec 409 123 5 102 103 0/ 1 1/ 1 0/ 0 > > 564ac948 soctcp sqlexec 408 73 5 19 19 0/ 1 1/ 1 0/ 0 > > 5f97f5f0 soctcp sqlexec 407 105 5 4506 4637 0/ 1 1/ 1 0/ 0 > > 5dec00c0 soctcp sqlexec 406 101 5 102 103 0/ 1 1/ 1 0/ 0 > > 5d488760 soctcp sqlexec 405 76 5 163 178 0/ 1 1/ 1 0/ 0 > > 5a0940f8 soctcp sqlexec 399 90 5 27 43 0/ 1 1/ 1 0/ 0 > > 4cea70c8 soctcp sqlexec 376 99 5 22556 23142 0/ 1 1/ 1 0/ 0 > > 559a7a58 soctcp sqlexec 375 98 5 128 129 0/ 1 1/ 1 0/ 0 > > 5a78b830 soctcp sqlexec 374 92 5 8096 8270 0/ 1 1/ 1 0/ 0 > > 54535348 soctcp sqlexec 373 91 5 112 113 0/ 1 1/ 1 0/ 0 > > 561338b8 soctcp sqlexec 370 95 5 510 537 0/ 1 1/ 1 0/ 0 > > 53092ce0 soctcp sqlexec 368 66 5 20737 21719 0/ 1 1/ 1 0/ 0 > > 53094050 soctcp sqlexec 367 65 5 124 125 0/ 1 1/ 1 0/ 0 > > 56bae028 soctcp sqlexec 364 35 5 61 61 0/ 1 1/ 1 0/ 0 > > 4ce3b450 soctcp sqlexec 351 23 5 41972 43613 0/ 1 1/ 1 0/ 0 > > 5d7349e8 soctcp sqlexec 350 22 5 126 127 0/ 1 1/ 1 0/ 0 > > 5d7d4488 soctcp sqlexec 335 128 5 807 892 0/ 1 1/ 1 0/ 0 > > 5b63b7a8 soctcp sqlexec 334 127 5 108 109 0/ 1 1/ 1 0/ 0 > > 53326478 soctcp sqlexec 327 119 5 26 7910 0/ 1 1/ 1 0/ 0 > > 4ea3fbe8 soctcp sqlexec 323 62 5 20211 20535 0/ 1 1/ 1 0/ 0 > > 5e621140 soctcp sqlexec 322 61 5 132 133 0/ 1 1/ 1 0/ 0 > > 5a65ea98 soctcp sqlexec 319 100 5 180 232 0/ 1 1/ 1 0/ 0 > > 53f68b20 soctcp sqlexec 297 120 5 25978 26775 0/ 1 1/ 1 0/ 0 > > 54017218 soctcp sqlexec 296 49 5 104 105 0/ 1 1/ 1 0/ 0 > > 547fb6d0 soctcp sqlexec 295 48 5 821 897 0/ 1 1/ 1 0/ 0 > > 51755640 soctcp sqlexec 293 118 5 19976 20897 0/ 1 1/ 1 0/ 0 > > 5720f0a0 soctcp sqlexec 292 117 5 102 103 0/ 1 1/ 1 0/ 0 > > 573596b8 soctcp sqlexec 290 116 5 39355 40348 0/ 1 1/ 1 0/ 0 > > 573f1470 soctcp sqlexec 289 115 5 122 123 0/ 1 1/ 1 0/ 0 > > 5d8790a8 soctcp sqlexec 288 114 5 661 762 0/ 1 1/ 1 0/ 0 > > 594cb990 soctcp sqlexec 287 113 5 102 110 0/ 1 1/ 1 0/ 0 > > 5215d850 soctcp sqlexec 286 112 5 291 310 0/ 1 1/ 1 0/ 0 > > 5c5d2100 soctcp sqlexec 285 111 5 26082 26866 0/ 1 1/ 1 0/ 0 > > 5a9ed510 soctcp sqlexec 284 110 5 118 119 0/ 1 1/ 1 0/ 0 > > 5848dcb0 soctcp sqlexec 283 109 5 921 1015 0/ 1 1/ 1 0/ 0 > > 51e56220 soctcp sqlexec 280 108 5 558 706 0/ 1 1/ 1 0/ 0 > > 4ce092c0 soctcp sqlexec 278 14 5 21339 22285 0/ 1 1/ 1 0/ 0 > > 5b96c840 soctcp sqlexec 277 13 5 102 103 0/ 1 1/ 1 0/ 0 > > 4d391d58 soctcp sqlexec 270 102 5 853 981 0/ 1 1/ 1 0/ 0 > > 570d6b40 soctcp sqlexec 264 58 5 111 119 0/ 1 1/ 1 0/ 0 > > 54cf0ce8 soctcp sqlexec 263 57 5 59 61 0/ 1 1/ 1 0/ 0 > > 5af4a050 soctcp sqlexec 256 104 5 48543 50290 0/ 1 1/ 1 0/ 0 > > 5ade1500 soctcp sqlexec 255 103 5 376 398 0/ 1 1/ 1 0/ 0 > > 598094b8 soctcp sqlexec 235 86 5 60 62 0/ 1 1/ 1 0/ 0 > > 56c24c60 soctcp sqlexec 233 97 5 26929 27477 0/ 1 1/ 1 0/ 0 > > 4f07c818 soctcp sqlexec 232 96 5 134 135 0/ 1 1/ 1 0/ 0 > > 53912590 soctcp sqlexec 225 94 5 47590 55434 0/ 1 1/ 1 0/ 0 > > 4ce01638 soctcp sqlexec 224 93 5 120 121 0/ 1 1/ 1 0/ 0 > > 4ce94780 soctcp sqlexec 187 34 5 214 214 0/ 1 1/ 1 0/ 0 > > 4ce5c708 soctcp sqlexec 181 88 5 566 614 0/ 1 1/ 1 0/ 0 > > 590d5358 soctcp sqlexec 179 87 5 980 1046 0/ 1 1/ 1 0/ 0 > > 4ce5c128 soctcp sqlexec 176 85 5 1146 1330 0/ 1 1/ 1 0/ 0 > > 4cebf948 soctcp sqlexec 172 27 5 48093 48882 0/ 1 1/ 1 0/ 0 > > 4ce38828 soctcp sqlexec 171 26 5 224 225 0/ 1 1/ 1 0/ 0 > > 53a08320 soctcp sqlexec 170 84 5 40890 42500 0/ 1 1/ 1 0/ 0 > > 58260730 soctcp sqlexec 169 83 5 365 387 0/ 1 1/ 1 0/ 0 > > 58181148 soctcp sqlexec 168 82 5 34302 35272 0/ 1 1/ 1 0/ 0 > > 4f253028 soctcp sqlexec 167 81 5 122 123 0/ 1 1/ 1 0/ 0 > > 564b6a20 soctcp sqlexec 164 78 5 49541 51060 0/ 1 1/ 1 0/ 0 > > 564b6418 soctcp sqlexec 163 77 5 124 125 0/ 1 1/ 1 0/ 0 > > 56837748 soctcp sqlexec 162 75 5 52358 54060 0/ 1 1/ 1 0/ 0 > > 57e33730 soctcp sqlexec 161 74 5 124 125 0/ 1 1/ 1 0/ 0 > > 56133090 soctcp sqlexec 156 72 5 40260 42354 0/ 1 1/ 1 0/ 0 > > 4fdd0a28 soctcp sqlexec 155 71 5 126 127 0/ 1 1/ 1 0/ 0 > > 57007888 soctcp sqlexec 153 70 5 87654 90293 0/ 1 1/ 1 0/ 0 > > 510498e0 soctcp sqlexec 152 69 5 220 221 0/ 1 1/ 1 0/ 0 > > 5659a0a0 soctcp sqlexec 145 64 5 85484 87448 0/ 1 1/ 1 0/ 0 > > 4fd2b028 soctcp sqlexec 144 63 5 191 192 0/ 1 1/ 1 0/ 0 > > 55a80028 soctcp sqlexec 141 53 5 36853 38083 0/ 1 1/ 1 0/ 0 > > 4fe0c0a0 soctcp sqlexec 140 52 5 108 109 0/ 1 1/ 1 0/ 0 > > 4ef17148 soctcp sqlexec 138 60 5 35062 36168 0/ 1 1/ 1 0/ 0 > > 53471190 soctcp sqlexec 137 59 5 122 123 0/ 1 1/ 1

Thank you. My experience is little. I don't understand when you refer 'security'. Could you mention any idea? Have you noticed performance degradation since when? Server is for test now. How is your Informix server uptime: "onstat -" output ? In this moment 15 hrs. Are you regularly updating your database statistics? Yes How is your machine idle time? Could you post an "sar 1 5" output? Linux 2.6.32-131.0.15.el6.x86_64 23/08/11 _x86_64_ (4 CPU) 13:45:57 CPU %user %nice %system %iowait %steal %idle 13:45:58 all 0,00 0,00 0,33 0,00 0,00 99,67 13:45:59 all 0,62 0,00 0,62 0,00 0,00 98,75 13:46:00 all 0,31 0,00 0,31 0,94 0,00 98,44 13:46:01 all 0,00 0,00 0,42 0,00 0,00 99,58 13:46:02 all 0,55 0,00 0,55 0,55 0,00 98,34 Media: all 0,31 0,00 0,46 0,26 0,00 98,97 Is there any other application running on Informix machine, or is it an Informix dedicated server? Only informix.

Ok by security advisors, I mean that your applications are all connecting to Informix via informix user, this is not right, not recommended, at all. Informix user must only be used by DBAs, and only from specified and known places/times. If you really need a general application user, create one, give it a strong password, and then create your DSN with its properties. After that, we recommend you to change your informix password, as soon as possible, of course. It really seems your Informix server is just fine, if you are getting slow performance, there must be some modelling of your database (eg missing indexes, bad normalized tables, etc) and/or application troubles. My final suggestion: turn on your SQL trace feature, and watch reports for slowest running queries. Last question: is it a brand new system, or it was migrated from another Informix installation/another database ? Hope it helps. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator - Cleartech Ltda BRIUG website administrator Informix independent consultant > To: ids@iiug.org > From: licu99@gmail.com > Subject: Re: RE: sessions multiple Informix driver [28372] > Date: Wed, 26 Sep 2012 15:29:31 -0400 > > Thank you. My experience is little. > > I don't understand when you refer 'security'. Could you mention any idea? > > Have you noticed performance degradation since when? > > Server is for test now. > > How is your Informix server uptime: "onstat -" output ? > > In this moment 15 hrs. > > Are you regularly updating your database statistics? > > Yes > > How is your machine idle time? Could you post an "sar 1 5" output? > > Linux 2.6.32-131.0.15.el6.x86_64 23/08/11 _x86_64_ (4 CPU) > > 13:45:57 CPU %user %nice %system %iowait %steal %idle > 13:45:58 all 0,00 0,00 0,33 0,00 0,00 99,67 > 13:45:59 all 0,62 0,00 0,62 0,00 0,00 98,75 > 13:46:00 all 0,31 0,00 0,31 0,94 0,00 98,44 > 13:46:01 all 0,00 0,00 0,42 0,00 0,00 99,58 > 13:46:02 all 0,55 0,00 0,55 0,55 0,00 98,34 > Media: all 0,31 0,00 0,46 0,26 0,00 98,97 > > Is there any other application running on Informix machine, or is it an > Informix dedicated server? > > Only informix. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Thank you for your recomendation. The sql trace feature is ok. It is migration. Now is better. Thank you for all.