Here is one I use that creates the following output:
Q_BU_SIZE 10
ENTITY Elapsed Time Avg Obj Avg Bytes Session Count
------------------ ----------------- --------- ----------- -----------
ADBACKUP 00:05:29 1938 251.417 Mb 9
ADJNU1 00:02:04 2032 373.676 Mb 9
ADROOT 00:05:38 1972 251.563 Mb 9
BILLE 00:10:20 2034 171.406 Mb 7
BLADE1 00:03:46 2048 439.144 Mb 9
BLADE2 00:02:14 23 39.365 Mb 9
DALPJPH 00:00:15 78 23.708 Mb 9
DALPKPH 00:05:29 9 10.205 Mb 9
script is:
/************************************************/
/* Script that reports all the objects that are */
/* backed up for all nodes */
/************************************************/
set sqlmathmode round
set sqldatetimeformat eur
select entity, substr(cast(avg(end_time-start_time) as varchar(17)),3,8)
as "Elapsed Time", -
cast(avg(affected) as decimal(7,0)) as "Avg Obj", -
case -
when avg(bytes) > 1073741824 then -
cast(cast(avg(bytes)/1073741824 as decimal(7,3)) as
varchar(24))||' Gb' -
when avg(bytes) > 1048576 then -
cast(cast(avg(bytes)/1048576 as decimal(7,3)) as
varchar(24))||' Mb' -
when avg(bytes) > 1024 then -
cast(cast(avg(bytes)/1024 as decimal(7,3)) as varchar(24))||'
Kb' -
else cast(cast(avg(bytes) as decimal(7,3)) as varchar(24)) -
end as "Avg Bytes", -
count(*) as "Session Count" -
from summary -
where activity='BACKUP' and -
/* affected>0 and - */
days(current_timestamp)-days(start_time) < $1 -
and successful='YES' -
group by entity
/********************************************/
select entity, substr(cast(avg(end_time-start_time) as varchar(17)),3,8)
as "Elapsed Time", -
cast(avg(affected) as decimal(7,0)) as "Avg Obj", -
case -
when avg(bytes) > 1073741824 then -
cast(cast(avg(bytes)/1073741824 as decimal(7,3)) as
varchar(24))||' Gb' -
when avg(bytes) > 1048576 then -
cast(cast(avg(bytes)/1048576 as decimal(7,3)) as
varchar(24))||' Mb' -
when avg(bytes) > 1024 then -
cast(cast(avg(bytes)/1024 as decimal(7,3)) as varchar(24))||'
Kb' -
else cast(cast(avg(bytes) as decimal(7,3)) as varchar(24)) -
end as "Avg Bytes", -
count(*) as "Session Count" -
from summary -
where activity='BACKUP' and -
/* affected>0 and - */
days(current_timestamp)-days(start_time) < $1 -
and successful='YES' -
group by entity -
order by "Elapsed Time" desc
Timothy Hughes wrote:
Hello all,
Is There a way for me to find out the total GB that I
have been backing up each night say for the last week or two?
or even the past couple of days a select query perhaps?
I would like to increase my disk pool and would like
to check each nights backup say for the last couple days
or more.
TSM version 5.2.3.5
AIX 5.2
Thanks for any help!
--
Steve Bennett, (907) 465-5783
State of Alaska, Enterprise Technology Services, Technical Services Section
|