Backup Central

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.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.

On 2 mrt 2010, at 21:21, Moyer, Joni M wrote:

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'?


on the node itself run 'dsmc q backup / -ina -subdir=y'

(assuming unix, but you get the drift)

since each file can be bound to a different mgmt class, there is no such concept of a mgmt class used by a node, and the client is the proper place to run this query, not the server.


Thanks in advance for any help!!!!

Joni Moyer
Storage Administrator III
(717)302-9966
joni.moyer < at > highmark.com

--
Met vriendelijke groeten/Kind Regards,

Remco Post
r.post < at > plcs.nl
+31 6 248 21 622

Avoid that if you can.
You probably can. If you can not, someone else will be able to.

* Normally the node uses the default management class for the domain;
then any MC specified by INCLUDE statements.

* Log onto the client and run "q inclexcl". The q inclexcl command
will show you all includes and excludes in the dsm.opt, inclexcl file,
or client option set. Check the listing, looking for includes, then for
mgmt class names next to the includes.

* Also, directories will automatically use the management class with the
longest retention in the domain (unless the client is using a "dirmc"
option.)

You certainly can run a select against the largest of the tables, but it
should be done carefully. Smart folks advise against it. It is a very
intensive query. If there are many objects for this client, try to
limit the query as much as possible by using index keys. Try running
the select against one filespace at a time for example. If you have
many filespaces and that seems to tedious, it is an indicator that you
need to do it!

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'?

George H

IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive
or action-oriented messages to us via electronic mail.

This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.

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.EDU] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L < at > VM.MARIST.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.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.

That is perfect!

Thanks Dwight! That is exactly the output I was looking for!

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of Dwight Cook
Sent: Tuesday, March 02, 2010 4:23 PM
To: ADSM-L < at > VM.MARIST.EDU
Subject: Re: 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.EDU] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L < at > VM.MARIST.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.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.

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.com

Please consider the environment before printing this Email


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of Dwight Cook
Sent: Wednesday, March 03, 2010 12:23 AM
To: ADSM-L < at > VM.MARIST.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.EDU] On Behalf Of
Moyer, Joni M
Sent: Tuesday, March 02, 2010 2:21 PM
To: ADSM-L < at > VM.MARIST.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.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."