Re: List of archives

2007-01-08 Thread Bill Carlson
On Thu, Jan 04, 2007 at 11:28:15AM -0700, Andrew Raibeck wrote: > However, under the covers, the client/server interactions are optimized to > display the description info fairly quickly. What's the proper way to get just the archive description from dsmc? Not the GUI... Thanks, -- Bill Carlson

Re: List of archives

2007-01-04 Thread Alexander Verkooijen
> -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Andrew Raibeck > Sent: Thursday, January 04, 2007 5:40 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: List of archives > > Given this SELECT statement: > > >

Re: List of archives

2007-01-04 Thread Andrew Raibeck
No, the client does not store archive info locally. The table data shown by SELECT statements do not come directly from the internal structures. The table data are virtual, constructed "on the fly" when you run SELECT. Due to the nature of how SELECT works, we will not claim that it is a high-spee

Re: List of archives

2007-01-04 Thread Geert De Pecker
Hi, Thanks for the replies. Just tested and it takes approx 20 minutes for the SQL to complete (approx 5.2 million files). Workable, but I do not understand why the client just lists the archives directly. Maybe the archive info is also stored on the client side which makes is fast. Kind regards

Re: List of archives

2007-01-04 Thread Richard Sims
On Jan 4, 2007, at 11:30 AM, Alexander Verkooijen wrote: 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. ... Listing all Archives (o

Re: List of archives

2007-01-04 Thread Andrew Raibeck
> > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > > On Behalf Of Geert De Pecker > > Sent: Thursday, January 04, 2007 4:27 PM > > To: ADSM-L@VM.MARIST.EDU > > Subject: List of archives > > > > Hi, > > > > I was wondering if there exists

Re: List of archives

2007-01-04 Thread Alexander Verkooijen
al Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > On Behalf Of Geert De Pecker > Sent: Thursday, January 04, 2007 4:27 PM > To: ADSM-L@VM.MARIST.EDU > Subject: List of archives > > Hi, > > I was wondering if there exists a tsm command to get

List of archives

2007-01-04 Thread Geert De Pecker
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 t