Hello All,
i have two questions on this:
In our server all and only the backup-data is going through migration pools.
Comparing this size with the
"Amount of backup files, in kilobytes, sent by the client to the server"
this more real (i believe) backup-data-size_counted-by-migration
has a nearly constant difference of about 15-20 % , no matter what time-period
is selected.
for example:
tsm: ADSMAIX>select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB
Backup from backup_activity" from summary where start_time>=current_timestamp
-30 day and activity='BACKUP'
Total GB Backup from backup_activity
------------------------------------
1928.968
tsm: ADSMAIX>select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB
Backup from migration_activity" from summary where start_time>=current_timestamp
-30 day and activity='MIGRATION'
Total GB Backup from migration_activity
---------------------------------------
1631.496
Question 1 : is it ok to get the datasize of whats being backed up by
the migration ( assuming there is really nothing else doing migration,
like 'move data' ... and accepting that the time_period is slightly shifted )
or is there another way to get the size of Backup data ?
Question 2: we are using archive writing directly onto tapes, and if using
the summary with activity='ARCHIVE' the output may be also too high.
My idea is to get the amount of archive data by the summary of
activity 'STGPOOL BACKUP' together with entity=... .
Is this ok (accepting some time_shifting ) or is there another
way to get the Numer of bytes being archived , some sql script ?
Thanks for any hint !
Rainer
"Rushforth, Tim" wrote:
>
> The "Amount of backup files, in kilobytes, sent by the client to the server"
> does include client retries (at least at 4.2.0 level). We've just
> experienced this when a node that retries a huge file shows sending 19 GB
> instead of the normal 8 GB.
>
> Field 17 from the accounting record below shows this (19,350,787).
>
> 4,0,ADSM,09/12/2002,01:46:22,COWSVP08,,WinNT,1,Tcp/Ip,1,0,0,0,0,2569,
> 19350787,0,0,19355216,9883,205,9094,0,4,0,0,0,0,2,0
>
> Tim Rushforth
> City of Winnipeg
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf
> > Of
> > Bill Boyer
> > Sent: Wednesday, September 18, 2002 3:10 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: 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'
> >
|
