Hello,

    When i execute the following request for a particular volume (A00043)

select -
         volumes.volume_name as "VOL_NAME",-
         volumes.stgpool_name as "STGPOOL_NAME",-
         volumes.est_capacity_mb as "EST_CPCTY_MB",-
         volumes.pct_utilized as "PCT_UTIL",-
         volumes.status as "STATUS",-
         volumes.pct_reclaim as "PCT_RECL",-
         substr(char(volumes.last_write_date), 1, 16) as "LAST_WRITE",-
         substr(char(volumes.last_read_date), 1, 16) as "LAST_READ",-
         substr(char(volumes.pending_date), 1, 16) as "PENDING",-
         substr(char(volumes.chg_time), 1, 16) as "CHG_TIME" -
from volumes where volume_name = 'A00043'

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?

Jacquelin Bouchard, UQTR