Given this SELECT statement: > select node_name,description from archives group by > node_name,description
The following is simpler: select distinct node_name, description from archives Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <[email protected]> wrote on 01/04/2007 09:30:48 AM: > 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 > >
