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.solonovi...@bkme.com<mailto:g.solonovi...@bkme.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.solonovi...@bkme.com Please consider the environment before printing this Email -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Haberstroh, Debbie (IT) Sent: Tuesday, November 17, 2009 12:28 AM To: ADSM-L@VM.MARIST.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."
