Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: G.Solonovitch AT bkme
DOT com<mailto:G.Solonovitch AT bkme DOT com>
Please consider the environment before printing this Email
________________________________
From: Grigori Solonovitch
Sent: Tuesday, November 17, 2009 8:09 AM
To: ADSM: Dist Stor Manager
Subject: RE: Client backup activity
Hello Debbie,
For fast daily checks I am using next scripts:
delete script A2_Last_Client_Backups
define script A2_Last_Client_Backups description="List of last file space
backups for nodes"
update script A2_Last_Client_Backups \
"set sqldisplaymode wide"
update script A2_Last_Client_Backups \
"select node_name, filespace_name, filespace_id, filespace_type, \
cast(substring(cast(backup_start as char(26)) from 1 for 16) as char(16)) as
Started, \
cast(substring(cast(backup_end as char(26)) from 1 for 16) as char(16)) as
Ended \
from filespaces \
order by node_name, filespace_id"
delete script A3_Last_Database_Backups
define script A3_Last_Database_Backups description="List of last database
backups for nodes"
update script A3_Last_Database_Backups \
"select node_name, filespace_name, filespace_type, backup_end as Last_Backup \
from filespaces \
where filespace_type = 'API:ORACLE' or filespace_type = 'API:SqlData' or
filespace_type = 'API:ExcData' \
order by filespace_type, node_name, backup_end"
delete script A4_Skipped_Client_Backups
define script A4_Skipped_Client_Backups description="List of file spaces with
skipped backups for nodes"
update script A4_Skipped_Client_Backups \
"set sqldisplaymode wide"
update script A4_Skipped_Client_Backups \
"select node_name, filespace_id, filespace_name, filespace_type, backup_start,
backup_end \
from filespaces \
where cast((current_timestamp-backup_end)days as decimal) \> 1 \
order by node_name, backup_end"
I think you are looking for the last script.
Unfortunately, I couldn't propose anything to build charts. You can use scripts
in batch mode, but response from these scripts look very fine in TSMExplorer
command line (table mode).
In addition, TSMExplorer screens can be converted to HTML format easy to print
and to send by E-mails:
Export table [ console ] for tsmsrv1.bkme.com at 2009-11-17 10:15:20
tsm script: 'A4_SKIPPED_CLIENT_BACKUPS '
Num.
NODE_NAME
FILESPACE_ID
FILESPACE_NAME
FILESPACE_TYPE
BACKUP_START
BACKUP_END
1
LPAR05
14
/bkme/pcard5
JFS
2006-04-19 17:29:15
2006-04-19 17:29:15
2
LPAR05
15
/bkme/pcard6
JFS
2006-04-19 17:30:15
2006-04-19 17:30:16
3
LPAR05
3
/audit
JFS
2007-02-20 15:59:35
2007-02-20 15:59:37
4
LPAR06
4
/audit
JFS
2007-02-19 15:45:20
2007-02-19 15:45:25
5
LPAR06
7
/home/users06
JFS2
2007-06-26 17:05:19
2007-06-26 17:17:02
6
LPAR07
7
/home/users07
JFS
2007-06-30 15:44:22
2007-06-30 15:44:29
7
LPAR07
6
/tsm
JFS
2008-04-14 15:47:20
2008-04-14 15:47:33
8
LPAR08
5
/home/users08
JFS
2007-07-11 16:05:34
2007-07-11 16:05:37
Siberia Software SL<http://www.s-iberia.com>
Usually, it is enough for me.
Kindest regards,
Grigori G. Solonovitch
Senior Technical Architect
Information Technology Bank of Kuwait and Middle East http://www.bkme.com
Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: G.Solonovitch AT bkme
DOT com
Please consider the environment before printing this Email
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Haberstroh, Debbie (IT)
Sent: Tuesday, November 17, 2009 12:28 AM
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
Please consider the environment before printing this Email.
________________________________
"This email message and any attachments transmitted with it may contain
confidential and proprietary information, intended only for the named
recipient(s). If you have received this message in error, or if you are not the
named recipient(s), please delete this email after notifying the sender
immediately. BKME cannot guarantee the integrity of this communication and
accepts no liability for any damage caused by this email or its attachments due
to viruses, any other defects, interception or unauthorized modification. The
information, views, opinions and comments of this message are those of the
individual and not necessarily endorsed by BKME."
|