You will probably need the nested form of the query, something like...
select a.volume_name from volumeusage where blah blah blah and -
a.volumn_name in (select b.volume_name from volumes where -
last_write_date>current date - 60 day)
We are requesting an enhancement for "restore/retrieve -preview" option, thru the
SHARE requirements process; so far, no official response from development.
Also, I am working with some folks to capture tape vol list via server trace, for
backup data; don't yet know if this technique would work for archive data.
Finally, I previously worked with a client that did a retrieve like this; as I recall,
tapes outside the silo were marked "unavailable" or "offsite" (don't recall which
one), and the retrieve was run repeatedly (3 or 4 times) until completion. The
"unavailable" state triggered messages in the activity log for skipped volumes -- they
re-ran the retrieve after loading up the missing tapes, all was okay after about three
cycles thru that process. (For restore, classic restore previously would run to
completion, skipping over unavailable/offsite vols, listing the tapes in ActLog; no
query restore dies on the first missing tape --- have not checked this technique on v4
or v5, so a caveat emptor).
Hope some of this helps!
Don France
Technical Architect -- Tivoli Certified Consultant
Tivoli Storage Manager, WinNT/2K, AIX/Unix, OS/390
San Jose, Ca
(408) 257-3037
mailto:[EMAIL PROTECTED] (change aye to a for replies)
Professional Association of Contract Employees
(P.A.C.E. -- www.pacepros.com)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of
Remeta, Mark
Sent: Tuesday, February 11, 2003 9:47 AM
To: [EMAIL PROTECTED]
Subject: Re: Tape question
This works good however I only want the tapes from the last archive I ran
which was the first of January. This query gives me all the volumes from the
beginning of time that have that nodes filespace in it.. clear as mud?
