Server 1:
Reduce AIO VPs down to 4, half are unused and one more is under used.
I see lots of write activity to a dbspace the appears to have indexes. It
may be that your BTREE scanner threads are running almost constantly to keep
up with cleaning your indexes. Unfortunately you cannot tune the BTREE
scanners in 9.40 - yet another reason to upgrade. The scanners in 11.50 not
only can be tuned, but include two advanced scanning algorithms that you can
configure that are FAR lower in overhead.
About 20% of your queries include a sequential scan. You should look at the
table profiles to determine if any larger tables are being scanned that way
and track down the queries that are doing this. Either adjust the queries
or add missing indexes.
I don't understand why you have configured 10 TCP server aliases. Polling
all of these connections ports may be part of the problem. Beyond that I
don't see anything obvious. Maybe someone else will.
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Tue, Jun 23, 2009 at 10:29 PM, PEDRO PEREZ <pedro2263@gmail.com> wrote:
> Continue informaton of the first instance:
>
>
> *********************************************************************************************************************
> onstat -D
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 13:35:58 --
> 11752448 Kbytes
>
> Dbspaces
> address number flags fchunk nchunks flags owner name
> 3aab46490 1 0x20001 1 1 N informix rootdbs
> 3acf02358 2 0x60001 2 4 N B informix nokiadbs
> 3acf027c0 3 0x60001 55 1 N B informix simacdbs8
> 3acf05028 4 0x60001 98 1 N B informix simacdbs9
> 3acf05490 5 0x60001 5 2 N B informix grupomed1
> 3acf058f8 6 0x60001 6 2 N B informix grupomed2
> 3acf0a028 7 0x60001 7 5 N B informix sicri_ncel
> 3acf0a490 8 0x2001 11 4 N T informix temporary
> 3acf0a8f8 9 0x42001 15 4 N TB informix temporary1
> 3acf0f028 10 0x60001 19 7 N B informix ndato_dia
> 3acf0f490 11 0x60001 25 3 N B informix ngrupomed1
> 3acf0f8f8 12 0x60001 28 3 N B informix ngrupomed2
> 3acf13028 13 0x60001 31 10 N B informix dbsindex
> 3acf13490 14 0x60001 41 7 N B informix dbsindex2
> 3acf138f8 15 0x60001 46 4 N B informix otrsdbs1
> 3acf18028 16 0x60001 49 4 N B informix otrsdbs2
> 3acf18490 17 0x60001 93 2 N B informix logsdbs
> 3acf188f8 18 0x60001 120 1 N B informix simacdbs10
> 3acf1c028 19 0x60001 56 7 N B informix simacdbs1
> 3acf1c490 20 0x60001 62 12 N B informix simacdbs2
> 3acf1c8f8 21 0x60001 68 7 N B informix simacdbs3
> 3acf21028 22 0x60001 74 7 N B informix simacdbs4
> 3acf21490 23 0x42001 80 2 N TB informix ntemporary
> 3acf218f8 24 0x42001 82 2 N TB informix ntemporary1
> 3acf25028 25 0x60001 84 1 N B informix nsimacdbs
> 3acf25490 26 0x60001 85 3 N B informix nsicri_ncel
> 3acf258f8 27 0x60001 88 4 N B informix simacdbs5
> 3acf2a028 28 0x60001 89 3 N B informix simacdbs6
> 3acf2a490 29 0x20001 94 1 N informix physdbs
> 3acf2a8f8 30 0x42001 95 1 N TB informix temporary2
> 3acf2e028 31 0x42001 96 1 N TB informix temporary3
> 3acf2e490 32 0x60001 114 3 N B informix nokiadbs2
> 3acf2e8f8 33 0x60001 121 1 N B informix nokiadbs3
> 3acf33028 34 0x60001 116 1 N B informix wcellsdbs
> 3acf33490 35 0x60001 117 1 N B informix simacdbs7
> 3acf338f8 36 0x60001 122 1 N B informix simacdbs11
> 3acf37028 37 0x60001 123 1 N B informix simacdbs12
> 3acf37490 38 0x60001 124 1 N B informix wcellsdbs3
> 3acf378f8 39 0x60001 125 1 N B informix simacdbs13
> 3acf3c028 40 0x60001 126 1 N B informix simacdbs14
> 3acf3c490 41 0x60001 127 1 N B informix simacdbs15
> 41 active, 2047 maximum
>
> Chunks
> address chunk/dbs offset page Rd page Wr pathname
> 3aab468f8 1 1 0 2676 5129 /dev/vx/rdsk/dbdg/raw512m_02
> 3acdb3778 2 2 0 5016332 59542 /dev/vx/rdsk/dbdg/raw10g_02
> 3acdb3910 3 27 0 55873 0 /dev/vx/rdsk/dbdg/raw4g_65
> 3acdb3aa8 4 10 0 510 0 /dev/vx/rdsk/dbdg/raw4g_66
> 3acdb3c40 5 5 0 64183 62278 /dev/vx/rdsk/dbdg/raw6g_01
> 3acdb3dd8 6 6 0 463989 751345 /dev/vx/rdsk/dbdg/raw10g_01
> 3ac8b4028 7 7 0 4431 2686 /dev/vx/rdsk/dbdg/raw512m_03
> 3ac8b41c0 8 7 0 3919 1009 /dev/vx/rdsk/dbdg/raw512m_04
> 3ac8b4358 9 7 0 84013 55 /dev/vx/rdsk/dbdg/raw512m_05
> 3ac8b44f0 10 7 0 176764 583 /dev/vx/rdsk/dbdg/raw512m_11
> 3ac8b4688 11 8 8 75 28018 /dev/vx/rdsk/dbdg/raw2g_01
> 3ac8b4820 12 8 8 1 2 /dev/vx/rdsk/dbdg/raw2g_02
> 3ac8b49b8 13 8 8 1 2 /dev/vx/rdsk/dbdg/raw2g_03
> 3ac8b4b50 14 8 8 1 2 /dev/vx/rdsk/dbdg/raw512m_12
> 3ac8b4ce8 15 9 8 943002 667195 /dev/vx/rdsk/dbdg/raw2g_04
> 3ac8b4e80 16 9 8 1 2 /dev/vx/rdsk/dbdg/raw2g_05
> 3ac995028 17 9 8 1 2 /dev/vx/rdsk/dbdg/raw2g_06
> 3ac9951c0 18 2 0 858674 0 /dev/vx/rdsk/dbdg/raw2g_19
> 3ac995358 19 10 0 213576 4261 /dev/vx/rdsk/dbdg/Ndato_dia_01
> 3ac9954f0 20 10 0 198421 65685 /dev/vx/rdsk/dbdg/Ndato_dia_02
> 3ac995688 21 10 0 92547 63709 /dev/vx/rdsk/dbdg/Ndato_dia_03
> 3ac995820 22 10 0 15178 7303 /dev/vx/rdsk/dbdg/Ndato_dia_04
> 3ac9959b8 23 10 0 642 0 /dev/vx/rdsk/dbdg/Ndato_dia_05
> 3ac995b50 24 10 0 16373 9842 /dev/vx/rdsk/dbdg/Ndato_dia_06
> 3ac995ce8 25 11 0 32084 33406 /dev/vx/rdsk/dbdg/Ngrupomed1_01
> 3ac995e80 26 11 0 10868 854 /dev/vx/rdsk/dbdg/Ngrupomed1_02
> 3acebd028 27 11 0 1209 0 /dev/vx/rdsk/dbdg/Ngrupomed1_03
> 3acebd1c0 28 12 0 623664 856353 /dev/vx/rdsk/dbdg/Ngrupomed2_01
> 3acebd358 29 12 0 2934 10 /dev/vx/rdsk/dbdg/Ngrupomed2_02
> 3acebd4f0 30 12 0 1 0 /dev/vx/rdsk/dbdg/Ngrupomed2_03
> 3acebd688 31 13 0 289871 29987 /dev/vx/rdsk/dbdg/dbsindex_01
> 3acebd820 32 13 0 450828 2089 /dev/vx/rdsk/dbdg/dbsindex_02
> 3acebd9b8 33 13 0 667600 8695 /dev/vx/rdsk/dbdg/dbsindex_03
> 3acebdb50 34 13 0 1338208 18871 /dev/vx/rdsk/dbdg/dbsindex_04
> 3acebdce8 35 13 0 1792759 11999 /dev/vx/rdsk/dbdg/dbsindex_05
> 3acebde80 36 13 0 1631603 18993 /dev/vx/rdsk/dbdg/dbsindex_06
> 3acebe028 37 13 0 1350638 3650 /dev/vx/rdsk/dbdg/dbsindex_07
> 3acebe1c0 38 13 0 1941239 12275 /dev/vx/rdsk/dbdg/dbsindex_08
> 3acebe358 39 13 0 1149676 7714 /dev/vx/rdsk/dbdg/dbsindex_09
> 3acebe4f0 40 13 0 855619 41819 /dev/vx/rdsk/dbdg/dbsindex_10
> 3acebe688 41 14 0 228654 260190 /dev/vx/rdsk/dbdg/dbsindex2_01
> 3acebe820 42 14 0 300042 144972 /dev/vx/rdsk/dbdg/dbsindex2_02
> 3acebe9b8 43 14 0 215471 8302 /dev/vx/rdsk/dbdg/dbsindex2_03
> 3acebeb50 44 14 0 383277 23169 /dev/vx/rdsk/dbdg/dbsindex2_04
> 3acebece8 45 14 0 381857 15733 /dev/vx/rdsk/dbdg/dbsindex2_05
> 3acebee80 46 15 0 1341346 1673126 /dev/vx/rdsk/dbdg/otrsdbs1_01
> 3acebf028 47 15 0 483808 94872 /dev/vx/rdsk/dbdg/otrsdbs1_02
> 3acebf1c0 48 15 0 2775868 895 /dev/vx/rdsk/dbdg/otrsdbs1_03
> 3acebf358 49 16 0 335387 171931 /dev/vx/rdsk/dbdg/otrsdbs2_01
> 3acebf4f0 50 16 0 186968 203020 /dev/vx/rdsk/dbdg/otrsdbs2_02
> 3acebf688 51 16 0 85063 106157 /dev/vx/rdsk/dbdg/otrsdbs2_03
> 3acebf820 52 20 0 283 102 /dev/vx/rdsk/dbdg/raw2g_20
> 3acebf9b8 53 28 0 67955 49643 /dev/vx/rdsk/dbdg/raw4g_51
> 3acebfb50 54 20 0 11611 2566 /dev/vx/rdsk/dbdg/raw2g_86
> 3acebfce8 55 3 0 31230 17410 /dev/vx/rdsk/dbdg/raw20g_07
> 3acebfe80 56 19 0 473733 88041 /dev/vx/rdsk/dbdg/simacdbs1_01
> 3acec4028 57 19 0 636373 2148 /dev/vx/rdsk/dbdg/simacdbs1_02
> 3acec41c0 58 19 0 303629 1092 /dev/vx/rdsk/dbdg/simacdbs1_03
> 3acec4358 59 19 0 674447 4710 /dev/vx/rdsk/dbdg/simacdbs1_04
> 3acec44f0 60 19 0 809402 5163 /dev/vx/rdsk/dbdg/simacdbs1_05
> 3acec4688 61 19 0 112947 6194 /dev/vx/rdsk/dbdg/simacdbs1_06
> 3acec4820 62 20 0 722362 4842 /dev/vx/rdsk/dbdg/simacdbs2_01
> 3acec49b8 63 20 0 1069015 1121 /dev/vx/rdsk/dbdg/simacdbs2_02
> 3acec4b50 64 20 0 1318918 1385 /dev/vx/rdsk/dbdg/simacdbs2_03
> 3acec4ce8 65 20 0 954103 3712 /dev/vx/rdsk/dbdg/simacdbs2_04
> 3acec4e80 66 20 0 1151304 9803 /dev/vx/rdsk/dbdg/simacdbs2_05
> 3acecb028 67 20 0 920211 10272 /dev/vx/rdsk/dbdg/simacdbs2_06
> 3acecb1c0 68 21 0 829545 4059 /dev/vx/rdsk/dbdg/simacdbs3_01
> 3acecb358 69 21 0 457470 3437 /dev/vx/rdsk/dbdg/simacdbs3_02
> 3acecb4f0 70 21 0 1635381 4814 /dev/vx/rdsk/dbdg/simacdbs3_03
> 3acecb688 71 21 0 832520 8027 /dev/vx/rdsk/dbdg/simacdbs3_04
> 3acecb820 72 21 0 307447 3419 /dev/vx/rdsk/dbdg/simacdbs3_05
> 3acecb9b8 73 21 0 99754 7482 /dev/vx/rdsk/dbdg/simacdbs3_06
> 3acecbb50 74 22 0 1237836 2806 /dev/vx/rdsk/dbdg/simacdbs4_01
> 3acecbce8 75 22 0 323930 3850 /dev/vx/rdsk/dbdg/simacdbs4_02
> 3acecbe80 76 22 0 116463 7249 /dev/vx/rdsk/dbdg/simacdbs4_03
> 3acecc028 77 22 0 89882 4728 /dev/vx/rdsk/dbdg/simacdbs4_04
> 3acecc1c0 78 22 0 69442 5540 /dev/vx/rdsk/dbdg/simacdbs4_05
> 3acecc358 79 22 0 8706 3950 /dev/vx/rdsk/dbdg/simacdbs4_06
> 3acecc4f0 80 23 0 4 4 /dev/vx/rdsk/dbdg/temporary_01
> 3acecc688 81 23 0 1 2 /dev/vx/rdsk/dbdg/temporary_02
> 3acecc820 82 24 0 4 4 /dev/vx/rdsk/dbdg/temporary1_01
> 3acecc9b8 83 24 0 1 2 /dev/vx/rdsk/dbdg/temporary1_02
> 3aceccb50 84 25 0 474758 16192 /dev/vx/rdsk/dbdg/Nsimacdbs_01
> 3aceccce8 85 26 0 7083 675 /dev/vx/rdsk/dbdg/Nsicri_ncel_01
> 3acecce80 86 26 0 361 0 /dev/vx/rdsk/dbdg/Nsicri_ncel_02
> 3aced0028 87 26 0 102589 128028 /dev/vx/rdsk/dbdg/Nsicri_ncel_03
> 3aced01c0 88 27 0 613255 41347 /dev/vx/rdsk/dbdg/raw40g_01
> 3aced0358 89 28 0 965652 346502 /dev/vx/rdsk/dbdg/raw30g_01
> 3aced04f0 90 14 0 7355850 180592 /dev/vx/rdsk/dbdg/raw40g_02
> 3aced0688 91 14 16 4674801 875143 /dev/vx/rdsk/dbdg/dbsindex2_06
> 3aced0820 92 28 0 11651 6516 /dev/vx/rdsk/dbdg/raw4g_64
> 3aced09b8 93 17 0 35 18545 /dev/vx/rdsk/dbdg/raw600m_01
> 3aced0b50 94 29 0 134 6503936 /dev/vx/rdsk/dbdg/raw100m_01
> 3aced0ce8 95 30 0 982649 673921 /dev/vx/rdsk/dbdg/raw6g_02
> 3aced0e80 96 31 0 925974 627643 /dev/vx/rdsk/dbdg/temporary_03
> 3aced1028 97 2 0 1870159 92672 /dev/vx/rdsk/dbdg/raw5g_33
> 3aced11c0 98 4 0 182179 35409 /dev/vx/rdsk/dbdg/raw20g_08
> 3aced1358 99 5 0 1846 1591 /dev/vx/rdsk/dbdg/raw2g_72
> 3aced14f0 100 17 0 1 0 /dev/vx/rdsk/dbdg/raw2g_73
> 3aced1688 101 15 0 4009667 850 /dev/vx/rdsk/dbdg/raw4g_50
> 3aced1820 102 20 0 1927 0 /dev/vx/rdsk/dbdg/raw5g_34
> 3aced19b8 103 20 0 66840 4449 /dev/vx/rdsk/dbdg/raw4g_55
> 3aced1b50 104 16 0 62832 20769 /dev/vx/rdsk/dbdg/raw4g_57
> 3aced1ce8 105 27 0 889 9106 /dev/vx/rdsk/dbdg/raw5g_23
> 3aced1e80 106 6 0 13301 42229 /dev/vx/rdsk/dbdg/raw15g_01
> 3aced6028 107 20 0 195538 5157 /dev/vx/rdsk/dbdg/raw3g_07
> 3aced61c0 108 27 0 129 0 /dev/vx/rdsk/dbdg/raw1g_58
> 3aced6358 109 32 0 5978 0 /dev/vx/rdsk/dbdg/raw4g_67
> 3aced64f0 110 20 0 553304 308 /dev/vx/rdsk/dbdg/raw3g_08
> 3aced6688 111 22 0 1498 0 /dev/vx/rdsk/dbdg/raw3g_09
> 3aced6820 112 7 0 18747 8875 /dev/vx/rdsk/dbdg/raw6g_09
> 3aced69b8 113 2 0 627183 0 /dev/vx/rdsk/dbdg/raw2g_87
> 3aced6b50 114 32 0 3121668 122748 /dev/vx/rdsk/dbdg/raw20g_05
> 3aced6ce8 115 19 0 94729 808 /dev/vx/rdsk/dbdg/raw2g_90
> 3aced6e80 116 34 0 1731512 1577700 /dev/vx/rdsk/dbdg/raw12g_02
> 3acefb028 117 35 0 587792 271317 /dev/vx/rdsk/dbdg/raw20g_06
> 3acefb1c0 118 21 0 453 632 /dev/vx/rdsk/dbdg/raw2g_91
> 3acefb358 119 32 0 524675 795023 /dev/vx/rdsk/dbdg/raw16g_01
> 3acefb4f0 120 18 0 1104200 373629 /dev/vx/rdsk/dbdg/raw20g_09
> 3acefb688 121 33 0 1664626 127850 /dev/vx/rdsk/dbdg/raw30g_03
> 3acefb820 122 36 0 86350 35557 /dev/vx/rdsk/dbdg/raw40g_03
> 3acefb9b8 123 37 0 740809 266155 /dev/vx/rdsk/dbdg/raw40g_04
> 3acefbb50 124 38 0 544121 264979 /dev/vx/rdsk/dbdg/raw20g_10
> 3acefbce8 125 39 0 99518 78670 /dev/vx/rdsk/dbdg/raw10g_46
> 3acefbe80 126 40 0 1051824 786886 /dev/vx/rdsk/dbdg/raw20g_19
> 3acf02028 127 41 0 2124804 815853 /dev/vx/rdsk/dbdg/raw20g_20
> 3acf021c0 128 9 0 1 2 /dev/vx/rdsk/dbdg/raw20g_21
> 128 active, 32766 maximum
>
> Expanded chunk capacity mode: enabled
>
>
>
> **************************************************************************************************************
> onstat -g iof
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 13:37:35 --
> 11752448 Kbytes
>
> AIO global files:
> gfd pathname totalops dskread dskwrite io/s
> 3 raw512m_02 7804 2675 5129 0.2
> 4 raw10g_02 806116 795960 10156 16.4
> 5 raw4g_65 7364 7364 0 0.2
> 6 raw4g_66 510 510 0 0.0
> 7 raw6g_01 71109 62002 9107 1.4
> 8 raw10g_01 454422 382189 72233 9.3
> 9 raw512m_03 2423 1302 1121 0.0
> 10 raw512m_04 2381 1927 454 0.0
> 11 raw512m_05 20739 20699 40 0.4
> 12 raw512m_11 23059 22943 116 0.5
> 13 raw2g_01 19889 75 19814 0.4
> 14 raw2g_02 3 1 2 0.0
> 15 raw2g_03 3 1 2 0.0
> 16 raw512m_12 3 1 2 0.0
> 17 raw2g_04 675227 288751 386476 13.8
> 18 raw2g_05 3 1 2 0.0
> 19 raw2g_06 3 1 2 0.0
> 20 raw2g_19 109197 109197 0 2.2
> 21 Ndato_dia_01 33377 31105 2272 0.7
> 22 Ndato_dia_02 130861 123688 7173 2.7
> 23 Ndato_dia_03 81282 74390 6892 1.7
> 24 Ndato_dia_04 12787 12326 461 0.3
> 25 Ndato_dia_05 642 642 0 0.0
> 26 Ndato_dia_06 12412 11773 639 0.3
> 27 Ngrupomed1_01 32961 29787 3174 0.7
> 28 Ngrupomed1_02 7455 7087 368 0.2
> 29 Ngrupomed1_03 1209 1209 0 0.0
> 30 Ngrupomed2_01 518988 448385 70603 10.6
> 31 Ngrupomed2_02 2936 2934 2 0.1
> 32 Ngrupomed2_03 1 1 0 0.0
> 33 dbsindex_01 227395 219093 8302 4.6
> 34 dbsindex_02 378628 377163 1465 7.7
> 35 dbsindex_03 573132 570717 2415 11.7
> 36 dbsindex_04 1166977 1162411 4566 23.8
> 37 dbsindex_05 1661268 1658369 2899 33.9
> 38 dbsindex_06 1494760 1491068 3692 30.5
> 39 dbsindex_07 1239069 1238240 829 25.3
> 40 dbsindex_08 1548317 1546545 1772 31.6
> 41 dbsindex_09 872714 871555 1159 17.8
> 42 dbsindex_10 609149 602670 6479 12.4
> 43 dbsindex2_01 230246 191745 38501 4.7
> 44 dbsindex2_02 179835 160088 19747 3.7
> 45 dbsindex2_03 101761 98803 2958 2.1
> 46 dbsindex2_04 109003 103956 5047 2.2
> 47 dbsindex2_05 195149 188487 6662 4.0
> 48 otrsdbs1_01 1085402 942543 142859 22.1
> 49 otrsdbs1_02 117796 101568 16228 2.4
> 50 otrsdbs1_03 352231 351904 327 7.2
> 51 otrsdbs2_01 106713 89504 17209 2.2
> 52 otrsdbs2_02 129377 115168 14209 2.6
> 53 otrsdbs2_03 68964 62066 6898 1.4
> 54 raw2g_20 291 283 8 0.0
> 55 raw4g_51 68093 64100 3993 1.4
> 56 raw2g_86 9625 9283 342 0.2
> 57 raw20g_07 27805 24223 3582 0.6
> 58 simacdbs1_01 127469 117945 9524 2.6
> 59 simacdbs1_02 105418 104486 932 2.1
> 60 simacdbs1_03 48690 48082 608 1.0
> 61 simacdbs1_04 99593 97074 2519 2.0
> 62 simacdbs1_05 113738 112802 936 2.3
> 63 simacdbs1_06 33011 32161 850 0.7
> 64 simacdbs2_01 113140 109471 3669 2.3
> 65 simacdbs2_02 152275 151499 776 3.1
> 66 simacdbs2_03 177362 176843 519 3.6
> 67 simacdbs2_04 141054 139926 1128 2.9
> 68 simacdbs2_05 175744 171420 4324 3.6
> 69 simacdbs2_06 142537 139642 2895 2.9
> 70 simacdbs3_01 117118 114455 2663 2.4
> 71 simacdbs3_02 69393 68406 987 1.4
> 72 simacdbs3_03 222059 220610 1449 4.5
> 73 simacdbs3_04 120936 118531 2405 2.5
> 74 simacdbs3_05 52538 51428 1110 1.1
> 75 simacdbs3_06 36466 35624 842 0.7
> 76 simacdbs4_01 169197 167366 1831 3.4
> 77 simacdbs4_02 48946 47402 1544 1.0
> 78 simacdbs4_03 31430 30477 953 0.6
> 79 simacdbs4_04 28412 28028 384 0.6
> 80 simacdbs4_05 16036 15437 599 0.3
> 81 simacdbs4_06 6960 6631 329 0.1
> 82 temporary_01 6 4 2 0.0
> 83 temporary_02 3 1 2 0.0
> 84 temporary1_01 8 4 4 0.0
> 85 temporary1_02 3 1 2 0.0
> 86 Nsimacdbs_01 479283 467333 11950 9.8
> 87 Nsicri_ncel_01 1795 1337 458 0.0
> 88 Nsicri_ncel_02 361 361 0 0.0
> 89 Nsicri_ncel_03 79784 69286 10498 1.6
> 90 raw40g_01 126081 121371 4710 2.6
> 91 raw30g_01 759840 714496 45344 15.5
> 92 raw40g_02 5311791 5264593 47198 108.3
> 93 dbsindex2_06 3783080 3554670 228410 77.1
> 94 raw4g_64 8622 6819 1803 0.2
> 95 raw600m_01 3010 20 2990 0.1
> 96 raw100m_01 407989 22 407967 8.3
> 97 raw6g_02 692279 287133 405146 14.1
> 98 temporary_03 640543 287796 352747 13.1
> 99 raw5g_33 314661 303756 10905 6.4
> 100 raw20g_08 84208 79386 4822 1.7
> 101 raw2g_72 2514 1846 668 0.1
> 102 raw2g_73 1 1 0 0.0
> 103 raw4g_50 514039 513884 155 10.5
> 104 raw5g_34 1927 1927 0 0.0
> 105 raw4g_55 21701 20770 931 0.4
> 106 raw4g_57 56391 54703 1688 1.1
> 107 raw5g_23 1502 889 613 0.0
> 108 raw15g_01 15107 11645 3462 0.3
> 109 raw3g_07 41451 40967 484 0.8
> 110 raw1g_58 129 129 0 0.0
> 111 raw4g_67 5978 5978 0 0.1
> 112 raw3g_08 71940 71917 23 1.5
> 113 raw3g_09 1498 1498 0 0.0
> 114 raw6g_09 20295 18747 1548 0.4
> 115 raw2g_87 80044 80044 0 1.6
> 116 raw20g_05 1463823 1444911 18912 29.8
> 117 raw2g_90 14121 13931 190 0.3
> 118 raw12g_02 1860473 1487434 373039 37.9
> 119 raw20g_06 411601 331928 79673 8.4
> 120 raw2g_91 525 448 77 0.0
> 121 raw16g_01 553203 421039 132164 11.3
> 122 raw20g_09 1134102 964116 169986 23.1
> 123 raw30g_03 442968 428356 14612 9.0
> 124 raw40g_03 77352 73857 3495 1.6
> 125 raw40g_04 347559 313382 34177 7.1
> 126 raw20g_10 320324 291074 29250 6.5
> 127 raw10g_46 86703 76195 10508 1.8
> 128 raw20g_19 630158 475528 154630 12.8
> 129 raw20g_20 1492978 1229087 263891 30.4
> 130 raw20g_21 3 1 2 0.0
> 191 online_spsm.15330
>
>
>
> ***************************************************************************************************************
> onstat -u
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 13:38:22 --
> 11752448 Kbytes
>
> Userthreads
> address flags sessid user tty wait tout locks nreads nwrites
> 3abbf6028 ---P--D 1 informix - 0 0 0 658 16626
> 3abbf6850 ---P--F 0 informix - 0 0 0 0 1594561
> 3abbf7078 ---P--F 0 informix - 0 0 0 0 437433
> 3abbf78a0 ---P--F 0 informix - 0 0 0 0 655896
> 3abbf80c8 ---P--F 0 informix - 0 0 0 0 385525
> 3abbf88f0 ---P--F 0 informix - 0 0 0 0 361866
> 3abbf9118 ---P--F 0 informix - 0 0 0 0 375941
> 3abbf9940 ---P--F 0 informix - 0 0 0 0 555165
> 3abbfa168 ---P--F 0 informix - 0 0 0 0 338329
> 3abbfa990 ---P--F 0 informix - 0 0 0 0 447747
> 3abbfb1b8 ---P--F 0 informix - 0 0 0 0 448383
> 3abbfb9e0 ---P--F 0 informix - 0 0 0 0 257727
> 3abbfc208 ---P--F 0 informix - 0 0 0 0 288579
> 3abbfca30 ---P--F 0 informix - 0 0 0 0 231014
> 3abbfd258 ---P--F 0 informix - 0 0 0 0 384644
> 3abbfda80 ---P--F 0 informix - 0 0 0 0 328108
> 3abbfe2a8 ---P--F 0 informix - 0 0 0 0 219324
> 3abbfead0 ---P--F 0 informix - 0 0 0 0 292225
> 3abbff2f8 ---P--F 0 informix - 0 0 0 0 421259
> 3abbffb20 ---P--F 0 informix - 0 0 0 0 429578
> 3abc00348 ---P--F 0 informix - 0 0 0 0 450363
> 3abc00b70 ---P--F 0 informix - 0 0 0 0 406542
> 3abc01398 ---P--F 0 informix - 0 0 0 0 299249
> 3abc01bc0 ---P--F 0 informix - 0 0 0 0 318208
> 3abc023e8 ---P--F 0 informix - 0 0 0 0 495201
> 3abc02c10 ---P--F 0 informix - 0 0 0 0 435106
> 3abc03438 ---P--F 0 informix - 0 0 0 0 446244
> 3abc03c60 ---P--F 0 informix - 0 0 0 0 451025
> 3abc04488 ---P--F 0 informix - 0 0 0 0 580628
> 3abc04cb0 ---P--F 0 informix - 0 0 0 0 242676
> 3abc054d8 ---P--F 0 informix - 0 0 0 0 353004
> 3abc05d00 ---P--F 0 informix - 0 0 0 0 324386
> 3abc06528 ---P--F 0 informix - 0 0 0 0 281993
> 3abc06d50 ---P--- 53 informix - 0 0 0 0 167
> 3abc07578 ---P--B 54 informix - 0 0 0 169064 96
> 3abc07da0 Y--P--- 53325 mac - 3b459f600 0 1 191105 162596
> 3abc08df0 ---P--D 57 informix - 0 0 0 0 0
> 3abc0a668 ---P--- 65485 file - 0 0 1 6969 336
> 3abc0ae90 Y--P--- 67717 mac - 3b0e2ccb8 0 1 0 0
> 3abc0b6b8 B--PR-- 67817 file - 130b58090 0 1 82382 0
> 3abc0cf30 Y--P--D 78 informix - 10a161828 0 0 0 0
> 3abc0d758 Y--P--- 58810 mac - 3b8b472d0 0 1 0 0
> 3abc10020 Y--P--- 60346 mac - 3b2215320 0 1 448 448
> 3abc11898 Y--P--- 60553 mac - 3b7c7c688 0 1 1120 1120
> 3abc13938 Y--P--- 62368 mac - 3b459f468 0 1 0 0
> 3abc159d8 Y--P--- 67831 file - 3ba335d70 0 2 6750 37088
> 3abc16200 Y--P--- 66956 mac - 3af92b138 0 1 3 0
> 3abc16a28 Y--P--- 62924 dsw QUALIPOC 3b38d63e0 0 2 6450 6440
> 3abc182a0 Y--P--- 67514 mac - 3b3051798 0 1 0 0
> 3abc1a340 Y--P--- 63997 mac - 3ad0c0468 0 1 0 0
> 3abc1bbb8 Y--P--- 67462 mac - 3b8157f08 0 1 0 0
> 3abc1c3e0 Y--P--- 66911 mac - 3b2065f88 0 1 5 0
> 3abc1cc08 Y--P--- 58129 mac - 3b81ec930 0 1 0 0
> 3abc1e480 Y--P--- 65408 mac - 3b36012d0 0 1 0 0
> 3abc1eca8 Y--P--- 67820 file - 3b2034988 0 2 41724 39904
> 3abc20d48 ---PR-- 65587 dsw - 0 0 1 1790855 640
> 3abc22de8 Y--P--- 67461 mac - 3b2034a10 0 1 0 0
> 3abc23610 Y--P--- 67444 mac - 3b27bb9f8 0 1 2 0
> 3abc24660 Y--P--- 67879 mac - 3b0b6af60 0 1 0 0
> 3abc256b0 Y--P--- 58349 mac - 3b0f734f0 0 1 0 0
> 3abc287a0 Y--P--- 61021 mac - 3b5d3ed70 0 1 0 0
> 3abc2a018 Y--P--- 48640 vn428f5 PARSIOG 3b2e2c0b0 0 1 284 280
> 3abc2b890 Y--P--- 67895 file - 3b61f54f0 0 1 0 0
> 3abc2c0b8 Y--P--- 67682 mac - 3b30119b8 0 1 3 16
> 3abc2c8e0 Y--P--- 66256 mac - 3b28ab968 0 1 0 0
> 3abc2d930 Y--P--- 58813 mac - 3ad8b90b0 0 1 0 0
> 3abc2f1a8 Y--P--- 67938 mac - 3ad0c0e80 0 1 0 0
> 3abc2f9d0 Y--P--- 58816 mac - 3b0ca43f8 0 1 0 0
> 3abc30a20 Y--P--- 67878 mac - 3b4095ae0 0 1 0 0
> 3abc32298 Y--P--- 58193 mac - 3baa34d70 0 1 863 0
> 3abc34b60 Y--P--- 67948 mac - 3bc222798 0 1 0 0
> 3abc35bb0 Y--P--- 60983 mac - 3b5698ee0 0 1 0 0
> 3abc36c00 Y--P--- 60291 mac - 3b0b6aad0 0 1 705 448
> 3b561f1b8 Y--P--- 67474 mac - 3b2215968 0 1 0 0
> 3b5621258 Y--P--- 66943 mac - 3b588d798 0 1 0 0
> 3b5621a80 Y--P--- 65475 mac - 3b90c7f08 0 1 0 0
> 3b5625398 Y--P--- 62225 mac - 3ae186268 0 1 0 0
> 3b56263e8 Y--P--- 67734 mac - 3b1a9eba8 0 1 0 0
> 3b5628cb0 Y--P--- 58806 mac - 3b41cbf90 0 1 0 0
> 3b5629d00 Y--P--- 66974 mac - 3b415f0f0 0 1 177 0
> 3b562bda0 Y--P--- 60340 mac - 3af13a760 0 1 3024 3024
> 3b562d618 Y--P--- 67691 mac - 3b3214798 0 1 0 0
> 3b562de40 Y--P--- 65391 mac - 3ad48a0b8 0 1 5 0
> 3b562ee90 Y--P--- 65457 mac - 3b873f3e0 0 1 0 0
> 3b5631758 Y--P--- 57549 mac - 3b2beae20 0 1 3 0
> 3b56327a8 Y--P--- 67445 mac - 3b3051930 0 1 0 0
> 3b5632fd0 Y--P--- 67941 mac - 3b459fac8 0 1 0 0
> 3b5635898 Y--P--- 67393 mac - 3b22debc0 0 1 0 0
> 3b56368e8 Y--P--- 67739 mac - 3b206fa00 0 1 0 0
> 3b563a200 Y--P--- 65372 mac - 3b3214578 0 1 0 0
> 3b563aa28 Y--P--- 60500 mac - 3b7fee798 0 1 1548 1120
> 3b563b250 Y--P--- 58817 mac - 3bc222138 0 1 0 0
> 3b563d2f0 Y--P--- 60222 mac - 3b61f5b50 0 1 4462 3024
> 3b5640c08 Y--P--- 55702 mac - 3b3ef6820 0 1 0 0
> 3b5648660 Y--P--- 61447 mac - 3afd111c0 0 1 0 0
> 95 active, 256 total, 221 maximum concurrent
>
>
>
> *********************************************************************************************************************
> onstat -g rea
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 13:39:29 --
> 11752448 Kbytes
>
> Ready threads:
> tid tcb rstcb prty status vp-class name
>
>
>
> **************************************************************************************************************************
> onstat -g wai
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 13:39:54 --
> 11752448 Kbytes
>
> Waiting threads:
> tid tcb rstcb prty status vp-class name
> 2 3ac5ac7f0 0 2 sleeping secs: 1 11lio lio vp 0
> 3 3ac5f8218 0 2 sleeping secs: 1 12pio pio vp 0
> 4 3ac617218 0 2 sleeping secs: 1 13aio aio vp 0
> 5 3ac636218 0 2 sleeping secs: 1 14msc msc vp 0
> 6 3ac665218 0 2 sleeping secs: 1 15adt adt vp 0
> 7 3ac684218 0 2 sleeping secs: 1 16aio aio vp 1
> 8 3ac6a3218 0 2 sleeping secs: 1 17aio aio vp 2
> 9 3ac6c2218 0 2 sleeping secs: 1 18aio aio vp 3
> 10 3ac6e1218 0 2 sleeping secs: 1 19aio aio vp 4
> 11 3ac700218 0 2 sleeping secs: 1 20aio aio vp 5
> 12 3ac71f218 0 2 sleeping secs: 1 21aio aio vp 6
> 13 3ac73e218 0 2 sleeping secs: 1 22aio aio vp 7
> 14 3ac75d458 3abbf6028 4 sleeping secs: 1 6cpu main_loop()
> 15 3ac617730 0 2 sleeping forever 1cpu sm_poll
> 16 3ac7004f0 0 2 sleeping forever 3cpu sm_poll
> 17 3ac5bb218 0 2 sleeping forever 4cpu sm_poll
> 18 3ac7cc1d8 0 2 sleeping forever 5cpu sm_poll
> 25 3ac85b4d0 0 3 sleeping forever 1cpu sm_listen
> 26 3ac8b5b48 0 2 sleeping secs: 1 7cpu sm_discon
> 27 3ac8cb998 0 3 sleeping forever 3cpu sm_listen
> 28 3ac8ef760 0 2 sleeping secs: 1 6cpu sm_discon
> 29 3ac9045c0 0 3 sleeping forever 10cpu sm_listen
> 30 3ac92a418 0 2 sleeping secs: 1 1cpu sm_discon
> 31 3ac93f268 0 3 sleeping forever 5cpu sm_listen
> 32 3ac9630b8 0 2 sleeping secs: 1 6cpu sm_discon
> 33 3ac978028 0 3 sleeping forever 6cpu sm_listen
> 34 3ac998cf8 0 2 sleeping secs: 1 1cpu sm_discon
> 35 3ac9adbd8 0 3 sleeping forever 1cpu tlitcplst
> 36 3ac9c7028 0 3 sleeping forever 3cpu tlitcplst
> 37 3ac9e9d90 0 3 sleeping forever 4cpu tlitcplst
> 38 3aca0d0b8 0 3 sleeping forever 5cpu tlitcplst
> 39 3aca2d418 0 3 sleeping forever 6cpu tlitcplst
> 40 3aca4b6d0 0 3 sleeping forever 7cpu tlitcplst
> 41 3aca6aa28 0 3 sleeping forever 8cpu tlitcplst
> 42 3aca8acf8 0 3 sleeping forever 9cpu tlitcplst
> 43 3acaae0b8 0 3 sleeping forever 10cpu tlitcplst
> 44 3acace388 0 3 sleeping forever 1cpu tlitcplst
> 45 3acaec648 0 3 sleeping forever 3cpu tlitcplst
> 46 3acaecd98 3abbf6850 2 sleeping forever 4cpu flush_sub(0)
> 47 3acb1e078 3abbf7078 2 sleeping forever 8cpu flush_sub(1)
> 48 3acb1e350 3abbf78a0 2 sleeping forever 3cpu flush_sub(2)
> 49 3acb1e628 3abbf80c8 2 sleeping forever 1cpu flush_sub(3)
> 50 3acb1e900 3abbf88f0 2 sleeping forever 9cpu flush_sub(4)
> 51 3acb1ebd8 3abbf9118 2 sleeping forever 7cpu flush_sub(5)
> 52 3acb9e028 3abbf9940 2 sleeping forever 8cpu flush_sub(6)
> 53 3acb9e300 3abbfa168 2 sleeping forever 3cpu flush_sub(7)
> 54 3acb9e5d8 3abbfa990 2 sleeping forever 7cpu flush_sub(8)
> 55 3acb9e8b0 3abbfb1b8 2 sleeping forever 5cpu flush_sub(9)
> 56 3acb9eb88 3abbfb9e0 2 sleeping forever 9cpu flush_sub(10)
> 57 3acc17028 3abbfc208 2 sleeping forever 9cpu flush_sub(11)
> 58 3acc17300 3abbfca30 2 sleeping forever 5cpu flush_sub(12)
> 59 3acc175d8 3abbfd258 2 sleeping forever 6cpu flush_sub(13)
> 60 3acc178b0 3abbfda80 2 sleeping forever 5cpu flush_sub(14)
> 61 3acc17b88 3abbfe2a8 2 sleeping forever 7cpu flush_sub(15)
> 62 3acc90028 3abbfead0 2 sleeping forever 3cpu flush_sub(16)
> 63 3acc90300 3abbff2f8 2 sleeping forever 8cpu flush_sub(17)
> 64 3acc905d8 3abbffb20 2 sleeping forever 10cpu flush_sub(18)
> 65 3acc908b0 3abc00348 2 sleeping forever 5cpu flush_sub(19)
> 66 3acc90b88 3abc00b70 2 sleeping forever 6cpu flush_sub(20)
> 67 3acd09028 3abc01398 2 sleeping forever 7cpu flush_sub(21)
> 68 3acd09300 3abc01bc0 2 sleeping forever 8cpu flush_sub(22)
> 69 3acd095d8 3abc023e8 2 sleeping forever 3cpu flush_sub(23)
> 70 3acd098b0 3abc02c10 2 sleeping forever 7cpu flush_sub(24)
> 71 3acd09b88 3abc03438 2 sleeping forever 6cpu flush_sub(25)
> 72 3acd82028 3abc03c60 2 sleeping forever 9cpu flush_sub(26)
> 73 3acd82300 3abc04488 2 sleeping forever 10cpu flush_sub(27)
> 74 3acd825d8 3abc04cb0 2 sleeping forever 4cpu flush_sub(28)
> 75 3acd828b0 3abc054d8 2 sleeping forever 8cpu flush_sub(29)
> 76 3acd82b88 3abc05d00 2 sleeping forever 10cpu flush_sub(30)
> 77 3acdfc028 3abc06528 2 sleeping forever 8cpu flush_sub(31)
> 78 3acdfc300 0 4 sleeping forever 1cpu kaio
> 80 3acf43028 3abc06d50 3 sleeping forever 7cpu aslogflush
> 81 3acf439e8 3abc07578 2 sleeping secs: 6 4cpu btscanner_0
> 97 3ad2daa78 3abc08df0 4 sleeping secs: 1 1cpu onmode_mon
> 99 3ad12e028 0 4 sleeping forever 6cpu kaio
> 100 3ad12e300 0 4 sleeping forever 8cpu kaio
> 102 3ad229368 0 4 sleeping forever 7cpu kaio
> 103 3ad229640 0 4 sleeping forever 9cpu kaio
> 104 3ad229918 0 4 sleeping forever 10cpu kaio
> 122 3ad1df140 3abc0cf30 2 cond wait bp_cond 10cpu bf_priosweep()
> 155541 3b3389c40 3abc2a018 2 cond wait netnorm 8cpu sqlexec
> 163605 3ad6b05c8 3abc07da0 2 cond wait netnorm 3cpu sqlexec
> 167431 3b278dbd8 3b5640c08 2 cond wait netnorm 5cpu sqlexec
> 170029 3b0cc60b8 3b5631758 2 cond wait netnorm 5cpu sqlexec
> 171273 3b3dca028 3abc1cc08 2 cond wait netnorm 1cpu sqlexec
> 171337 3ba8972d0 3abc32298 2 cond wait netnorm 10cpu sqlexec
> 171510 3b06e3530 3abc256b0 2 cond wait netnorm 1cpu sqlexec
> 171969 3b2065028 3b5628cb0 2 cond wait netnorm 4cpu sqlexec
> 171973 3ad9d7370 3abc0d758 2 cond wait netnorm 3cpu sqlexec
> 171976 3ae89b1c0 3abc2d930 2 cond wait netnorm 3cpu sqlexec
> 171979 3b4aa2d40 3abc2f9d0 2 cond wait netnorm 5cpu sqlexec
> 171980 3aeda7798 3b563b250 2 cond wait netnorm 5cpu sqlexec
> 174739 3b1dc8c60 3b563d2f0 2 cond wait netnorm 1cpu sqlexec
> 174952 3addd0ad8 3abc36c00 2 cond wait netnorm 5cpu sqlexec
> 175058 3ae89bb98 3b562bda0 2 cond wait netnorm 5cpu sqlexec
> 175065 3b41cd028 3abc10020 2 cond wait netnorm 4cpu sqlexec
> 175488 3ae2199b8 3b563aa28 2 cond wait netnorm 6cpu sqlexec
> 175610 3b22de138 3abc11898 2 cond wait netnorm 1cpu sqlexec
> 176547 3ae547028 3abc35bb0 2 cond wait netnorm 5cpu sqlexec
> 176585 3ad991418 3abc287a0 2 cond wait netnorm 4cpu sqlexec
> 177515 3aefba808 3b5648660 2 cond wait netnorm 1cpu sqlexec
> 180268 3afff9148 3b5625398 2 cond wait netnorm 5cpu sqlexec
> 180594 3b297e028 3abc13938 2 cond wait netnorm 1cpu sqlexec
> 181377 3b39716f8 3abc16a28 2 cond wait netnorm 5cpu sqlexec
> 184290 3ba6b8688 3abc1a340 2 cond wait netnorm 1cpu sqlexec
> 188327 3b0e2c658 3b563a200 2 cond wait netnorm 1cpu sqlexec
> 188409 3b4c1b028 3b562de40 2 cond wait netnorm 1cpu sqlexec
> 188411 3b14e7638 3abc1e480 2 cond wait netnorm 1cpu sqlexec
> 188556 3ad2d0c40 3b562ee90 2 cond wait netnorm 1cpu sqlexec
> 188679 3b14e7148 3b5621a80 2 cond wait netnorm 1cpu sqlexec
> 189063 3af904578 3abc20d48 2 sleeping secs: 1 4cpu sqlexec
> 190339 3b5ffa028 3abc2c8e0 2 cond wait netnorm 1cpu sqlexec
> 191822 3aeafb268 3abc1c3e0 2 cond wait netnorm 5cpu sqlexec
> 191965 3b220e0b0 3b5621258 2 cond wait netnorm 4cpu sqlexec
> 191970 3b037e538 3abc16200 2 cond wait netnorm 5cpu sqlexec
> 192036 3b3078ac8 3b5629d00 2 cond wait netnorm 3cpu sqlexec
> 193210 3ae4e5bd8 3b5635898 2 cond wait netnorm 1cpu sqlexec
> 193268 3b39a5bd8 3abc23610 2 cond wait netnorm 3cpu sqlexec
> 193269 3b02a82f8 3b56327a8 2 cond wait netnorm 1cpu sqlexec
> 193299 3b5679028 3abc22de8 2 cond wait netnorm 3cpu sqlexec
> 193300 3b0251418 3abc1bbb8 2 cond wait netnorm 6cpu sqlexec
> 193312 3af87ec78 3b561f1b8 2 cond wait netnorm 4cpu sqlexec
> 193456 3ae30eca8 3abc182a0 2 cond wait netnorm 6cpu sqlexec
> 194116 3b33e1028 3abc2c0b8 2 cond wait netnorm 4cpu sqlexec
> 194176 3ad20b468 3b562d618 2 cond wait netnorm 5cpu sqlexec
> 194211 3b2f12930 3abc0ae90 2 cond wait netnorm 3cpu sqlexec
> 194213 3b0247a10 3b56263e8 2 cond wait netnorm 1cpu sqlexec
> 194226 3b29088d8 3b56368e8 2 cond wait netnorm 6cpu sqlexec
> 194441 3adcbb658 3abc0b6b8 2 sleeping forever 1cpu sqlexec
> 194443 3ad2fc028 3abc1eca8 2 cond wait netnorm 1cpu sqlexec
> 194505 3afacf890 3abc159d8 2 cond wait netnorm 5cpu sqlexec
> 194635 3b2152860 3abc30a20 2 cond wait netnorm 1cpu sqlexec
> 194636 3b588d2d0 3abc24660 2 cond wait netnorm 4cpu sqlexec
> 194860 3b4aa0bd8 3abc25ed8 2 cond wait netnorm 1cpu sqlexec
> 194861 3aeadda48 3abc1d430 2 cond wait netnorm 1cpu sqlexec
> 195111 3ad212838 3abc2b890 2 cond wait netnorm 5cpu sqlexec
> 195114 3af92b358 3b5630708 2 sleeping secs: 1 3cpu sqlexec
> 195115 3b0f73578 3b562cdf0 2 cond wait netnorm 3cpu sqlexec
>
>
>
> *******************************************************************************************************************
> onstat -g ses:
>
> I don't have permission to run this command.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b680fe677a046d17e523