Problem of Performance

Hi all: I at the moment have problems with my database server (SBD) INFORMIX. Of a little while to another one the parametros of the exit: onstat - p has changed radically. This SBD I have it in production reason why modifying parametros online necessarily pushes to me to reinitiate the instance which I CANNOT DO IT at the moment. It wanted that they help me with some recommendation that I can do online and improve the performance without sifnigique to reinitiate the instance. Date's: OS: HP-UX 11.11 Informix 7.31 FD8 $ onstat -p Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 1559369 3282960 183418335 99.15 473212 2046171 829030 42.92 isamtot open start read write rewrite delete commit rollbk 90390031 452883 7940465 68028661 927906 65065 560 2957 1 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 2112.03 296.16 4 8 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 246592 2 117743516 0 0 28 1537 148577 ixda-RA idx-RA da-RA RA-pgsused lchwaits 526391 19366 155945 701355 135047

Query sysmaster:syssessprof. Find which session are doing most buffered reads... Run the sql from these sessions with set explain on and find if they are using indexes... and the right indexes exist... Get Art Kagel's utils2_ak from www.iiug.org Software Section and run it to do the right update statistics... Check OPTCOMPIND..if it = 2 you may be able to set it at a session level via a SET command (?) to get index usage back again..

On 9 Apr 2006 09:00:26 -0700, david@smooth1.co.uk wrote: Query sysmaster:syssessprof. Find which session are doing most buffered reads... Run the sql from these sessions with set explain on and find if they are using indexes... and the right indexes exist... Get Art Kagel's utils2_ak from www.iiug.org Software Section and run it to do the right update statistics... Check OPTCOMPIND..if it = 2 you may be able to set it at a session level via a SET command (?) to get index usage back again..