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

    Lightbulb Select to find which backup stg pool admin sched failed and error for failure

    Select to find why backup storage pool failed and the error for failure

    Hello,

    Does anyone know a select statement that will tell us which backup storage admin schedule has failed for the last 10 days and the errror for the failures I used this select statement but it does not provide the anr error for failure. Does anyone know what are we missing?

    select date(start_time) as "Start Date",time(start_time) as "Start Time",date(end_time) as "End Date",time(end_time) as "End Time",number as "Process #",activity,schedule_name,entity,bytes,successf ul from summary where schedule_name='ADMIN_SCHED_NAME'

    Thanks

  2. #2
    Member cfhoffmann's Avatar
    Join Date
    Jun 2005
    Location
    Sydney, Australia
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    If you fix the typo in 'successful' it will run, but since there are no ANR errors listed in the summary table it will never give you the result you want.
    Try running a query on the ACTLOG table instead and check the MESSAGE field.
    Chris

  3. #3
    Newcomer
    Join Date
    Jan 2011
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Yes, but will like to know specific select statement to generate the list of errors for failures on the backup stg pool.

    Thanks for the hint

Similar Threads

  1. Failure of backup stg from primary to copy
    By evaughn in forum TSM Server
    Replies: 7
    Last Post: 10-02-2009, 04:42 PM
  2. daily Backup STG Pool Error
    By elw00d0x in forum Backup / Archive Discussion
    Replies: 4
    Last Post: 09-25-2008, 06:05 PM
  3. ANR9999D error when backing up stg pool. Help!
    By itdrew in forum Tape / Media Library
    Replies: 2
    Last Post: 06-19-2007, 10:07 AM
  4. Replies: 9
    Last Post: 04-12-2007, 02:53 PM
  5. Replies: 1
    Last Post: 01-15-2005, 03:50 PM

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
  •