David Longo wrote:

The select is:

select volume_name,pending_date,status from volumes where
stgpool_name='BLAH' and status='PENDING'

Use for each tape storage pool you have.  Note: Use uppercase for stgpool Name.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5509
david.longo AT health-first DOT org

MireN AT LOURDESRMC DOT COM 05/21/03 02:06PM >>>

Is there a way to tell how many days a tape has been in the pending state.
I have our system setup for 7 days - but am running low on scratch tapes.  I
have lots of pending and just wanted an idea as to which ones are going to
be back in the next couple of days to know whether I need to start
worrying....

Thanks
Nona Mire

##############################################################
This message is for the named person's use only.  It may
contain confidential, proprietary, or legally privileged
information.  No confidentiality or privilege is waived or
lost by any mistransmission.  If you receive this message
in error, please immediately delete it and all copies of it
from your system, destroy any hard copies of it, and notify
the sender.  You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient.  Health First reserves
the right to monitor all e-mail communications through its
networks.  Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of
a particular entity;  and (2) the sender is authorized by
the entity to give such views or opinions.
##############################################################

Hi,

You know all you "select" happy people crack me up!  You can just use
the regular "q vol" command, i.e.

q vol stg=/stgpool/ stat=pend f=d

and then look and the  "Date Became Pending" field.

I don't know maybe select statements are more fun.

Anyway, just goes to show you there is more than one way to skin a cat.

P.S. Sorry for the "skin the cat" comment since I know this list is
trying to be Politically Correct!

--
Regards,
Mark D. Rodriguez
President MDR Consulting, Inc.

===============================================================================
MDR Consulting
The very best in Technical Training and Consulting.
IBM Advanced Business Partner
SAIR Linux and GNU Authorized Center for Education
IBM Certified Advanced Technical Expert, CATE
AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux
Red Hat Certified Engineer, RHCE
===============================================================================