----Original Message----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
Of Wanda Prather Sent: Monday, January 12, 2009 10:48 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: I'm missing something somewhere -- I need statistics on
storage pool backup and can't seem to find them

> This will give you the BACKUP stats from the summary table:
>
> select cast(activity as char(7)) as "Action",    left(entity,16) as
> "Client"      ,        cast(month(start_time) as varchar(2))|| '-' ||
> cast(day(start_time) as varchar(2)) as "Date",
> left(cast(time(start_time) as varchar(8) ),5)  as "Start",  cast
> ((end_time-start_time) minutes as decimal(4,0))    as "Min",
> cast(cast(bytes
> as decimal(15,1)) /1024/1024/1024 as decimal(6,1)) as "GB",
> cast(processes as decimal(2)) as  "Pr", cast(mediaw as decimal(5)) as
> MWsec, cast(comm_wait as decimal(6)) as CWsec  from summary  where
> activity IN ( 'BACKUP', 'RESTORE')
>
> That will prove how much data is coming daily per node, but not by
> filespace.  As km says, the only way to get exactly what you asked
> for is probably to do a Q OCC before and after.

I'll stick to the accounting log for this - lower impact, and a bit easier to 
play with.

> FWIW, you are getting >30 MB/sec for the BACKUP STGPOOL process.  If,
> as the names imply, your copy pool is on LTO2, that's about the best
> you can get.
> Easy solution is to throw another pair of drives into that process,
> if you've got them.

And that's the problem -- we're running two processes now; one runs about 194 
GB and the other runs about 580 GB (on average). I'm trying to get that 580 GB 
onto more than just one input tape. And I'm trying to get the per-process 
numbers in an easy-to-digest format to make my case. And yes, the names match 
the media; I've found that a few simple naming conventions make batch scripting 
a whole lot easier.

Thanks-

Tom

CONFIDENTIALITY NOTICE:  This email and any attachments are for the
exclusive and confidential use of the intended recipient.  If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. We do not waive
attorney-client or work product privilege by the transmission of this
message.