ontape -s -L 0 too slowly
Posted in 2009
Topics: Backup & Restore
Hello,please help me,thanks.system:unixware7.1.3,database:informix7.31,after 3 hours' logs as below:Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 89522425 68295086 1135510801 92.12 24508093 18545999 28827885 14.98 isamtot open start read write rewrite delete commit rollbk 4091939804 19337172 33473003 3935210202 2630779 3999491 1511506 3335373 2 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 21980.99 15427.21 1038 2078 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 9451144 157808 1199229097 0 0 1343 583609 15925 ixda-RA idx-RA da-RA RA-pgsused lchwaits 2250057 4310718 46601886 53074976 1263829 Userthreads address flags sessid user tty wait tout locks nreads nwrites 440d2014 ---P--D 1 informix - 0 0 0 1568 38942 440d2510 ---P--F 0 informix - 0 0 0 0 6288140 440d2a0c ---P--F 0 informix - 0 0 0 0 6171380 440d2f08 ---P--F 0 informix - 0 0 0 0 6259979 440d3404 ---P--- 9 informix - 0 0 0 0 498 440d3900 ---P--B 10 informix - 0 0 0 203346 244764 440d47f4 ---P--D 13 informix - 0 0 0 0 0 440d5be4 --AP--M 1036337 informix vt08 0 0 0 370 0 440dfb64 B--PR-- 1105195 wfcard 6 11736674 0 1 6308 0 440e2344 ----X-- 1036337 informix vt08 0 0 0 58096024 0 440e2840 ------- 1036337 informix vt08 0 0 0 33 177632 11 active, 128 total, 55 maximum concurrent Transactions address flags userthread locks log begin isolation retrys coordinator 440fa014 A---- 440d2014 0 0 COMMIT 0 440fa180 A---- 440d2510 0 0 COMMIT 0 440fa2ec A---- 440d2a0c 0 0 COMMIT 0 440fa458 A---- 440d2f08 0 0 COMMIT 0 440fa5c4 A---- 440d3404 0 0 COMMIT 0 440fa730 A---- 440d3900 0 0 COMMIT 0 440faa08 A---- 440d47f4 0 0 COMMIT 0 440fb124 A---- 440d5be4 0 0 COMMIT 0 440fbf5c A---- 440dfb64 1 0 COMMIT 0 440fcd94 A---- 440d5be4 0 0 NOTRANS 0 440fe2e8 A---- 440e2840 0 0 NOTRANS 0 11 active, 128 total, 54 maximum concurrent