Re: Management class usage

Try to improve it a bit by using:
select 'It is there' from db -
where exists (select * from backups where class_name = 'BLAH')

Zlatko Krastev
IT Consultant






Paul Ripke <pripke AT CSC.COM DOT AU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
25.11.2002 06:55
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Management class usage


TSM Gurus,

Just a quick question: is there a fast way of determining if there are any
files bound to a management class?
While doing a "select count(*) from backups where class_name = 'BLAH'" may
work, it's going to take an inordinate period of time to execute.

Cheers,
Paul Ripke
UNIX/OpenVMS Sysadmin
CSC, Port Kembla 2502, NSW, Australia
Phone +61 2 4275 4101
Fax +61 2 4275 7801
Mobile +61 419 432 517
101 reasons why you can't find your Sysadmin:
68. It's 9 AM. He/she is not working that late.
----------------------------------------------------------------------------------------

This email, including any attachments, is intended only for use by the
addressee(s) and may contain confidential and/or personal information and
may also be the subject of legal privilege. Any personal information
contained in this email is not to be used or disclosed for any purpose
other than the purpose for which you have received it. If you are not the
intended recipient, you must not disclose or use the information contained
in it. In this case, please let me know by return email, delete the
message
permanently from your system and destroy any copies.
----------------------------------------------------------------------------------------