Re: Management class usage

Maybe I'll try:

select class_name, node_name from backups group by class_name, node_name

since that will give me the information I need. I know it's going to take
forever to run, though.

Cheers,
Paul Ripke




                    Zlatko
                    Krastev              To:     ADSM-L AT VM.MARIST DOT EDU
                    <acit@ATTGLOB        cc:
                    AL.NET>              Subject:     Re: Management class usage
                    Sent by:
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    26/11/2002
                    06:48
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"






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