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
