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:[EMAIL PROTECTED]]On Behalf Of > Bill Boyer > Sent: Wednesday, September 18, 2002 3:10 PM > To: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED]]On Behalf Of > Mark Bertrand > Sent: Wednesday, September 18, 2002 2:39 PM > To: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED]] > Sent: Monday, September 16, 2002 11:43 PM > To: [EMAIL PROTECTED] > 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' >
