Use the b-trees: add node name and filespace name.
select * from columns where tabname='BACKUPS' shuold show you
(index_keyseq) where the b-trees are; use as many as you can but
always the first one.

Hope this helps.
------
Mr. Lindsay Morris
Principal
www.tsmworks.com
919-403-8260
lindsay AT tsmworks DOT com




On May 15, 2009, at May 15, 2:43 PM, Huebschman, George J. wrote:

I think the answer to this question is, "No" , but I am going to ask
anyway.

I want to make a listing of the management classes used by each
client.

I have been asked to provide a list of applications that use longer
than
our standard retention policy. TSM will not identify applications for
me, but I can look up Client/server names.

I know how to write an sql query against the backups table.  I have
queried particular node_names to see what management classes they use.
Thanks to instruction from W, I realize that the backups table is
huge.
I tried to make a more efficient query by restricting the query to
Active objects of type File and running it on the TSM server with the
smallest DB, but it was still running when I came back from lunch.
        select distinct node_name, class_name from backups where
type='FILE' AND STATE='ACTIVE_VERSION'

Is there a smarter way to find this information out?  The owners of
these clients for the most part would have no idea and would be no
help.

Thanks,
George Huebschman

"Let me get this straight.  You won't let us delete this node because
there is no one left who remembers what the machine used to do?"

IMPORTANT:  E-mail sent through the Internet is not secure. Legg
Mason therefore recommends that you do not send any confidential or
sensitive information to us via electronic mail, including social
security numbers, account numbers, or personal identification
numbers. Delivery, and or timely delivery of Internet mail is not
guaranteed. Legg Mason therefore recommends that you do not send
time sensitive
or action-oriented messages to us via electronic mail.

This message is intended for the addressee only and may contain
privileged or confidential information. Unless you are the intended
recipient, you may not use, copy or disclose to anyone any
information contained in this message. If you have received this
message in error, please notify the author by replying to this
message and then kindly delete the message. Thank you.