On Mar 21, 2006, at 11:22 AM, John Bremer wrote:

Greetings,

Does anyone have a way to find damaged files on tape volumes without
querying content of every volume ( for example:  q content xxxxxx
damaged=yes ) ?

John - There being no "Damaged" column value or enumtype in the SQL
       lookups available to us, we might start by looking for volumes
which have read or write errors indicated, as via:

SELECT CHAR(VOLUME_NAME,6) as "VOLNAME", -
STGPOOL_NAME as "       STORAGE POOL        ", -
PCT_UTILIZED as "%UTIL", -
DEC(EST_CAPACITY_MB,6) as "MB WHEN FILLED", -
WRITE_ERRORS as "WRITE ERRORS", SUBSTR(CHAR(LAST_WRITE_DATE),1,19) as
"  LAST WRITE DATE  ",  -
READ_ERRORS as "READ ERRORS", SUBSTR(CHAR(LAST_READ_DATE),1,19) as "
LAST READ DATE   "  -
FROM VOLUMES where WRITE_ERRORS <> 0 or READ_ERRORS <> 0 -
order by "VOLNAME"

  Richard Sims