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 <abulifia_is_smart AT YAHOO.CO DOT UK>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
15/02/2007 00:04
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT 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.
|
