accounting logs...when you have resourceutilization higher than 1...there's
multiple entries
in the dsmaccnt.log file...
I preferred to use a select statement and get totals out of the summary
table, but that's
screwed up now...
argh!
-----Original Message-----
From: Mr. Lindsay Morris [mailto:lmorris AT servergraph DOT com]
Sent: Friday, September 20, 2002 10:03 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Backup reporting: SUMMARY TABLE ISSUE IS FOUND
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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Bill Boyer
> Sent: Friday, September 20, 2002 10:17 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Joel Fuhrman
> Sent: Friday, September 20, 2002 5:13 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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:Mark.Bertrand AT USUNWIRED DOT COM]
> > 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'
> >
>
|
