Try running this one (I can't remember if this is long running or not and I
don't have TSM DB available to me right now):

select distinct date (archive_date) as date, node_name, filespace_name,
description from archives


______________________________
John Monahan
Senior Consultant Enterprise Solutions
Computech Resources, Inc.
Office: 952-833-0930 ext 109
Cell: 952-221-6938
http://www.computechresources.com




             De Keyser Bart
             <Bart.DeKeyser@MI
             L.BE>                                                      To
             Sent by: "ADSM:           ADSM-L AT VM.MARIST DOT EDU
             Dist Stor                                                  cc
             Manager"
             <[email protected]                                     Subject
             .EDU>                     select statement for Archives


             01/06/2006 02:10
             AM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>






Hi there,



We're trying to get an overview of all the archives we've already taken,
sorted on their annotation.



When we try the select description from archives statement, we get one
line per file within the archive...

Since we've got archives with about 30.000 files, our server falls on
timeouts and often no returns are given.



Within the retrieve module of the Backup-Archive Gui, you can view a
list of all available archives.. so it should be possible to generate
this list with a select, no??

Does anybody have an idea??



Thanks



This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended
recipient,
please notify the sender immediately by return e-mail,
delete
this
e-mail and destroy any copies. Any dissemination or use of
this
information by a person other than the intended recipient is
unauthorized and may be illegal.