[ADSM-L] How to match nodes and used management classes/copy groups?

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.Solonovitch AT bkme 
DOT com<mailto:G.Solonovitch AT bkme DOT 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."