Re: pending tapes to scratch
2003-05-21 14:36:22
>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
|
|
|