I get this imformation from domdsm.log the installation of tdp for domino will tell you where this is.
whilst it is not 100% and subject to normal 'hit and miss', it is better than nothing. I have found that I get info about backups starting and no info about totals etc if it is a long running process, I have fiddled with duration time in schedules and now get approx 90% reporting. Accuracy does not seem at fault just reporting. (with the number of mailboxes in five figures, selective takes approx 16-28 hours. If duration is not greater than this figure, totals are not reported/logged but the full selective completes. I can check this by trolling thru actlog for a couple of hours.) I have a perl script which gathers all the info for each domino instance each night (30), and puts it into a HTML file, emails it to several people using a perl module to attach multiple files to sendmail message. This gives us a single email with everything in it. Not perfect, but easily understood. Also shows if it is an Incremental, Selective, Archivelog or Journal backup that is running. example of output is TSM Backups - Report by Domino Instance DOMMPXX mpxx 14-02-2007 20:05:13 ========================================================================= mpxx 14-02-2007 20:05:13 Request : INCREMENTAL mpxx 14-02-2007 20:05:13 Database Input List : * mpxx 14-02-2007 20:05:13 Number of Buffers : 8 mpxx 14-02-2007 20:05:13 Buffer Size : 8192 mpxx 14-02-2007 20:05:13 Wait for Tape Mounts? : Yes mpxx 14-02-2007 20:05:13 Process Subdirectories? : Yes mpxx 14-02-2007 20:05:13 TSM Options File : mpxx 14-02-2007 20:05:13 TSM Nodename Override : mpxx 14-02-2007 20:05:13 ------------------------------------------------------------------------- mpxx 14-02-2007 20:50:29 Total Domino databases inspected: xxx,xxx mpxx 14-02-2007 20:50:29 Total Domino databases backed up: 280 mpxx 14-02-2007 20:50:29 Total Domino databases excluded: 0 mpxx 14-02-2007 20:50:29 Total Domino backup objects expired: 0 mpxx 14-02-2007 20:50:29 Throughput rate: 30,706.19 Kb/Sec mpxx 14-02-2007 20:50:29 Total bytes transferred: 128,688,590,848 mpxx 14-02-2007 20:50:29 Elapsed processing time: 1,704.68 Secs mpxx 14-02-2007 20:50:31 ========================================================================= mpxx 14-02-2007 20:50:31 Request : ARCHIVELOG mpxx 14-02-2007 20:50:31 Number of Buffers : 8 mpxx 14-02-2007 20:50:31 Buffer Size : 8192 mpxx 14-02-2007 20:50:31 Wait for Tape Mounts? : Yes mpxx 14-02-2007 20:50:31 Threshold high : 0 mpxx 14-02-2007 20:50:31 Threshold low : 0 mpxx 14-02-2007 20:50:31 TSM Options File : mpxx 14-02-2007 20:50:31 TSM Nodename Override : mpxx 14-02-2007 20:50:31 ------------------------------------------------------------------------- mpxx 14-02-2007 20:52:14 Total Domino transaction log files ready for archive: 26 mpxx 14-02-2007 20:52:14 Total Domino transaction log files archived: 26 mpxx 14-02-2007 20:52:14 Throughput rate: 27,052.07 Kb/Sec mpxx 14-02-2007 20:52:14 Total bytes transferred: 45,744,857,088 mpxx 14-02-2007 20:52:14 Elapsed processing time: 99.93 Secs Allan Mills | AIX and TSM Administrator Business & Technology Services | New South Wales Police 8835 9286 (internal 29286) Ronald Le Large <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 15/02/2007 00:04 Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] SQL date convert Hi everybody, The last time when I posted a question I received a few very useful and quick replies. Thx for that. Hopefully this question is also easy for a few of you to answer. Case: A client want's to know how big the daily backup is for a Lotus client backedp up via TDP. I can embed a "query actlog begind=-1 node=[nodename] msg=4991 " in a script but the output is useless (even with grep) because TDP reports a summary for every *.nfs its backing up and I am only interested in the total bytes transferred. (which is also reported with msg 4991 at the end of the log). The alternative (which has my preference ) is an sql query: select START_TIME,ACTIVITY,ENTITY from summary where ENTITY='[nodename]' and ACTIVITY='BACKUP' but I struggle with the date. The format TSM is using in its table is 2007-01-15 21:08:34.000000 I am only interested in the backupsize of last night so I use " START_TIME='2007-02-14%' but that is obviously not the correct syntax. Does anyone of you know how I must convert the date ? Or is there a possibility to use something like "today-1" like you use with a q actlog. Your advise would be highly appreciated. Thx in advance, Abulifia --------------------------------- New Yahoo! Mail is the ultimate force in competitive emailing. Find out more at the Yahoo! Mail Championships. Plus: play games and win prizes. All mail is subject to content scanning for possible violation of New South Wales Police electronic Mail Policy. All persons are required to familiarise themselves with the content of the policy located on the NSWP Intranet BULLETIN BOARD. This message and any attachment is confidential and may be privileged or otherwise protected from disclosure. If you have received it by mistake, please let us know by reply and then delete it from your system; you should not copy the message or disclose its contents to anyone.
