1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Failed Backups at the file level ?

Discussion in 'Scripting' started by Tom777, Aug 2, 2011.

Thread Status:
Not open for further replies.
  1. Tom777

    Tom777 New Member

    Joined:
    Aug 2, 2011
    Messages:
    3
    Likes Received:
    0
    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.  
  3. chad_small

    chad_small Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,205
    Likes Received:
    44
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    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.
     
  4. GregE

    GregE Senior Member

    Joined:
    May 12, 2006
    Messages:
    2,100
    Likes Received:
    31
    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
    
     
  5. Tom777

    Tom777 New Member

    Joined:
    Aug 2, 2011
    Messages:
    3
    Likes Received:
    0
    Thanks Chad for pointing me in the right direction, much thanks for the code Greg. Really glad to have those message numbers. :)
     
Thread Status:
Not open for further replies.

Share This Page