They are working on a fix.
Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180
-----Original Message-----
From: Joel Fuhrman [mailto:joelf AT CAC.WASHINGTON DOT EDU]
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'
>
|
