What do you mean by the backup window?
The window for the schedule is just the window to start the backup.
If you have an expectation of completing a given client's backup, or all
client backups by a certain time, that is more relevant. Our backup
standard is one a day for most clients, one a week for others, and one a
month for one.
Management once casually asked what TSM backups run into the work day.
It was not nearly as easy as I thought. Like you, we have numerous TSM
servers.
>From a comma delimited command line, I used a SQL select to pull
information from the summary table:
select entity as "Client Node ", end_time-start_time,
date(start_time)as "StartDate", time(start_time) as "StartTime",
date(end_time) as "EndDate", time(end_time)as "EndTime", schedule_name
as "Schedule Name " from summary -
where-
(activity='BACKUP' and date(start_time)=date(end_time) and
time(start_time)<'08:00' and time(end_time)>'08:00')-
or (activity='BACKUP' and date(start_time)=date(end_time) and
time(start_time) between '08:00' and '17:01')-
or (activity='BACKUP' and date(start_time)<date(end_time) and
time(end_time)>'08:00') -
or (activity='BACKUP' and date(start_time)<date(end_time) AND
end_time-start_time>1 DAY )-
and date(start_time)>date(current_timestamp)-20 days order by 1,2 >>
"Y:\tsm\YourDir\Bus_Hours_Backps_1A.csv"
I did it once and have not used it in over a year.
Things like ServerGraph, TSM Manager, and TSM Works are very good at
producing reports for management.
George Huebschman
Storage Support Team, Media Librarian
Legg Mason, LMTS
410 580-7911 (office)
410 552-8581 (mobile)
Please plant a tree before printing this e-mail, and remember, E-Mail is
forever...but Diamonds are a girl's best friend.
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Haberstroh, Debbie (IT)
Sent: Monday, November 16, 2009 4:28 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Client backup activity
Hello all,
I have been asked to identify the client backups that are not completing
in the backup window. Is anyone currently tracking this type of data,
objects inspected, objects backed up, elapsed time etc, and if so how
are you doing it? Once I gather this I will need to compile it into
some type of chart form.
We have (3) TSM 5.5 servers on AIX5.3 with several hundred clients and I
am looking for something that will enable me to quickly gather and
report on these stats. Thanks.
Debbie Haberstroh
Server Administration
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive
or action-oriented messages to us via electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|
