Re: full silo and ejecting tapes
2002-09-13 15:19:35
Select volume_name from volumes where last_write_date >current_timestamp-10
days and last_read_date >current_timestamp-10 days and status='FULL' and
volume_name in (select volume_name from libvolumes)
Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180
-----Original Message-----
From: Mark Stapleton [mailto:stapleto AT BERBEE DOT COM]
Sent: Friday, September 13, 2002 1:28 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: full silo and ejecting tapes
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Joseph Dawes
> Anyone know how to script a sql to eject full volumes from a silo that
> haven't been accessed in 10 days?
How about
select new_library,vendor,cost from desperation ;o)
Sorry. Being silly.
--
Mark Stapleton (stapleton AT berbee DOT com)
Certified TSM consultant
Certified AIX system engineer
MCSE
|
|
|