I know that many of us in TSM land have started to jump on the
NDMP bandwagon, me included. I have a few questions that I'm hoping
someone else has already figured out. I'm not finding it in the
archives, so I will ask.
Basically it has to do with the scheduling and reporting of the
NDMP backups.
We have a ton of volumes and q-trees that we have just started
to back up through NDMP. We are running the "backup node NETAPP
/vol/vol1" type commands on the TSM server. To automate this, the
logical way is to create a script with a bunch of "backup node" commands
with "wait=yes" after each one to run them serially to the tape drive.
Simple enough, however when we group them this way, when the
administrative schedule fails to run one of the backups, it's very
non-descript as to which backup failed, so you have to slog through the
accounting log looking for it.
I was thinking that this problem could be somewhat fixed if I
could put out a report that told me which NDMP q-trees/volumes were
backed up in the last 24 hours and which ones were not. Any volume that
didn't get a backup in the last 24 hours would need to be looked into.
The output from a "q nasbackup NETAPP *" is a good start, with
output like this:
Node Name Filespace Object Type Object Size Creation Has Table
of
Name (MB) Date Contents
(TOC)?
--------------- ----------- ----------- ----------- ----------
-------------
BOFS11 /common Full Image 428.5 04/22/05 Yes
13:24:15
BOFS11 /common Differenti- 361.2 04/25/05 Yes
al Image 12:14:54
BOFS11 /temp Full Image 409.4 04/22/05 Yes
13:25:37
BOFS11 /temp Differenti- 268.5 04/25/05 Yes
al Image 15:21:19
BOFS11 /secure Full Image 662,875.1 04/22/05 Yes
15:27:12
BOFS11 /secure Differenti- 7,899.1 04/25/05 Yes
al Image 12:15:27
So, I'm thinking that with some clever sql queries, I could
generate what I want, however, I can't find the tables/columns that
generate this output. The filesspace name and the dates seem to come
from the FILESPACE table, but I'm not finding where it gets the Object
size, the Object type or the TOC listing from. Any ideas?
Or more importantly, does anyone have a better way to report on
NDMP backup failures/successes before I go and reinvent the wheel?
Thanks,
Ben
