Sh To:
The way to see if a task is active is to look at the ph_task.tk_enable column. If it is set to 't' then the task is active, if 'f' it is inactive.
As for whether the AUS settings will survive the upgrade, that depends on whether the upgrade includes changes to the sysadmin database which happens from time to time, especially with bigger version jumps.
Also, when upgrading you must wipe the existing data distributions (UPDATE STATISTICS LOW DROP DISTRIBUTIONS) and set completely new ones. Personally I don't like the default set of distributions that AUS produces, but if you prime the pump with the set of distributions that you want, AUS will maintain them for you.
For me the ideal set of distributions is generated by my dostats utility and you can use dostats to prime the pump for AUS. Dostats can even drop the existing distributions for you:
dostats -d <database> --drop-distributions
Alternatively, my dbschema replacement utilility, myschema, will generate a set of update statistics commands to duplicate the level of distributions you currently have if you run it before dropping distributions:
myschema -d <database> --distributions-file=/some/file/path.sql /dev/null
Then you can run the file it produces for you after dropping distributions (or edit the file to add the drop command to the top).
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Wed June 09, 2021 07:53 AM
From: Sh To
Subject: AUS status
Hello,
I slowly prepare the steps to upgrade.
And I see that the "update statistic" is an important one, after the upgrade.
The problem is, I inherited the database without really knowing what it is !! : )
or even what was going on in it.
It seems to me that the AUS is "running":
If sysadmin.ph_run has a run_time with an actual date,
and pretty much all of the fields in sysadmin.ph_task have "T" on everyday,
can I understand that the AUS is scheduled and working?
Ans, if this is the case, this conf won't change after the upgrade isn't it ?
Thanks
------------------------------
Sh To
------------------------------
#Informix