On Apr 7, 2005 4:57 AM, Loon, E.J. van - SPLXM <[EMAIL PROTECTED]> wrote: > > I'm begging for your help with this. I would like to ask you to issue the > following SQL statements on your TSM server(s) and send the output > directly > to me: [EMAIL PROTECTED]: > > select activity, cast ((end_time) as date) as "Date" ,(examined/cast > ((end_time-start_time) seconds as decimal(18,13)) *3600) "Objects Examined > Up/Hr" from summary where activity='EXPIRATION' and days (end_time) > -days(start_time)=0 > > select pct_utilized, avail_space_mb from db > > The first statement calculates your expiration performance (objects/hour) > and the second one lists your database size and utilization. > Thank you VERY much for sending me your statistics in advance, I REALLY > appreciate it!!!
ACTIVITY Date Objects ExaminedUp/Hr ------------------ ---------- --------------------------------- EXPIRATION 2005-03-08 1285200 EXPIRATION 2005-03-09 1227600 EXPIRATION 2005-03-10 3394800 EXPIRATION 2005-03-11 3394800 EXPIRATION 2005-03-13 2041200 EXPIRATION 2005-03-14 3978000 EXPIRATION 2005-03-15 2592000 EXPIRATION 2005-03-16 2530800 EXPIRATION 2005-03-17 2037600 EXPIRATION 2005-03-18 2710800 EXPIRATION 2005-03-20 2030400 EXPIRATION 2005-03-21 3898800 EXPIRATION 2005-03-22 3258000 EXPIRATION 2005-03-23 3362400 EXPIRATION 2005-03-23 4957200 EXPIRATION 2005-03-24 3524400 EXPIRATION 2005-03-25 3171600 EXPIRATION 2005-03-27 2098800 EXPIRATION 2005-03-28 4212000 EXPIRATION 2005-03-29 2217600 EXPIRATION 2005-03-30 3204000 EXPIRATION 2005-03-31 3088800 EXPIRATION 2005-04-01 4039200 EXPIRATION 2005-04-03 2692800 EXPIRATION 2005-04-04 4024800 EXPIRATION 2005-04-05 2260800 EXPIRATION 2005-04-06 3225600 EXPIRATION 2005-04-07 3405600 PCT_UTILIZED AVAIL_SPACE_MB ------------ -------------- 68.5 18716 I use a database trigger to keep the utilization percentage below 70. This is a relatively young installation at a relatively small site.
