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