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/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
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" <ADSM-L AT VM.MARIST DOT EDU> 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: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
> >
|
