IT38020: SQL AND EXCHANGE BACKUPS HANG WHEN ATTEMPTING TO CONNECT TO THE APPLICATION SERVER.

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus database backups can completely hang
  and stop outputting messages in the Job Log.
  There is no error or warning as seen in the following example of
  SQL backup job log :
  
  SUMMARY,<timestamp>,CTGGA2398,Starting job for policy <SLAName>
  (ID:<SLAId>). id -> <JobId>. IBM Spectrum Protect Plus version
  10.1.7-3102.
  ...   INFO,<timestamp>,CTGGA3149,[<DBServerHost>] [26/06/2021
  19:28:44PM GMT-0700] Starting backup command.
  ...
  DETAIL,<timestamp>,2,CTGGA1987,[<DBServerHost>] Unmapping lun on
  volume spp_1024_2128_178861A9D12 from host for
  initiator:iqn.1991-05.com.microsoft:<DBServerHost>
  DETAIL,<timestamp>,2,CTGGA1979,Rescanning storage on application
  server <DBServerHost>
  DETAIL,<timestamp>,2,CTGGA2245,SPP log dir: /data/log/guestdepl
  oyer/2021-06-26/1624759200136/1624774413975/<DBServerHost>
  INFO,<timestamp>,2,CTGGA3149,[<DBServerHost>] [26/06/2021
  23:13:44PM GMT-0700] Starting rescan command.
  INFO,<timestamp>,2,CTGGA3150,[<DBServerHost>] [26/06/2021
  23:13:44PM GMT-0700] Ending rescan command.
  ...
  ==> Job is hanging with the last message in the job log below. :
  
  INFO,<timestamp>,2,CTGGA3150,[<DBServerHost>] [26/06/2021
  23:13:44PM GMT-0700] Ending rescan command.
  
  This will happen when a winrm request from the SPP server to a
  SQL and Exchange server is hanging.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.*                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see ERROR Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed IBM Spectrum Protect Plus level        *
  * 10.1.9. Note that this is subject to change at the           *
  * discretion of IBM.                                           *
  ****************************************************************
  

Problem conclusion

• Added time out for the rescan command so that backup job will
  not wait indefinitely if the rescan is hanging.
  

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:

Modules/Macros

• Apps     SQL
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels