ADSM-L

Re: Migration Summary

2005-07-26 15:14:23
Subject: Re: Migration Summary
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 26 Jul 2005 15:14:00 -0400
Thank you very much!!!  Would you happen to know if the mediaw is in
seconds?  Or how I can find out valid values for each column in the summary
table?  Thanks again!

********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************



             "Gilbert,
             Guillaume"
             <guillaume_gilber                                          To
             t AT STORAGETEK DOT COM>         ADSM-L AT VM.MARIST DOT EDU
             Sent by: "ADSM:                                            cc
             Dist Stor
             Manager"                                              Subject
             <[email protected]         Re: Migration Summary
             .EDU>


             07/26/2005 03:04
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






Hi Joni

Try this :

select entity, -
       date(start_time) as "Date", -
       time(start_time) as "Start", -
       time(end_time) as "End", -
       cast((end_time-start_time)seconds as decimal(6,0)) as "Length", -
       cast(bytes/1024/1024 as decimal(8,2)) as "MB",-
       cast(bytes/((cast((end_time-start_time)seconds as
decimal(18,0))))/1024/1024 as decimal(10,2)) as MBs/Secs", -
       processes as "Processes", -
       mediaw as "Media Wait" -
from summary -
where activity='MIGRATION' and -
      start_time>=timestamp(current date - 20 day, '00:00:00') and -
      end_time<=timestamp(current date - 0 day, '22:00:00')

Adjust the start and end_time in the where clause to suit your needs.


Guillaume Gilbert
Storage Architect
514.866.8876 Office
514.866.0901 Fax
514.290.6526 BlackBerry
guillaume_gilbert AT storagetek DOT com
StorageTek Canada Inc.
INFORMATION made POWERFUL

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: July 26, 2005 13:52
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Migration Summary

Hello Everyone,

I am trying to find out how long each migration task takes.  I tried to
do a select statement through the summary table, but I can't seem to get
the information that I want.  It just lumped all migration tasks
together by storage pool and I would like the ability to have each
process reported on, the start/end time and the MB migrated, and the
number of files.  Is this possible?  Thanks in advance!

Here is what I had tried:

select entity,cast(sum(bytes/1024/1024/1024) as decimal(10,3)) as "Total
GB", ' ' as " ",substr(cast(min(start_time) as char(26)),1,19) as "Start
Date/Time",substr(cast(max(end_time) as char(26)),1,19) as "End
Date/Time"
from summary where start_time>=current_timestamp - 24 hours and
activity='MIGRATION' group by entity


********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************

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