I believe that this only affects the summary table data, not the accounting records. The accounting records are correct in the byte counts. I know you can't get it with a simple SQL, but it's there. Can you speak PERL??
Bill -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Guillaume Gilbert Sent: Wednesday, September 18, 2002 3:27 PM To: [EMAIL PROTECTED] Subject: Rif. : Re: Backup reporting I'm at level 4.2.2.12 of the server on AIX and the summary table problems are still there. I am currently writing a PMR on this. Guillaume Gilbert CGI Canada Bill Boyer <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 2002-09-18 15:10:13 Veuillez ripondre ` "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Envoyi par : "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Pour : [EMAIL PROTECTED] cc : Objet : 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' =
