I need help with SQL in TSM. I am trying to find the way to match nodes and used management classes/copy groups. I have built next query for single node:
"select b.node_name, a.domain_name, a.class_name as Management_Class, a.destination as Destination_Pool, \ a.verexists as MAX_Versions, a.verdeleted as Max_Deleted, a.retextra as Days_Inactive, a.retonly Days_Last_Deleted \ from bu_copygroups a, backups b \ where a.class_name = b.class_name and a.set_name = 'ACTIVE' and b.node_name = 'FILESRV01' \ group by b.node_name, a.domain_name, a.class_name, a.destination, a.verexists, a.verdeleted, a.retextra, a.retonly" It gives required information: NODE_NAME DOMAIN_NAME MANAGEMENT_CLASS DESTINATION_POOL MAX_VERSIONS MAX_DELETED DAYS_INACTIVE DAYS_LAST_DELETED ------------------ --------------------- ------------------------------ --------------------------- --------------------- -------------------- --------------------- ----------------- FILESRV01 NT FILE WINDOWS NOLIMIT NOLIMIT 62 62 but it takes quite long time. Similar query for all the nodes takes ages: "select b.node_name, a.domain_name, a.class_name as Management_Class, a.destination as Destination_Pool, \ a.verexists as MAX_Versions, a.verdeleted as Max_Deleted, a.retextra as Days_Inactive, a.retonly Days_Last_Deleted \ from bu_copygroups a, backups b \ where a.class_name = b.class_name and a.set_name = 'ACTIVE' and b.node_name in (select node_name from nodes) \ group by b.node_name, a.domain_name, a.class_name, a.destination, a.verexists, a.verdeleted, a.retextra, a.retonly" Is there any other more effective way to match node and used management classes/copy groups? Thank you very much in advance. 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.solonovi...@bkme.com<mailto:g.solonovi...@bkme.com> Please consider the environment before printing this Email 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."