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.