Hi Thomas, The 2 commands give the same result:
ANR2034E QUERY CONTENT: No match found using this criteria. The LTO is a copy in vault of something in a tape storage pool; maybe, it will be necessary to recreate all the copies for vault of this originating tape storage pool. Jacquelin Bouchard, UQTR At 15:28 2008-04-02 -0400, you wrote:
-----Jacquelin Bouchard wrote: ----- > When i execute the following request for a particular volume >(A00043) > > [SQL deleted] > >>this result is printed and everything is OK > >VOL_NAME: A00043 >STGPOOL_NAME: TPCE_BCK_DATA_COPY >EST_CPCTY_MB: 381468.0 >PCT_UTIL: 0.1 >STATUS: FILLING >PCT_RECL: 99.9 >LAST_WRITE: 2007-06-12 09:48 >LAST_READ: 2007-06-11 15:53 >PENDING: >CHG_TIME: 2007-06-12 13:15 > >but when i execute this other request > >select - > * - >from volumeusage - >where volume_name = 'A00043' > >this error message is printed > >ANS8000I Server command: 'select * from volumeusage where >volume_name = 'A00043'' >ANR2034E SELECT: No match found using this criteria. >ANS8001I Return code 11. > >ANS8002I Highest return code was 11. > >That error occurs only for the volume A00043; for all the others >volume in >the library the volume contents is printed as expected. > >What is the problem with A00043? Try 'q content A00043 f=d count=1' and 'q content A00043 f=d count=-1'. I suspect that these commands will show that the contents of the volume consist of the second segment of a very large file that TSM has spanned across two volumes. TSM has a history of handling spanned files poorly.
