Hello !
What I would like to get is a select like this below, but I would aslo like
to get some information if the listed volumes are in a process or session?
If that is possible, how do I do?
Select cast(volume_name as char(6)) as "Volume",
Cast(substr(stgpool_name,1,16) as char(16)) as "Storage Pool",
cast(pct_utilized as decimal(5,2)) as "% Util", cast(pct_reclaim as
decimal(5,2)) as "% Reclaim", cast(status as char(7)) as "Status",
cast(read_errors as char(5)) as "R_Err", cast(write_errors as char(5)) as
"W_Err", cast(access as char(11)) as "Access " from volumes where
devclass_name='DLTCLASS' and pct_utilized < 3 and status not in
('PENDING','EMPTY') and stgpool_name='9710COLLO' order by 5,3
Volume Storage Pool % Util % Reclaim Status R_Err
W_Err Access
------ ---------------- ------- --------- ------- -----
----- -----------
001674 9710COLLO 0.00 0.00 FILLING 0
0 READONLY
000693 9710COLLO 0.90 0.00 FILLING 0
1 READONLY
PROCESS_NUM: 281
PROCESS: Move Data
START_TIME: 2005-05-16 16:10:58.000000
FILES_PROCESSED: 0
BYTES_PROCESSED: 0
STATUS: Volume 000693 (storage pool 9710COLLO), Target Pool
BACKUPPOOL2, Moved Files: 0, Moved Bytes: 0, Unreadable Files: 0,
Unreadable
Bytes: 0. Current Physical File (bytes): 862,821,567
Current input volume: 001682.
Tia
Henrik
-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.
|