> -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Andrew Raibeck > Sent: Thursday, January 04, 2007 5:40 PM > To: [email protected] > Subject: Re: List of archives > > 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
You're absolutely right Andy. I should have thought of that. Kind regards, Alexander > > 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/IBMTivoli > StorageManager.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 > > > >
