Hello Dwight,
I have found your queries very good and developed some shell scripts, based on
your queries, to produce reports for:
1) Domain - Node - File Space - Destination - Management Class - Copy Group
Parameters (verexists, verdeleted,retextra, reatonly) for file backups;
2) Domain - Node - File Space - Destination - Management Class - Copy Group
Parameters (verexists, verdeleted,retextra, reatonly) for directories (to
control DIRMC);
3) Domain - Node - File Space - Destination - Management Class - Retain
Versions for file archives;
4) Domain - Node - File Space - Destination - Management Class - Retain
Versions for directory archives (to control DIRMC).
Shell scripts are quite good:
1) produce exact information about used MC, polls and copy group parameters for
all nodes;
2) running for acceptable time;
3) running without total overloading TSM Server.
Scripts provide information like this:
--------------------------------------------------------------------------------------
| AIX | Node1 | FS1 | SP1 | MC1 | NOLIMIT | NOLIMIT | 31 | 31 |
| | | FS2 | SP1 | MC1 | NOLIMIT | NOLIMIT | 31 | 31
|
| | | FS3 | SP1 | MC2 | NOLIMIT | NOLIMIT | 15 | 15
|
| | | FS3 | SP1 | MC3 | NOLIMIT | NOLIMIT | 62 | 62
|
|------+---------+-----+-----+-------+-------------+-------------+-------+-------|
| NT | Node2 | FS4 | SP2 | MC4 | NOLIMIT | NOLIMIT | 8 | 8 |
.............................
Scripts were developed under AIX, but I think they can be used under any UNIX
with small modifications (see support for commands "tr" and "od" only).
I can provide scripts to anybody, who is interesting in this kind of reports,
by direct E-mail.
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
Dwight Cook
Sent: Wednesday, March 03, 2010 12:23 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] How to find what management class is used per node
Try these:
select distinct node_name as "Node Name ",filespace_name as "Filespace
Name ",class_name as "Management Class Name" from backups
where TYPE='FILE' group by node_name,filespace_name,class_name
Node Name Filespace Name Management
Class Name
------------------ ----------------------------------
---------------------
TSMCLI01 / DEFAULT
TSMCLI01 /home DEFAULT
TSMCLI01 /opt DEFAULT
TSMCLI01 /tmp DEFAULT
TSMCLI01 /tsm DEFAULT
TSMCLI01 /usr DEFAULT
TSMCLI01 /var DEFAULT
TSMCLI01 /wn001 DEFAULT
and the same for the archives table
you could always use the ~where node_name='HMPG1018'~ to limit the output to
just that node
select distinct node_name,filespace_name,class_name from backups group by
node_name,filespace_name,class_name
will show you everything, including directory information...
NODE_NAME FILESPACE_NAME CLASS_NAME
------------------ ------------------ ------------------
TSMCLI01 / B7.3_R35.95_A370_-
DIRMC
TSMCLI01 / DEFAULT
TSMCLI01 /home B7.3_R35.95_A370_-
DIRMC
TSMCLI01 /home DEFAULT
<...>
TSMCLI01 /wn001 B7.3_R35.95_A370_-
DIRMC
TSMCLI01 /wn001 DEFAULT
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] How to find what management class is used per node
Hi,
I was just wondering if anyone knows a script that I can run to find out
what management class is utilized by node hmpg1018? Would I need to run:
select * from backups where node_name='HMPG1018'?
Thanks in advance for any help!!!!
Joni Moyer
Storage Administrator III
(717)302-9966
joni.moyer AT highmark DOT com
________________________________
This e-mail and any attachments to it are confidential and are intended
solely for use of the individual or entity to whom they are addressed. If
you have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
keep, use, disclose, copy or distribute this e-mail without the author's
prior permission. The views expressed in this e-mail message do not
necessarily represent the views of Highmark Inc., its subsidiaries, or
affiliates.
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."
|