bumerang
12th March 2002, 17:50
Below is a out put onstat -p each taken after 12 minutes.
"lchwaits" value has over 600000 incresed.
We use baan IV appliction on HP-UX B11
What do you think about this values. Is it normal?
Thank you for help?
sory for long message!..
boytas:/home/hamdi#onstat -p
Informix Dynamic Server Version 7.31.FD1 -- On-Line (CKPT REQ) -- Up 48 days 04:37:46 -- 2110032 Kbytes
Blocked:CKPT
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
141551932 259052223 4487313113 96.85 12620563 29444359 113530370 88.88
isamtot open start read write rewrite delete commit rollbk
4096103098 26489979 317135294 2260331478 11950095 20022369 11684512 11620405 100587
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 282250.47 325252.46 2862 5729
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
12839630 0 1205640590 0 0 15822 2443107 811699
ixda-RA idx-RA da-RA RA-pgsused lchwaits
41194583 2151 7517858 45041167 214605743
boytas:/home/hamdi#onstat -p
Informix Dynamic Server Version 7.31.FD1 -- On-Line -- Up 48 days 04:51:13 -- 2110032 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
141684045 259218401 4496206575 96.85 12657256 29522745 113779453 88.88
isamtot open start read write rewrite delete commit rollbk
4104627245 26578305 317858475 2264325096 11986524 20073896 11692818 11643457 100588
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 283016.91 325979.71 2867 5738
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
12857007 0 1208077759 0 0 15901 2451077 814628
ixda-RA idx-RA da-RA RA-pgsused lchwaits
41274438 2156 7517874 45117500 215277764
Below you can see, for each one CPU over 6000 system call
boytas:/home/hamdi#sar -c 2 9
HP-UX boytas B.11.00 U 9000/800 03/12/02
17:46:52 scall/s sread/s swrit/s fork/s exec/s rchar/s wchar/s
17:46:54 24633 1881 1768 0.00 0.00 723932 76418
17:46:56 26727 1766 1668 0.00 0.00 1727045 57059
17:46:58 25240 1812 1639 0.50 0.50 1105408 54784
17:47:00 26241 1921 1802 0.50 0.50 373248 77824
17:47:02 26937 1891 1772 0.00 0.00 418816 146432
17:47:04 22964 2116 1969 0.50 0.50 310802 110633
17:47:06 27617 2168 2084 0.00 0.00 251392 141312
17:47:08 26730 1918 1772 0.00 0.00 969998 69795
17:47:10 20892 1388 1356 0.00 0.00 303598 81817
Average 25336 1874 1759 0.17 0.17 688062 90631
"lchwaits" value has over 600000 incresed.
We use baan IV appliction on HP-UX B11
What do you think about this values. Is it normal?
Thank you for help?
sory for long message!..
boytas:/home/hamdi#onstat -p
Informix Dynamic Server Version 7.31.FD1 -- On-Line (CKPT REQ) -- Up 48 days 04:37:46 -- 2110032 Kbytes
Blocked:CKPT
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
141551932 259052223 4487313113 96.85 12620563 29444359 113530370 88.88
isamtot open start read write rewrite delete commit rollbk
4096103098 26489979 317135294 2260331478 11950095 20022369 11684512 11620405 100587
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 282250.47 325252.46 2862 5729
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
12839630 0 1205640590 0 0 15822 2443107 811699
ixda-RA idx-RA da-RA RA-pgsused lchwaits
41194583 2151 7517858 45041167 214605743
boytas:/home/hamdi#onstat -p
Informix Dynamic Server Version 7.31.FD1 -- On-Line -- Up 48 days 04:51:13 -- 2110032 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
141684045 259218401 4496206575 96.85 12657256 29522745 113779453 88.88
isamtot open start read write rewrite delete commit rollbk
4104627245 26578305 317858475 2264325096 11986524 20073896 11692818 11643457 100588
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 283016.91 325979.71 2867 5738
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
12857007 0 1208077759 0 0 15901 2451077 814628
ixda-RA idx-RA da-RA RA-pgsused lchwaits
41274438 2156 7517874 45117500 215277764
Below you can see, for each one CPU over 6000 system call
boytas:/home/hamdi#sar -c 2 9
HP-UX boytas B.11.00 U 9000/800 03/12/02
17:46:52 scall/s sread/s swrit/s fork/s exec/s rchar/s wchar/s
17:46:54 24633 1881 1768 0.00 0.00 723932 76418
17:46:56 26727 1766 1668 0.00 0.00 1727045 57059
17:46:58 25240 1812 1639 0.50 0.50 1105408 54784
17:47:00 26241 1921 1802 0.50 0.50 373248 77824
17:47:02 26937 1891 1772 0.00 0.00 418816 146432
17:47:04 22964 2116 1969 0.50 0.50 310802 110633
17:47:06 27617 2168 2084 0.00 0.00 251392 141312
17:47:08 26730 1918 1772 0.00 0.00 969998 69795
17:47:10 20892 1388 1356 0.00 0.00 303598 81817
Average 25336 1874 1759 0.17 0.17 688062 90631