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'
>
|
