ADSM-L

Re: pending tapes to scratch

2003-05-21 14:55:45
Subject: Re: pending tapes to scratch
From: "Mire, Nona" <MireN AT LOURDESRMC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 21 May 2003 13:49:51 -0500
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

<Prev in Thread] Current Thread [Next in Thread>