I must be missing something.  What's interesting number?  even whole #?

Sung


"ADSM: Dist Stor Manager" <[email protected]> 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

Reply via email to