I am currently working on an automated routine to do DB maintenance and to
alert of any errors or issues but to also automatically do maintenance if
needed. My general rule has always been to do a pack on the db with the file 2
utilization drops below 87% or so.
I know with the advanced Autochk table {tablename} command I can do an analysis
on any individual table and get the utilization, dead/active space and
active/deleted rows into a variable i.e.. {set var vutil = (.#utilization)}.
But I often see that even when I check all of the tables, the utilization comes
back 100 on most, and giving me an average of 99% when you take them all into
account. Then if I do a full autochk at the command line, I get results way
below that average, sometimes as low as 65%. I am not sure why, or if there
are some system tables that are lowering the average. I know I cannot perform
the command of autochk table sys_(any of them), it starts but never gives me
any results.
So my question is, does anyone have a solution to capture the utilization
number of a full autochk (autochk {DBNAME} Full for file 2. I was thinking of
output to a file and then importing that to a table and searching for the text,
then breaking out the number from that string, but that seems like a long road
and I like shortcuts..
Thanks
- Frank
Frank Taylor - Director of Information Technology
F.J. O'Hara & Sons, Inc - Araho Transfer Inc.
Boston, MA - Rockland, ME - Miami, FL
Direct Dial - 617-790-3093
Email: [email protected]
