Unfortunatly I do not speak PERL but I guess I'll have to learn it if the
summary table is FUBAR.
Guillaume
Bill Boyer <bill.boyer AT VERIZON DOT NET>@VM.MARIST.EDU> on 2002-09-18 15:45:37
Veuillez répondre à "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Envoyé par : "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Pour : ADSM-L AT VM.MARIST DOT EDU
cc :
Objet : RE: Réf. : Re: Backup reporting
I believe that this only affects the summary table data, not the accounting
records. The accounting records are correct in the byte counts. I know you
can't get it with a simple SQL, but it's there. Can you speak PERL??
Bill
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Guillaume Gilbert
Sent: Wednesday, September 18, 2002 3:27 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Rif. : Re: Backup reporting
I'm at level 4.2.2.12 of the server on AIX and the summary table problems
are still there. I am currently writing a PMR on this.
Guillaume Gilbert
CGI Canada
Bill Boyer <bill.boyer AT VERIZON DOT NET>@VM.MARIST.EDU> on 2002-09-18 15:10:13
Veuillez ripondre ` "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Envoyi par : "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Pour : ADSM-L AT VM.MARIST DOT EDU
cc :
Objet : Re: Backup reporting
There was a problem where the bytes transferred in the summary table as
zero. It has been fixed in later patch levels. I'm not sure what the APAR
number is or the level where it was fixed.
If you need this data, turn on the accounting records. There is an
additional field "Amount of backup files, in kilobytes, sent by the client
to the server" in addition to the "Amount of data, in kilobytes,
communicated between the client node and the server during the session". The
bytes communicated is the total bytes transferred and includes and
re-transmissions/retries. I believe the "Amount of backup files, in
kilobytes, sent by the client to the server" is just what was sent AND
stored in TSM.
I haven't fully looked into this, but if I'm trying to get a total for the
amount of data backed up I would be using this field as opposed to the bytes
transmitted field. Something for me to add to my Honey-Do list..:-)
Bill Boyer
DSS, Inc.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Mark Bertrand
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'
=
|
