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