Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi,
is there a SQL command to reset the statistics like "onstat -z"?
I got some scripts with selects from the system tables and
it would be fine if these tables are reset just before the selects.
I know, I could start a cron job for "onstat -z", but then I
have two things to take care of ...
Bye
Helge
↪ replying to Helge Baumann
Madison Pruet — — source: Usenet: comp.databases.informix
use the system command from within a stored procedure.
"Helge Baumann" <Helge.Baumann@gmx.de> wrote in message
news:2b846d54.0408120655.767a90b0@posting.google.com...
> Hi,
>
> is there a SQL command to reset the statistics like "onstat -z"?
>
> I got some scripts with selects from the system tables and
> it would be fine if these tables are reset just before the selects.
>
> I know, I could start a cron job for "onstat -z", but then I
> have two things to take care of ...
>
> Bye
> Helge
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.