Failed Backups at the file level ?

[Tom777]

Hi There,

Is it possible to create a query to list backup failures at the file level?

Failure as in, a backup on a file was attemted, but the file was in use, so the backup needed to be retried later.

My team has a query based on the Summary Table, that lists the total count of backup failures at the node level to produce a report with the following columns:

-Node Name,
-Start Date,
-Start Time,
-Min Wait Time,
-Total Failures

Is it possible to use information in other TSM Tables to drill down to the file name level, and record which files had these failures? It looks like the Backups table lists the files that are backed up (LL_NAME - field), is there a way to tie the data there back to failures in Summary or Actlog?

Is there something I am overlooking? I am new to TSM.

Thanks for your time,

-Tom

[chad_small]

File level failure is listed in the actlog so you'd need to go through the actlog to pull the information. ANR4987E is one of the errors to look for.

[GregE]

TSM 5.5

I have this running via TSM op reporting each morning....

select - 
   nodename as "NODENAME",-         
   substr(char(date_time), 1, 16) as "TIMESTAMP",-
   msgno as "MSGNO",-
   message as "MESSAGE"-
from actlog - 
where msgno in (4005,4007,4018,4037,4047,4987,4973) -
and (date_time >= current_timestamp - 1 days) -
order by nodename

[Tom777]

Thanks Chad for pointing me in the right direction, much thanks for the code Greg. Really glad to have those message numbers.