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:[EMAIL PROTECTED] > On Behalf Of Geert De Pecker > Sent: Thursday, January 04, 2007 4:27 PM > To: [email protected] > 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 >
