On Apr 7, 2005 4:57 AM, Loon, E.J. van - SPLXM <Eric-van.Loon AT klm DOT com> 
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: Eric-van.Loon AT klm DOT com:
> 
> 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.