ADSM-L

[ADSM-L] Elapse time format incorrect in V6

2010-11-13 05:16:08
Subject: [ADSM-L] Elapse time format incorrect in V6
From: Robert Ouzen <rouzen AT UNIV.HAIFA.AC DOT IL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sat, 13 Nov 2010 10:14:48 +0000
Hi

I try to figure how to calculate the elapse time of my backups in version6 , my 
old script V5 give me the correct output in the V6 the format is incorrect.

The script below:

Select substr( entity,1,15) as nodename, -
    date(start_time) as "Date (D/M/Y)", -
    time(start_time) as time, -
    substr(cast(end_time-start_time as varchar(17)),3,8) as elapsed, -
    cast(sum(affected) as varchar(10)) as "Num Obj", -
cast(sum(failed) as varchar(10)) as "Num Obj Failed", -
  case -
    when sum(bytes)>1073741824 then cast(sum(bytes)/1073741824 as varchar(10)) 
|| ' Gb' -
    when sum(bytes)>1048576 then cast(sum(bytes)/1048576 as varchar(10)) || ' 
Mb' -
    when sum(bytes)>1024 then cast(sum(bytes)/1024 as varchar(10)) || ' Kb' -
    else cast(sum(bytes) as varchar(10)) -
end as "Bytes" -
  from summary -
  where activity=upper('$1') and -
     start_time>=timestamp(current_date-$2 day,'16:00:00') and -
     start_time<=timestamp(current_date,'09:00:00') and -
     successful='YES' -
     and entity=upper('$3') -
   group by entity,start_time,end_time

V5 output:

NODENAME               Date (D/M/Y)         TIME             ELAPSED            
   Num Obj        Num Obj Failed      Bytes
------------------          ------------                      --------      
----------                -------              ---------- --------      
-------------
IBROWSE2                 13.11.2010                  02.00.12       00:06:18    
           3755                 0                                  1 Gb

V6 output:

NODENAME              Date (D/M/Y)          TIME             ELAPSED       Num 
Obj         Num Obj Failed      Bytes
----------------           -------------                    ---------        
---------         -----------         ---------------             --------------
SYMSRV01                2010-11-12                  20:33:03      9.000000      
 61                        1                                7 Mb

Regards

Robert

<Prev in Thread] Current Thread [Next in Thread>