Informix Performance.

This is a multi-part message in MIME format. ------=_NextPart_000_0018_01BFFAED.0B640280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit All, Does this performance stats on this instance look ok? Let me know if you need any more information. Any assistance appreciated. Cheers Jim ----------------- output of onstat -p. Informix Dynamic Server Version 7.30.UC7A -- On-Line -- Up 6 days 19:15:33 -- s Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 91580036 19116886 1982886098 95.38 11524180 6683420 461610536 97.50 isamtot open start read write rewrite delete commit rollbk 3106872938 42680061 465523534 1475142871 215771908 2002145 1929260 2579714 28 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 271651.61 55535.35 1642 3884 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 13960265 737 1391934576 1 0 2780 422126 8159866 ixda-RA idx-RA da-RA RA-pgsused lchwaits 54888673 1063632 18601950 74228726 5014792 output of onstat -d Informix Dynamic Server Version 7.30.UC7A -- On-Line -- Up 6 days 19:19:03 -- s Dbspaces address number flags fchunk nchunks flags owner name cbf12158 1 1002 1 1 M informix rootdbs cbf44ad0 2 2 2 2 M informix logdbs cbf44b90 3 2001 3 2 N T informix tmpdbs cbf44c50 4 2 4 13 M informix elitedbs 4 active, 2047 maximum Chunks address chk/dbs offset size free bpages flags pathname cbf12218 1 1 0 152000 114735 PO- /dev/rootdbs cbf122f8 1 1 0 152000 0 MO- /dev/rootdbs_m cbf12b58 2 2 0 104000 3947 PO- /dev/logdbs cbf13a38 2 2 0 104000 0 MO- /dev/logdbs_m cbf12c38 3 3 0 502000 493508 PO- /dev/tmpdbs cbf12d18 4 4 0 1000000 535 PO- /dev/elitedbs cbf13b18 4 4 0 1000000 0 MO- /dev/elitedbs_m cbf12df8 5 4 0 1000000 295 PO- /dev/elitesec1 cbf13bf8 5 4 0 1000000 0 MO- /dev/elitesec1_m cbf12ed8 6 4 0 1000000 80 PO- /dev/elitesec2 cbf13cd8 6 4 0 1000000 0 MO- /dev/elitesec2_m cbf12fb8 7 4 0 1000000 56 PO- /dev/elitesec3 cbf13098 8 4 0 1000000 137 PO- /dev/elitesec4 cbf13e98 8 4 0 1000000 0 MO- /dev/elitesec4_m cbf13178 9 4 0 1000000 83 PO- /dev/elitesec5 cbf39a30 9 4 0 1000000 0 MO- /dev/elitesec5_m cbf13258 10 4 0 1000000 96 PO- /dev/elitesec6 cbf39b10 10 4 0 1000000 0 MO- /dev/elitesec6_m cbf13338 11 4 0 1000000 0 PO- /dev/elitesec7 cbf39bf0 11 4 0 1000000 0 MO- /dev/elitesec7_m cbf13418 12 4 0 1000000 142 PO- /dev/elitesec8 cbf39cd0 12 4 0 1000000 0 MO- /dev/elitesec8_m cbf134f8 13 2 0 1000000 614997 PO- /dev/logdbssec1 cbf39db0 13 2 0 1000000 0 MO- /dev/logdbssec1_m cbf135d8 14 3 0 1000000 999997 PO- /dev/tmpsec1 cbf136b8 15 4 0 1000000 144 PO- /dev/elitesec9 cbf39e90 15 4 0 1000000 0 MO- /dev/elitesec9_m cbf13798 16 4 0 1000000 14 PO- /dev/elitesec10 cbf44830 16 4 0 1000000 0 MO- /dev/elitesec10_m cbf13878 17 4 0 1000000 623496 PO- /dev/elitesec11 cbf44910 17 4 0 1000000 0 MO- /dev/elitesec11_m cbf13958 18 4 0 1000000 999997 PO- /dev/elitesec12 cbf449f0 18 4 0 1000000 0 MO- /dev/elitesec12_m ------=_NextPart_000_0018_01BFFAED.0B640280 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IhMLAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHBwAfAAsAKgAAAAEAMwEB A5AGALALAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAFgAAAEluZm9ybWl4IFBlcmZvcm1hbmNlLgAAAAIBcQABAAAAFgAAAAG/+twPdhqYpP9mvhHU sqIAwE9xbQ0AAAIBHQwBAAAAHwAAAFNNVFA6SklNLkRSVUNFQEpBREVHUk9VUC5DTy5VSwAACwAB DgAAAABAAAYOAMy19Nv6vwECAQoOAQAAABgAAAAAAAAA2pqHWkRX1BGykgDAT3FtDcKAAAALAB8O AQAAAAIBCRABAAAAQwcAAD8HAAAnEgAATFpGdZ6Jbu4DAAoAcmNwZzEyNSYyAPgLYG5nAdA1N08B 9wKkA+MCAGNoCsBzgGV0MCBUYWgDcZUCgH0KgXYIkHdrC4D0ZDQMYGMAUAsDC7YKsWEKgEFsbCwT 1BPURJJvB5F0aAQAIHAEkIUCEHIDgWNlIHMBkP50BCACIBV0C4AWkRZSCQCkb2sW4Gs/FHpMETDC IAeAIGtubwfgBpAkIHkIYCBuCeBkIH0AcHkZcAWwFnALgBYDdKppAiAuFHpBGtFhBBCjBAAXpGFw cAlwYwcw5nQJgBwLQ2gJ4BEQE9TmSgdwE9QgLSCuFHoIYPx0cCKAFuAaEAIgFpIgkApwHAtJG2Np eCBEqHluYSTAYwZSdgSQDCBWH3Eb0SA3LjOAMC5VQzdBICCR4CBPbi1MC4AWcCchAFVwIDYgZGF5 AQQgMTk6MTU6M64zJxIflRPUUANgZgMQomUT1GRzawlwYSsAzRXAYQnBK1JidQNQK0O8JWMA0B9Q GqArAXcFEH8WwSuRLWQsIS1kLLUT1DlhKNA4MDAzKDAooDGQMTY4ODAiODIwkeIwMOAgOTUmgDFg JwBzMGAOQDQxL+AoIDCAM6Y0AdAnADQ2MHAxD1D1MBE5JnA1E8UT1AQAJTD8dG8FQBbgFdADoDWi FpH/ACA1oisyNaMtYhZwNlM3Fe8BACqAN0MFoG0kwDYyA2DpFEBiaxPUMzNgMIABwH45MbEy0DCA L/AzMDMRNRUOQDMzgDQokDQ3Nas78DEANzswMijQNzxwLDkwMWAB0DA8oDQ1vTHhOTpwOtAy8Q4w NzPAizvwPkE4FHpncF82hP8/0TcUP9MtYAVAP9E4MTHR/z/RB0AJACVgP9EsQTdRP9H+YwhwH5Uy 8UQURA9FH0YqnSG7dkJhGDA1QXZ1ESD9ACBoNoNIMCwhGhAnAEjiPw3wGlAWgChwSmMaYHVt/0hw BTAEIA7wSOAfUEOfTLbNRgsyPHA7YDEuOyE7cH8zgDGRPaAwcDLQNaMxsDj/ErAUiS5SC3AWwQkA LVBRlTtIcAlwcQQgAQArUGxr+wQgKEBsNRAigFNhS3FRhP84wR3hBBERIFLQLMAAgBPUODEzOTEw OtA9oDcz/jdNhFYhKKAywA9gMCFNj39OkDJhNaIy0DygOtAx0TgvKNAw4DKQNBt4KFAtUvEm8Wlk eFujKEFcJAfwskEjgGdzSOEaoGwQ4PNRgxPUNTQwkDCgVrAokPs6MDAQM0/xMlAxMCigM/D/JmBZ oTpRWfIz8DvxPeAUev8iHyMlL0UkHyUvJj8nTyhXxyiwMAApL0RicwqwFmDbH5UrUGRU80syYmXR ZxDPDvFdUDWiENF1bkiCFlD/bPJTYWxHGdAacGwCGmBlQPkqlWNiAEA8oTFgV/czYO89YFb0cFdY Bk1YBhtUZOGbA2A1IGRqUG9XNDQrUH8RUE/0TmJ1H3Ynco8X8Wf9c+xiPQBQQE4XL/BX9Hm4bVgG ThFgcr10VNBz7GP/YCE+wXXNfmdWIHbfZJY4QL83MXPnflEA0BvAZcAsPTHzPAAZcGF4B3BLUB6M bZLzas0Q4Gsvc+Ei0QPQGVF5NdFpejdTS8BC4zHRYv8rkQeRbCYKsBWAbx08oHAk/1fyTKcyES/w TKIwYDwAT5E5TUlQT2dAZxCGUGV29i9zropRZoqfi6lNO4BU7Y2PXyAlb7NicBFP8k/y/5AIg2CL 9FYwg3GRO415eG39ViBhMbGUf5WHkS+SOnhk/ZNrYzGxebJ5skynM/CL5f40OoAz8DHClq+N8X0d DiD+ZIqBfmJ+Ypm5o/Ng4Yyc941MgcyYo2Kir6O6mt+SOvuBxpNrZI9RjKKn/4vzOnD/pJ+qjREg EuSnBqyPqJ+pr/+vvpNrCYAxYFnyse+L81k1767Pr9thZZijY7aPso+zn/O5vpNrZmIxYFbSu++k JPdZ8rivr70zmEkxQjHCwP9/i/NWIJZNw2+wcVCFmKNl/8V/vI+9n8iuk2o6EFkgMXDfyq+313m3 x++wCDVvV1Yw/5jwEVDPr8uvzL/S286bDjB/cCEy8tTvjAJWQNFv129j/1qV1AOncBFQ2a/Vr9a/ 3Nv/zpspAHAhV/He39/v3A+wJv433aoBMOOf5K/gr+bMzpv/MkEokE/x6N/G9E/l5c+v6v8/BdQD u2Dece2/6b/qz/Dq/+ycj1J5sZl9pAUzMJ+w