If you are only occasionally moving old volumes, you could just run a script
that builds the command and manually paste it to the command line.
select volume_name, date(last_write_date) as "Oldest Volume" from volumes
where last_write_date=(select min(last_write_date) from volumes)
select 'MOVE DATA ' as "Run This Command", volume_name from volumes where
last_write_date=(select min(last_write_date) from volumes)
Output:
VOLUME_NAME Oldest Volume
------------------ -------------
WG1012 2008-03-26
Run This Command VOLUME_NAME
---------------- ------------------
MOVE DATA WG1012
Bob
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Bjørn Nachtwey
Sent: Friday, January 09, 2009 2:35 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] Question on automated data move for tapes not accessed
for a certain time: conclusion
dear all,
thanks for your answers, so i think i'll only touch the 3590-tapes used
for archive, because the tapes are 9 years old :-)
David E Ehresman wrote:
> I have a simplistic korn shell script that does this that I could share
> with you if you are interested.
>
> David Ehresman
>
sure, i'll compare it with mine and may improve it.
thanks,
Bjørn
--
########################################################################
Dipl.-Ing. Bjørn Nachtwey
Technische Universität Carolo-Wilhelmina zu Braunschweig
Gauss-IT-Zentrum (GITZ) -- Abteilung Server
Hans-Sommerstraße 56, 38106 Braunschweig
Telephon: +49 (0)531 / 391 - 5535
TeleFax: +49 (0)531 / 391 - 5549
Mobil: +49 (0)163 / 639 4804
http://www.tu-braunschweig.de/it
mailto: b.nacht...@tu-bs.de
mailto: c0034...@tu-bs.de
########################################################################
PGP-Schluessel:
http://www-public.tu-bs.de:8080/~nachtwey/bjoern_nachtwey.asc
PGP-Fingerprint:
B472 526A A903 4AEB 9269 EC0B 9CDE 7465 CE87
########################################################################
This electronic transmission and any documents accompanying this electronic
transmission contain confidential information belonging to the sender. This
information may be legally privileged. The information is intended only for
the use of the individual or entity named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or the taking of any action in reliance on or regarding the contents of this
electronically transmitted information is strictly prohibited.
