IT48337: DATA PROTECTION FOR VMWARE VCENTER PLUGIN MONITOR -SCHEDULE TAB MAY NOT SHOW ALL SCHEDULES HISTORY

APAR status

• Closed as program error.

Error description

• Data Protect for VMware users can use Vcenter plugin to monitor
  VMware schedules.  However, under certain condition, this
  monitor schedules table may miss some schedule histories
  .
  
  Customer /Support diagnostics:
  
  
  When users click vCenter  monitor-schedule tab, the following
  select will be logged in actlog:
  
  
  ANR2017I Administrator VESVRMC issued command: SELECT
   'TSMPROD1' as "serverAddr", row_number() over()
  "id",s.SCHEDULE_NAME as "scheduleName", s.EXAMINED,
    s.AFFECTED as "numSucceedVMs", s.FAILED as"numFailedVMs",
  s.COMPLETION_CODE as "completeCode",s.SUCCESSFUL as
  "successful", s.ENTITY as "nodeName",  timestampdiff (2,
  char(s.END_TIME - s.START_TIME)) as"duration", s.START_TIME as
  "actualStart", s.START_TIMEas "actualStartTsm", s.END_TIME as
  "endTime",t.scheduled_start as "scheduledStart", t.options as
  "schedGroup" from summary_extended s left outer join (SELECT
  e.*, cs.OPTIONS FROM events e left outer join  client_schedules
  cs on e.schedule_name = cs.schedule_name and e.DOMAIN_NAME =
  cs.DOMAIN_NAMEwhere e.STATUS<>'Future' and cs.ACTION='BACKUP'
  and   cs.SUBACTION='VM') t on s.SCHEDULE_NAME = t.SCHEDULE_NAME
  and s.ENTITY = t.NODE_NAME and   s.START_TIME >= t.ACTUAL_START
  and s.END_TIME <=
  t.COMPLETED where TRIM(s.SCHEDULE_NAME) <> '' and s.AS_ENTITY in
  ('VE_SVRMC') and s.START_TIME>=('2025-04-21 07:45:04') and
  s.SUB_ENTITY IS NOT NULL and s.ACTIVITY_TYPE = 'Data mover
  backup' order by s.SCHEDULE_NAME, t.ACTUAL_START (SESSION:xxxxx)
  
  
  
  -The condition we used to extract the schedule : s.START_TIME
  >= t.ACTUAL_START ,  while in normal condition the start_time
  will always >=actual_start. But under some condition, for
  example operating system clock drift etc.  the start_time can be
  less than the actual_start , when this happens, the schedule
  will be missing from the plugin schedule monitor.
  
  
  
  
  Platform Version affected
  
  
  Storage Protect for VMware plugin on all supported platforms
  

Local fix

• Use Storage Protect server command to verify the schedule
  status or manually run the select with modified condition. for
  example; START_TIME-t.ACTUAL_START))>=-10
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *  IBM Storage Protect for Virtual Environments: Data          *
  * Protection for VMware version 8.1.19                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Storage Protect for   *
  * Virtual Environments: Data Protection for VMware levels      *
  * 8.2.1. Note that this is subject to change at the discretion *
  * of IBM.                                                      *
  ****************************************************************
  

Problem conclusion

• The IBM Storage Protect Data Protect for VMware plugin is fixed
  to display all backup servers' schedule history records.
  

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 FOR VE DP V

• Fixed component ID

  5725TVEVM

Applicable component levels