The problem is the summary table is broken right now. I just got off the phone with Level 2. We think we have identified the cause of the problem. As it turns out the SUMMARY table records are written by the "control" session, not the actual backup sessions. What is happening is the control sessions are timing out and a new control session is being formed to send the statistics information. If you look at the start and end timestamps with the following select and then look at the activity log you will see what I am talking about. This select lists all sessions that have a byte count of zero. You will notice the start and end timestamps are usually the same or only a few seconds apart. The reason is the wrong numbers are being recorded.
select entity, number, start_time, end_time from summary where bytes=0 and start_time >current_timestamp-5 days and activity = 'BACKUP' order by 1,3 The issue is I can envision this is going to be very difficult to fix in the current design. It will be interesting. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Mark Bertrand [mailto:[EMAIL PROTECTED]] 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'
