onstat -p
Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:15:40 -- 2039808 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
57290910 204865922 33221652373 99.83 4158407 37102592 18757603 77.83
isamtot open start read write rewrite delete commit rollbk
67619352616 32820763 268090029 30179662322 2303489 1009986 1091525 1093811 62
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 415904.13 12668.70 401 802
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
7929150 109 431756709 0 0 803 263556 741805
ixda-RA idx-RA da-RA RA-pgsused lchwaits
16862601 14500295 3733907 34174026 1920881
***********
>onstat -g seg
Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:16:38 -- 2039808 Kbytes
Segment Summary:
id key addr size ovhd class blkused blkfree
1 1381451777 200000000 721420288 40480 R 87379 685
2 1381451778 22b000000 1132462080 17840 V 124683 13557
3 1381451779 26e800000 58720256 1456 V 6094 1074
4 1381451780 272000000 58720256 1456 V 6052 1116
5 1381451781 275800000 58720256 1456 V 5283 1885
6 1381451782 279000000 58720256 1456 V 1761 5407
Total: - - 2088763392 - - 231252 23724
********
onstat -d
Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:18:20 -- 2039808 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
22b07e1c0 1 1 1 1 N informix rootdbs
22bd34a00 2 1 2 2 N informix llogdbs
22bd34ae8 3 1 3 1 N informix plogdbs
22bd34bd0 4 2001 4 2 N T informix tempdbs
22bd34cb8 5 1 5 27 N informix datdbs
22bd34da0 6 2001 12 2 N T informix tempdbs1
22bd34e88 7 1 16 15 N informix testdbs
22bd34f70 8 1 27 3 N informix rechnungswesen
22bd35058 9 1 50 1 N informix archiv
9 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
22b07e2a8 1 1 0 20000 4529 PO- /dev/syschunk
22b07e9c0 2 2 20000 200000 4947 PO- /dev/syschunk
22b07ead8 3 3 220000 150000 447 PO- /dev/syschunk
22b07ebf0 4 4 370000 200000 184405 PO- /dev/syschunk
22b07ed08 5 5 50 1000000 75 PO- /dev/datchunk18
22b07ee20 6 5 50 1000000 267 PO- /dev/datchunk25
22b07ef38 7 5 50 1000000 500 PO- /dev/datchunk10
22b07f050 8 5 50 1000000 0 PO- /dev/datchunk14
22b07f168 9 5 50 1000000 464 PO- /dev/datchunk31
22b07f280 10 5 50 1000000 104 PO- /dev/datchunk6
22b07f398 11 5 0 1000000 191 PO- /dev/datchunk19
22b07f4b0 12 6 0 313000 290629 PO- /dev/datchunk17
22b07f5c8 13 5 0 1000000 860 PO- /dev/datchunk26
22b07f6e0 14 5 0 1000000 322 PO- /dev/datchunk11
22b07f7f8 15 5 0 1000000 9324 PO- /dev/datchunk15
22b07f910 16 7 0 1000000 148985 PO- /dev/datchunk20
22b07fa28 17 7 0 1000000 433 PO- /dev/datchunk27
22b07fb40 18 7 0 1000000 151 PO- /dev/datchunk12
22b07fc58 19 7 0 1000000 4 PO- /dev/datchunk16
22b07fd70 20 7 0 1000000 1 PO- /dev/datchunk32
22b07fe88 21 7 0 1000000 580797 PO- /dev/datchunk7
22b0b8850 22 5 0 1000000 11148 PO- /dev/datchunk8
22b0b8968 23 5 0 1000000 12445 PO- /dev/datchunk21
22b0b8a80 24 5 0 1000000 12551 PO- /dev/datchunk28
22b0b8b98 25 5 0 1000000 890 PO- /dev/datchunk22
22b0b8cb0 26 7 0 1000000 263851 PO- /dev/datchunk23
22b0b8dc8 27 8 0 1000000 789 PO- /dev/datchunk2
22b0b8ee0 28 5 0 1000000 5669 PO- /dev/datchunk4
22b0b8ff8 29 7 0 1000000 16934 PO- /dev/datchunk24
22b0b9110 30 5 0 5000 121 PO- /dev/datchunk33
22b0b9228 31 5 0 1000000 12244 PO- /dev/datchunk29
22b0b9340 32 5 0 1000000 11573 PO- /dev/datchunk30
22b0b9458 33 5 25 1000000 12559 PO- /dev/datchunk34
22b0b9570 34 5 25 1000000 8278 PO- /dev/datchunk41
22b0b9688 35 5 25 1000000 5095 PO- /dev/datchunk48
22b0b97a0 36 5 0 1000000 27898 PO- /dev/datchunk55
22b0b98b8 37 8 0 1000000 30925 PO- /dev/datchunk36
22b0b99d0 38 6 5000 235000 234997 PO- /dev/datchunk33
22b0b9ae8 39 4 240000 231000 230997 PO- /dev/datchunk33
22b0b9c00 40 5 0 1000000 14503 PO- /dev/datchunk62
22b0b9d18 41 5 0 1000000 133897 PO- /dev/datchunk42
22b0b9e30 42 8 0 1000000 999997 PO- /dev/datchunk35
22b0c9c50 43 7 0 1000000 18247 PO- /dev/datchunk5
22b0c9d68 44 7 0 1000000 5953 PO- /dev/datchunk37
22b0c9e80 45 7 0 1000000 35599 PO- /dev/datchunk43
22bd34028 46 7 0 1000000 340600 PO- /dev/datchunk49
22bd34140 47 7 0 1000000 550323 PO- /dev/datchunk56
22bd34258 48 7 0 1000000 985260 PO- /dev/datchunk44
22bd34370 49 7 0 1000000 999997 PO- /dev/datchunk50
22bd34488 50 9 0 1000000 223157 PO- /dev/datchunk38
22bd345a0 51 5 0 1000000 60421 PO- /dev/datchunk57
22bd346b8 52 5 0 1000000 180439 PO- /dev/datchunk63
22bd347d0 53 5 0 1000000 14533 PO- /dev/datchunk58
22bd348e8 54 2 0 1000000 694997 PO- /dev/datchunk45
54 active, 2047 maximum
************
onstat -m
Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:18:51 -- 2039808 Kbytes
Message Log File: /informix/online.log
13:47:04 Checkpoint loguniq 360397, logpos 0x36b018
13:57:08 Checkpoint Completed: duration was 5 seconds.
13:57:08 Checkpoint loguniq 360397, logpos 0x11d2018
14:00:21 Logical Log 360397 Complete.
14:00:22 Logical Log 360397 - Backup Started
14:00:39 Logical Log 360397 - Backup Completed
14:07:11 Checkpoint Completed: duration was 1 seconds.
14:07:11 Checkpoint loguniq 360398, logpos 0xa0f14c
14:13:46 Logical Log 360398 Complete.
14:13:47 Logical Log 360398 - Backup Started
14:14:08 Logical Log 360398 - Backup Completed
14:17:12 Checkpoint Completed: duration was 1 seconds.
14:17:12 Checkpoint loguniq 360399, logpos 0x240018
14:27:14 Checkpoint Completed: duration was 1 seconds.
14:27:14 Checkpoint loguniq 360399, logpos 0xd8c018
*************
onstat -D
Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:19:11 -- 2039808 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
22b07e1c0 1 1 1 1 N informix rootdbs
22bd34a00 2 1 2 2 N informix llogdbs
22bd34ae8 3 1 3 1 N informix plogdbs
22bd34bd0 4 2001 4 2 N T informix tempdbs
22bd34cb8 5 1 5 27 N informix datdbs
22bd34da0 6 2001 12 2 N T informix tempdbs1
22bd34e88 7 1 16 15 N informix testdbs
22bd34f70 8 1 27 3 N informix rechnungswesen
22bd35058 9 1 50 1 N informix archiv
9 active, 2047 maximum
Chunks
address chk/dbs offset page Rd page Wr pathname
22b07e2a8 1 1 0 80788 5018 /dev/syschunk
22b07e9c0 2 2 20000 544471 542705 /dev/syschunk
22b07ead8 3 3 220000 27 1129461 /dev/syschunk
22b07ebf0 4 4 370000 14665828 16276107 /dev/syschunk
22b07ed08 5 5 50 3330194 63954 /dev/datchunk18
22b07ee20 6 5 50 3693226 91485 /dev/datchunk25
22b07ef38 7 5 50 3924806 54026 /dev/datchunk10
22b07f050 8 5 50 3005819 5146 /dev/datchunk14
22b07f168 9 5 50 2556638 60355 /dev/datchunk31
22b07f280 10 5 50 6149285 64578 /dev/datchunk6
22b07f398 11 5 0 3351048 81633 /dev/datchunk19
22b07f4b0 12 6 0 14660318 16530324 /dev/datchunk17
22b07f5c8 13 5 0 5369868 116983 /dev/datchunk26
22b07f6e0 14 5 0 2756039 18098 /dev/datchunk11
22b07f7f8 15 5 0 3751442 100414 /dev/datchunk15
22b07f910 16 7 0 2519886 0 /dev/datchunk20
22b07fa28 17 7 0 3020597 0 /dev/datchunk27
22b07fb40 18 7 0 2961168 0 /dev/datchunk12
22b07fc58 19 7 0 3006185 0 /dev/datchunk16
22b07fd70 20 7 0 3002416 0 /dev/datchunk32
22b07fe88 21 7 0 1199256 0 /dev/datchunk7
22b0b8850 22 5 0 4051669 51109 /dev/datchunk8
22b0b8968 23 5 0 4652059 37607 /dev/datchunk21
22b0b8a80 24 5 0 4286159 37021 /dev/datchunk28
22b0b8b98 25 5 0 6271816 25651 /dev/datchunk22
22b0b8cb0 26 7 0 2185444 0 /dev/datchunk23
22b0b8dc8 27 8 0 2887002 9856 /dev/datchunk2
22b0b8ee0 28 5 0 4735443 49371 /dev/datchunk4
22b0b8ff8 29 7 0 2904982 0 /dev/datchunk24
22b0b9110 30 5 0 23896 23 /dev/datchunk33
22b0b9228 31 5 0 6504509 46304 /dev/datchunk29
22b0b9340 32 5 0 7621371 44343 /dev/datchunk30
22b0b9458 33 5 25 8388770 84764 /dev/datchunk34
22b0b9570 34 5 25 6839096 47487 /dev/datchunk41
22b0b9688 35 5 25 7417666 37712 /dev/datchunk48
22b0b97a0 36 5 0 11433054 38697 /dev/datchunk55
22b0b98b8 37 8 0 3440784 32119 /dev/datchunk36
22b0b99d0 38 6 5000 43684 104921 /dev/datchunk33
22b0b9ae8 39 4 240000 1 1 /dev/datchunk33
22b0b9c00 40 5 0 9674343 352861 /dev/datchunk62
22b0b9d18 41 5 0 1600315 27613 /dev/datchunk42
22b0b9e30 42 8 0 7 0 /dev/datchunk35
22b0c9c50 43 7 0 2927830 0 /dev/datchunk5
22b0c9d68 44 7 0 2797774 0 /dev/datchunk37
22b0c9e80 45 7 0 2746234 0 /dev/datchunk43
22bd34028 46 7 0 1930641 0 /dev/datchunk49
22bd34140 47 7 0 1211398 0 /dev/datchunk56
22bd34258 48 7 0 42601 0 /dev/datchunk44
22bd34370 49 7 0 7 0 /dev/datchunk50
22bd34488 50 9 0 1951771 0 /dev/datchunk38
22bd345a0 51 5 0 3151076 65447 /dev/datchunk57
22bd346b8 52 5 0 6366288 36740 /dev/datchunk63
22bd347d0 53 5 0 2517689 60185 /dev/datchunk58
22bd348e8 54 2 0 867594 871397 /dev/datchunk45
54 active, 2047 maximum
************
onstat -g iof
Informix Dynamic Server Version 7.31.FD7 -- On-Line -- Up 2 days 19:19:46 -- 2039808 Kbytes
AIO global files:
gfd pathname totalops dskread dskwrite io/s
3 /dev/syschunk 66682 18 66664 0.3
4 /dev/syschunk 482673 17676 464997 2.0
5 /dev/syschunk 1162575 570984 591591 4.8
6 /dev/syschunk 29021 25161 3860 0.1
7 /dev/datchunk18 520232 472544 47688 2.1
8 /dev/datchunk25 673667 605816 67851 2.8
9 /dev/datchunk10 654100 611712 42388 2.7
10 /dev/datchunk14 99915 99328 587 0.4
11 /dev/datchunk31 508035 486155 21880 2.1
12 /dev/datchunk6 1952558 1898436 54122 8.1
13 /dev/datchunk19 377096 333247 43849 1.6
14 /dev/datchunk17 1174340 572236 602104 4.8
15 /dev/datchunk26 1668881 1588663 80218 6.9
16 /dev/datchunk11 208547 195066 13481 0.9
17 /dev/datchunk15 804755 728195 76560 3.3
18 /dev/datchunk20 125034 125034 0 0.5
19 /dev/datchunk27 117503 117503 0 0.5
20 /dev/datchunk12 94194 94194 0 0.4
21 /dev/datchunk16 101402 101402 0 0.4
22 /dev/datchunk32 96175 96175 0 0.4
23 /dev/datchunk7 52770 52770 0 0.2
24 /dev/datchunk8 938449 899371 39078 3.9
25 /dev/datchunk21 1092558 1061818 30740 4.5
26 /dev/datchunk28 848405 816846 31559 3.5
27 /dev/datchunk22 1258845 1244243 14602 5.2
28 /dev/datchunk23 69439 69439 0 0.3
29 /dev/datchunk2 240657 235815 4842 1.0
30 /dev/datchunk4 1656283 1619342 36941 6.8
31 /dev/datchunk24 91429 91429 0 0.4
32 /dev/datchunk33 7833 7812 21 0.0
33 /dev/datchunk29 2009699 1974065 35634 8.3
34 /dev/datchunk30 2882732 2848402 34330 11.9
35 /dev/datchunk34 3222037 3160275 61762 13.3
36 /dev/datchunk41 2400999 2367021 33978 9.9
37 /dev/datchunk48 2963750 2938241 25509 12.2
38 /dev/datchunk55 5575715 5543933 31782 23.0
39 /dev/datchunk36 394250 369734 24516 1.6
40 /dev/datchunk33 5316 1564 3752 0.0
41 /dev/datchunk33 2 1 1 0.0
42 /dev/datchunk62 2837455 2642187 195268 11.7
43 /dev/datchunk42 69913 63961 5952 0.3
44 /dev/datchunk35 7 7 0 0.0
45 /dev/datchunk5 92389 92389 0 0.4
46 /dev/datchunk37 96097 96097 0 0.4
47 /dev/datchunk43 86065 86065 0 0.4
48 /dev/datchunk49 60477 60477 0 0.2
49 /dev/datchunk56 38230 38230 0 0.2
50 /dev/datchunk44 1360 1360 0 0.0
51 /dev/datchunk50 7 7 0 0.0
52 /dev/datchunk38 125698 125698 0 0.5
53 /dev/datchunk57 463333 441835 21498 1.9
54 /dev/datchunk63 2522922 2496140 26782 10.4
55 /dev/datchunk58 715618 691408 24210 3.0
56 /dev/datchunk45 617802 28311 589491 2.5
