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: [email protected] Please consider the environment before printing this Email -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Dwight Cook Sent: Wednesday, March 03, 2010 12:23 AM To: [email protected] 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:[email protected]] On Behalf Of Moyer, Joni M Sent: Tuesday, March 02, 2010 2:21 PM To: [email protected] 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 [email protected] ________________________________ 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."
