The "Amount of backup files, in kilobytes, sent by the client to the server"
does include client retries (at least at 4.2.0 level). We've just
experienced this when a node that retries a huge file shows sending 19 GB
instead of the normal 8 GB.
Field 17 from the accounting record below shows this (19,350,787).
4,0,ADSM,09/12/2002,01:46:22,COWSVP08,,WinNT,1,Tcp/Ip,1,0,0,0,0,2569,
19350787,0,0,19355216,9883,205,9094,0,4,0,0,0,0,2,0
Tim Rushforth
City of Winnipeg
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Bill Boyer
> Sent: Wednesday, September 18, 2002 3:10 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Backup reporting
>
>
> There was a problem where the bytes transferred in the summary table as
> zero. It has been fixed in later patch levels. I'm not sure what the APAR
> number is or the level where it was fixed.
>
> If you need this data, turn on the accounting records. There is an
> additional field "Amount of backup files, in kilobytes, sent by the client
> to the server" in addition to the "Amount of data, in kilobytes,
> communicated between the client node and the server during the
> session". The
> bytes communicated is the total bytes transferred and includes and
> re-transmissions/retries. I believe the "Amount of backup files, in
> kilobytes, sent by the client to the server" is just what was sent AND
> stored in TSM.
>
> I haven't fully looked into this, but if I'm trying to get a total for the
> amount of data backed up I would be using this field as opposed
> to the bytes
> transmitted field. Something for me to add to my Honey-Do list..:-)
>
> Bill Boyer
> DSS, Inc.
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Mark Bertrand
> Sent: Wednesday, September 18, 2002 2:39 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Backup reporting
>
>
> Paul and all,
>
> When I attempt to use any of the following select statements my "Total MB"
> returned is always 0. I get my list of nodes but there is never
> any numbers
> for size.
>
> Since this is my first attempt at select statements, I am sure I doing
> something wrong. I have tried from command line and through macro's.
>
> I am trying this on a W2K TSM v4.2.2 server.
>
> Thanks,
> Mark B.
>
> -----Original Message-----
> From: Seay, Paul [mailto:seay_pd AT NAPTHEON DOT COM]
> Sent: Monday, September 16, 2002 11:43 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Backup reporting
>
>
> See if these will help:
>
> /* SQL Script: */
> /* */
> /* backup_volume_last_24hours.sql */
> /* Date Description */
> /* 2002-06-10 PDS Created */
>
> /* Create Report of total MBs per each session */
>
> select entity as "Node Name ", cast(bytes/1024/1024 as decimal(10,3))
> as "Total MB ", cast(substr(cast(end_time-start_time as
> char(17)),3,8) as
> char(8)) as "Elapsed ", substr(cast(start_time as char(26)),1,19) as
> "Date/Time ", case when cast((end_time-start_time) seconds as
> decimal) >0 then cast(bytes/cast((end_time-start_time) seconds as
> decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as "
> MB/Sec" from summary where start_time>=current_timestamp - 1 day and
> activity='BACKUP'
>
> /* Create Report of total MBs and length of backup for each node */
>
> select entity as "Node Name ", cast(sum(bytes/1024/1024) as
> decimal(10,3)) as "Total MB", substr(cast(min(start_time) as
> char(26)),1,19) as "Date/Time ",
> cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
> char(8)) as "Length " from summary where start_time>=current_timestamp -
> 22 hours and activity='BACKUP' group by entity
>
> /* Create Report of total backed up*/
>
> select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup"
> from summary where start_time>=current_timestamp - 1 day and
> activity='BACKUP'
>
|
