IT43283: OPERATIONS CENTER DAILY REPORT SHOWS 100% FAILURE RATE

APAR status

• Closed as program error.

Error description

• Daily report from IBM Spectrum Protect Operations Center is
  reporting innacurate information for IBM Spectrum Protect Data
  Protection for Microsoft SQL nodes. Daily Report always shows
  100% Failure Rate on Client Backup Success Rate section, despite
  daily scheduled backups complete with success and no errors.
  

Local fix

• Run the select below through the Operations Center > Reports >
  SQL Builder to get the correct Client Backup Success Rate for
  IBM Data Protetion for Microsoft  SQL nodes :
  select round(cast(total_failed as float)/total*100.0, 1)
  pct_failed,round(cast(total_success as float)/total*100.0, 1)
  pct_success, total, total_failed, total_success FROM ( select
  count(name) as total, sum(case when SUCCESSFUL='NO' then 1 else
  0 END) total_failed, sum( case when SUCCESSFUL<>'NO' then 1 else
  0 END) total_success FROM ( SELECT t.NAME, s.END_TIME,
  s.SUCCESSFUL from summary s inner join tsmgui_allcli_grid t on
  ENTITY=NAME WHERE (activity='BACKUP' or activity='ARCHIVE') and
  s.END_TIME>=(current_timestamp - 24 hours) and TYPE=1 UNION ALL
  SELECT t.NAME, s.END_TIME, s.SUCCESSFUL from summary_extended s
  inner join tsmgui_allcli_grid t on ENTITY=NAME WHERE
  activity='BACKUP' and activity_type='SESSION_END' and
  s.ACTIVITY_DETAILS='SESSION_LIST: ' || s.NUMBER and
  s.END_TIME>=(current_timestamp - 24 hours) and TYPE=0 UNION ALL
  SELECT t.NAME, e.END_TIME, SUCCESSFUL from summary_extended e
  inner join tsmgui_allcli_grid t on e. SUB_ENTITY=t.NAME WHERE
  e.activity='BACKUP' and e.END_TIME>=(current_timestamp - 24
  hours) and (e. ACTIVITY_TYPE='Full' or e.ACTIVITY_TYPE like
  'Incremental%%') AND e.SUB_ENTITY is not null UNION ALL SELECT
  t.NAME, ev.SCHEDULED_START as END_TIME , 'NO' as SUCCESSFUL from
  events ev inner join tsmgui_allcli_grid t on ev.NODE_NAME=t.name
  where ev.SCHEDULED_START>=(current_timestamp - 24 hours ) and
  ev.STATUS='Missed' )) where TOTAL > 0
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect Operations Center server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.19. Note that this is     *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release: AIX, Linux, and
  Windows.
  Platforms fixed: AIX, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM OPERATIONS

• Fixed component ID

  5608E01UI

Applicable component levels