Nona, put the following into a script:

select count (*) as "Total PENDING volumes" from volumes where
status='PENDING'
select count(*) as "Total PENDING for two days" from volumes where
status='PENDING' and cast ((current_timestamp-pending_date)days as
decimal) = 2
select count(*) as "Total PENDING for one day" from volumes where
status='PENDING' and cast ((current_timestamp-pending_date)days as
decimal) = 1
select count(*) as "Total PENDING less than one day" from volumes where
status='PENDING' and cast ((current_timestamp-pending_date)days as
decimal) < 1
select volume_name as "VOLUME_NAME              ", pending_date as
"PENDING_DATE              " from volumes where status='PENDING' order by
pending_date



Joerg Pohlmann
604-535-0452





"Mire, Nona" <MireN AT LOURDESRMC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2003-05-21 11:06
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        pending tapes to scratch



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