Results 1 to 4 of 4
  1. #1
    Newcomer
    Join Date
    Aug 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Failed Backups at the file level ?

    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

  2. #2
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,191
    Thanks
    1
    Thanked 24 Times in 23 Posts

    Default

    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.
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. #3
    Senior Member GregE's Avatar
    Join Date
    May 2006
    Posts
    2,100
    Thanks
    9
    Thanked 17 Times in 16 Posts

    Default

    TSM 5.5

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

    Code:
    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

  4. #4
    Newcomer
    Join Date
    Aug 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

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

Similar Threads

  1. Replies: 32
    Last Post: 03-05-2013, 10:39 AM
  2. Do you need a TSM client within a VM to do file level restore?
    By tsmhelum in forum VMWare / Virtual Machine
    Replies: 2
    Last Post: 05-23-2011, 02:18 PM
  3. VM File-level restore in 6.1?
    By Rukkot in forum Restore / Recovery Discussion
    Replies: 2
    Last Post: 12-17-2010, 06:07 AM
  4. vmware file-level restores
    By tsmhelum in forum VMWare / Virtual Machine
    Replies: 2
    Last Post: 04-12-2010, 01:31 PM
  5. TDP for Mail with brick-level backups
    By TBart in forum TDP/Application Layer Backup
    Replies: 1
    Last Post: 04-14-2004, 11:14 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •