I'm kinda with Dan on this one. You know your database well enough, Frank, to know on average how many days you can go without "needing" a pack. So maybe just put in your code that it packs on certain days of the week, if you don't want to do it every day.
Karen -----Original Message----- From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Jul 21, 2015 12:44 pm Subject: [RBASE-L] - RE: File 2 Utilization I just run a pack routine every night after hours. It only takes less than a minute running locally on the server. Usually there is not much data, if any, removed from the tables. Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: Monday, July 20, 2015 11:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - File 2 Utilization 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]
