Try running this one (I can't remember if this is long running or not and I
don't have TSM DB available to me right now):
select distinct date (archive_date) as date, node_name, filespace_name,
description from archives
__
John Monahan
Senior Consultant Enterprise Sol
f you do just 1 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:
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 database
