Hi,

Something like this should provide a list of all archives:

select node_name,description from archives group by
node_name,description

But like you said it will probably take a very long
time to complete. Or bring down your server. (I've
seen that happen with heavy sql queries in TSM).
It seems that the client has a far more efficient
way of querying the server than the sql interface has.

You might consider to leave out the 'group by' clause
and redirect the output to a text file. Then import
this file into a database like Oracle or DB2 and do
your query there.
The text file can get pretty big though (depending
on how many files have been archived).

Regards,

Alexander

------------------------------------------------------------
Alexander Verkooijen
Senior Systems Programmer
High Performance Computing
SARA Computing & Networking Services
 

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of Geert De Pecker
> Sent: Thursday, January 04, 2007 4:27 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: List of archives
> 
> Hi,
> 
> I was wondering if there exists a tsm command to get a list of all
> existing archives by description, node, ...
> 
> Intention is to get a list of all the archives that have been 
> taken. Not
> to get the full file list. If found some SQL examples,
> but they take incredibly long to process. When, from the 
> client GUI, one
> asks the existing archives (via "Delete Archives"),
> the list pops up immediately. Can we get the list from the server?
> 
> Thanks,
> 
> Geert
>