wait statistics

when I issue the command onstat -g wst I get the response: wait statistics not enabled. also, when I query the sysmaster table syssesswts there are never any values. How does one enable wait statistics (and is this a recommended practice) thanks for any advice...

Ben Draper <bdraper@mathworks.com> wrote in message news:8dij4s$9qh$1@news.mathworks.com... > when I issue the command onstat -g wst I get the response: > > wait statistics not enabled. > > also, when I query the sysmaster table syssesswts there are never any > values. > > > How does one enable wait statistics (and is this a recommended practice) WSTATS 1 It's recoomended in engine tuning process. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > thanks for any advice... > >

>Subject: wait statistics >From: "Ben Draper" bdraper@mathworks.com >Date: 18.04.00 23:12 W. Europe Daylight Time >Message-id: <8dij4s$9qh$1@news.mathworks.com> > >when I issue the command onstat -g wst I get the response: > >wait statistics not enabled. > >also, when I query the sysmaster table syssesswts there are never any >values. > > >How does one enable wait statistics (and is this a recommended practice) > >thanks for any advice... > > > > > > > > > you have to turn them on. Nona