> 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
Cool info. Here are our numbers. We have two TSM servers, perhaps soon
to be three, as our DB's are getting large, and expiration takes about
48hours to complete.
tsm: TSM1>select pct_utilized, avail_space_mb from db
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
80.5 124956
tsm: TSM1>select activity, cast ((end_time) as date) as "Date"
,(examined/cast(( end_time-start_time) seconds as decimal(18,13))
*3600) "Objects Examin ed Up/Hr" from summary where
activity='EXPIRATION' and days (end_time) -days(start_time)=0
ACTIVITY Date Objects Examined Up/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 2224800
EXPIRATION 2005-03-09 1566000
EXPIRATION 2005-03-10 1724400
EXPIRATION 2005-03-11 1623600
EXPIRATION 2005-03-12 1713600
EXPIRATION 2005-03-13 1580400
EXPIRATION 2005-03-14 2347200
EXPIRATION 2005-03-15 1641600
EXPIRATION 2005-03-16 2214000
EXPIRATION 2005-03-17 1551600
EXPIRATION 2005-03-19 1540800
EXPIRATION 2005-03-20 2833200
EXPIRATION 2005-03-21 1702800
EXPIRATION 2005-03-22 2224800
EXPIRATION 2005-03-23 1670400
EXPIRATION 2005-03-24 2163600
EXPIRATION 2005-03-25 1620000
EXPIRATION 2005-03-26 2534400
EXPIRATION 2005-03-27 1648800
EXPIRATION 2005-03-28 2426400
EXPIRATION 2005-03-30 2656800
EXPIRATION 2005-03-31 1620000
EXPIRATION 2005-04-01 2124000
EXPIRATION 2005-04-02 1393200
EXPIRATION 2005-04-03 2124000
EXPIRATION 2005-04-04 1702800
tsm: TSM2>select pct_utilized, avail_space_mb from db
PCT_UTILIZED AVAIL_SPACE_MB
------------ --------------
79.0 124956
tsm: TSM2>select activity, cast ((end_time) as date) as "Date"
,(examined/cast(( end_time-start_time) seconds as decimal(18,13))
*3600) "Objects Examin ed Up/Hr" from summary where
activity='EXPIRATION' and days (end_time) -days(start_time)=0
ACTIVITY Date Objects Examined Up/Hr
------------------ ---------- ---------------------------------
EXPIRATION 2005-03-08 1450800
EXPIRATION 2005-03-09 1076400
EXPIRATION 2005-03-10 1436400
EXPIRATION 2005-03-11 1134000
EXPIRATION 2005-03-12 1544400
EXPIRATION 2005-03-13 1173600
EXPIRATION 2005-03-14 1616400
EXPIRATION 2005-03-15 1044000
EXPIRATION 2005-03-16 1368000
EXPIRATION 2005-03-17 1162800
EXPIRATION 2005-03-18 1515600
EXPIRATION 2005-03-19 1274400
EXPIRATION 2005-03-20 1656000
EXPIRATION 2005-03-22 1292400
EXPIRATION 2005-03-23 1634400
EXPIRATION 2005-03-24 1152000
EXPIRATION 2005-03-27 1764000
EXPIRATION 2005-03-28 1659600
EXPIRATION 2005-03-29 860400
EXPIRATION 2005-03-31 1630800
EXPIRATION 2005-04-01 1206000
EXPIRATION 2005-04-03 1656000
EXPIRATION 2005-04-05 1177200
EXPIRATION 2005-04-06 1652400
Steve Roder
University at Buffalo
([EMAIL PROTECTED] | (716)645-3564)
