select statement for Archives

2006-01-06 Thread De Keyser Bart
Hi there, We're trying to get an overview of all the archives we've already taken, sorted on their annotation. When we try the select description from archives statement, we get one line per file within the archive... Since we've got archives with about 30.000 files, our server falls

Re: select statement for Archives

2006-01-06 Thread Richard Sims
On Jan 6, 2006, at 3:10 AM, De Keyser Bart wrote: ... Within the retrieve module of the Backup-Archive Gui, you can view a list of all available archives.. so it should be possible to generate this list with a select, no?? ... Yes, but fishing expeditions are very expensive in the TSM

Re: select statement for Archives

2006-01-06 Thread Prather, Wanda
select without the index. Wanda Prather I/O, I/O, It's all about I/O -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Friday, January 06, 2006 7:56 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: select statement for Archives

Re: select statement for Archives

2006-01-06 Thread John Monahan
@VM.MARIST.EDU Dist Stor cc Manager [EMAIL PROTECTED] Subject .EDU select statement for Archives 01/06/2006 02:10 AM