Thanks Richard.

Agreed, I scoured the columns in TSM tables for something, but
nothing there.  I'm wondering where we are getting output from the q
content command?

tsm: DSMSERV3>q content bc0154 damaged=yes

Node Name    Type   Filespace   FSID    Client's Name for File Name
---------------        ----      ----------         ----
--------------------------------------
FDB1             Bkup    /backup       35     /rman/p817/
2006-03-18_020001_level0_0uhe7vlq_1_1

Thanks again for your response.

Regards, John

At 09:32 AM 3/21/2006, you wrote:

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