Re: pending tapes to scratch
2003-05-21 14:55:45
Thanks to everyone for your suggestions!
-----Original Message-----
From: Richard Sims [SMTP:rbs AT BU DOT EDU]
Sent: Wednesday, May 21, 2003 1:36 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: pending tapes to scratch
>Is there a way to tell how many days a tape has been in the pending
state.
Just to add to the other fine suggestions...
I do a conjunctive lookup from STGPOOLS to also get the Reusedelay
value, just for reference (takes a little longer):
SELECT CHAR(VOLUME_NAME,6) AS "Volume", CHAR(STGPOOL_NAME,26) AS
"Storage Pool ", -
SUBSTR(CHAR(PENDING_DATE),1,19) AS "Pending Date ", -
(SELECT REUSEDELAY FROM STGPOOLS WHERE
STGPOOL_NAME=VOLUMES.STGPOOL_NAME) AS "Reusedelay" -
FROM VOLUMES WHERE STATUS='PENDING'
Richard Sims, BU
|
|
|