For the record, Servergraph/TSM doesn't use the summary table, so problems there won't make it give incorrect results. It uses the accouting logs which have always been reliable.
--------------------------------- Mr. Lindsay Morris Lead Architect, Servergraph 859-253-8000 ofc 425-988-8478 fax > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Bill Boyer > Sent: Friday, September 20, 2002 10:17 AM > To: [EMAIL PROTECTED] > Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND > > > Yeah, but this used to work just fine. If we're assuming that the > problem is > that the multiple backup sessions (RESOURCEUTILIZATION) is causing the > error, then why did it work after this came out in the V3.7? It > only "broke" > sometime in the late 4.1/4.2 and 5.1 versions of the server. If it used to > work, and now doesn't,...why is it so hard to "fix" it?? So many of us > developed scripts/code and in the case of Lindsay Morris, commercial > software (ServerGraph/TSM), that is not working, giving incorrect results, > and making us look bad in the eye of our management. > > Bill > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of > Joel Fuhrman > Sent: Friday, September 20, 2002 5:13 AM > To: [EMAIL PROTECTED] > Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND > > > To me is seems as though the worker sessions should be informing > the control > session as to the amount of work they have done. Each time the worker > reports in, the control session would send a heart beat to the server thus > avoiding this annoying timeout. > > On Wed, 18 Sep 2002, Seay, Paul wrote: > > > 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' > > >
