Alessio Prodon wrote:
>
> Hello !!!
>
> I'm running ADSM 3.1.2.55 on AIX 4.3.3. I would like a tape's list in private
> status, not associate to the stgpool.
>
> I see you example :
>
> adsm> q libv
>
> Library Name Volume Name Status Last Use
> ------------ ----------- ----------------- ---------
> LIB7332 DS0001 Private Data
> LIB7332 DS0003 Private Data
> LIB7332 DS0004 Scratch
> LIB7332 DS0005 Private
>
> I try with select statement :
>
> select * from libvolumes where status='Private' and last_use <> 'Data'
>
> This command doesn't work !!!
>
> Please, let me know how can I solve this problem.
>
> Thank you in advance.
>
> Alessio Prodon
ANS5100I Session established with server BACKUP: AIX-RS/6000
ANS5101I Server command: 'select library_name, volume_name, status,
last_use from libvolumes where upper(status) = 'PRIVATE' and
upper(last_use) != 'DATA''
LIBRARY_NAME VOLUME_NAME STATUS LAST_USE
------------------ ------------------ ---------- ----------
IBM3494 A00557 Private Export
IBM3494 A00557 Private Export
IBM3494 A00598 Private Export
IBM3494 B00100 Private DbBackup
IBM3494 B00101 Private DbBackup
IBM3494 B00102 Private DbBackup
IBM3494 B00103 Private DbBackup
IBM3494 B00104 Private DbBackup
IBM3494 B00105 Private DbBackup
IBM3494 B00106 Private DbBackup
ANS5103I Highest return code was 0.
Hth,
--
------------------------------------------------------------------------
------------------------------------------------------------------------
Horst SCHERZER mailto: Horst.Scherzer AT univie.ac DOT at
Horst SCHERZER mailto: Horst.Scherzer AT univie.ac DOT at
Zentraler Informatikdienst Uni-Wien Fax: (+43 1) 4277 x9140
Universitaetsstr.7 Phone: (+43 1) 4277 x14053
A-1010 Vienna, Austria URL: http://mailbox.univie.ac.at/~sc
------------------------------------------------------------------------
--------------7AF03399547042205F21EA5B
|