Re: interesting number
2006-09-22 16:59:01
I must be missing something. What's interesting number? even whole #?
Sung
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/19/2006
08:54:51 AM:
> ACTIVITY Date Objects ExaminedUp/Hr
> ------------------ ---------- ---------------------------------
> EXPIRATION 2006-09-19 360000
> <-----------------------
>
> LOL
>
> if anyone interested the query looks like this :
>
> tsm: TSM01>q scr exp_perf f=lines
>
> Name Line Command
> Number
> ---------- ------
> ------------------------------------------------------------
> EXP_PERF 1
> 5 select activity, cast ((end_time) as date) as
> "Date",
> (examined/cast((end_time-start_time) seconds
as
> decimal
> (18,13)) *3600) "Objects ExaminedUp/Hr" from
> summary where
> activity='EXPIRATION' and days (end_time)
-days
> (start_time)=0
|
|
|