q content help

Alexxx

ADSM.ORG Member
Joined
Aug 17, 2010
Messages
11
Reaction score
0
Points
0
PREDATAR Control23

Hi all

i have TSM 6.3 running on Windows machine, I have some object IDs that I need to verify if they are damaged, I do not know what volumes the files are in (i can find it and run audit vol against that volume but it would be too time consuming as I have over 100 object Ids to verify ), I ran a simple query select * from content where file_name like %filename% but it runs for ever, the only requirement is to findout whether the list of object IDs that I have is corrupted or not, please let me know if there is any easier/quicker way to get this done.

any help would be greatly appreciated

Thanks heaps in advance.
 
PREDATAR Control23

Thanks Trident, I should have mentioned in my post, I already tried show damaged <stgpool name>, when I ran this I had lot more than (around 1000) the list i have..... is there any way to get timestamp (damaged date) of the damaged file as well?
 
PREDATAR Control23

Hi,

Neither backups nor contents table as a date entry that you are looking for.

Why not just restore stg and leave it at that?

Otherwise, a macro with audit vol name wait=yes may help.

But, finding a date may be a long running task of going through the actlog in search of filename.
 
PREDATAR Control23

I have some object IDs that I need to verify if they are damaged
Do you have the object ID? If so, just query the content table to find the volume
select volume_name from contents where object_id=123456
replace 123456 with the object ID

You could also try:
select distinct volume_name from contents where damaged='Yes'
 
Top