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