Hi,
The answer is it depends on how you are running Update Statistics, from AUS or from and SQL script or using Art's Dostats program. What are you trying to discover?
I did a Webcast a couple of months ago on this topic, the replay, and slides, are available on our website at:
Informix Webcast 2019 - Informix Update Statistics - Best Practices for Informix DBAs - Advanced DataToolsIn the webcasts, I showed a number of scripts, one to tell when update statistics was run last on a database by table, the command history if run from AUS, and other examples.
To catch if it is running right now try onstat -g sql | grep "UPDATE STATIST"
If you are using AUS, to see completed commands do:
database sysadmin;
select * from aus_cmd_comp;
If it says no rows found then you have not been using AUS.
Hi,
Is there a way to identify whether 'Update Statistics' is running on a server and finding its history?
What are the good practices to schedule update statistics?
With the best regards and thanks,
Saradhi Motamarri
------------------------------
Lester Knutsen
lester@advancedatatools.comAdvanced DataTools Corporation
Voice: 703-256-0267 x102
Visit our Web page:
http://www.advancedatatools.com------------------------------
Original Message:
Sent: Tue March 24, 2020 08:58 PM
From: Saradhi Motamarri
Subject: Update Statistics
Hi,
Is there a way to identify whether 'Update Statistics' is running on a server and finding its history?
#Informix