ADSM-L

help with select from volumes and processes, pls.

2005-05-16 10:47:47
Subject: help with select from volumes and processes, pls.
From: Henrik Wahlstedt <shwl AT STATOIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 16 May 2005 16:44:47 +0200
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.

<Prev in Thread] Current Thread [Next in Thread>
  • help with select from volumes and processes, pls., Henrik Wahlstedt <=