You might try this:
select * from libvolumes where status='Private' and last_use is null
I hope this helps,
Rick Saylor
At 09:34 AM 9/27/00 +0200, you 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
--------------------------------------------------------------------------
Rick Saylor Austin Community College Voice: (512)223-7511
Rick Saylor Austin Community College Voice: (512)223-7511
Senior Systems Programmer 5930 Middle Fiskville Rd. Fax: (512)223-7156
Information Services Austin, Texas 78752-4331
|