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 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: [EMAIL PROTECTED] 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 ------------------------------------------------------------------------
begin:vcard n:Scherzer;sc tel;fax:4277-9140 tel;work:4277-14053 x-mozilla-html:FALSE url:http://mailbox.univie.ac.at/~sc org:Zentraler Informatikdienst Uni-Wien adr:;;Universitaetsstr.7;A-1010 Wien;Oesterreich;; version:2.1 email;internet:[EMAIL PROTECTED] title:Systems Programmer fn:Horst Scherzer end:vcard
