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.