IT36754: SQL BACKUP COMPLETED PARTIALLY DUE TO FAILED ENABLING LOG BACKUP

APAR status

• Closed as program error.

Error description

• Microsoft SQL server backup job completes partially on IBM
  Spectrum
  Protect Plus. The job log shows :CTGGA2081,Failed to
  enable log backup. 
  An exception was logged in command.log of
  SQL log backup, although the
  root case of connection timeout,
  rather than out of connection pool limit.
  Here is a sample
  exception message:
  
  The timeout period elapsed prior to
  obtaining a connection from
  the pool. This may have occurred
  because all pooled connections
  were in use and max pool size
  was reached.
  
  To confirm it is the timeout issue, SQL
  Management Studio
  can be used to connect to the instance to
  see if it fails also.
  If it fails, extend timeout to a higher
  value, and try again
  to confirm it is related to the
  connection timeout.
  
  IBM Spectrum Protect Plus Versions
  Affected:   10.1.x
  Initial Impact:  Low
  
  Additional Keywords:
  
  TS005316931 SQL backup log backup Connection time-out
  

Local fix

• N/A
  

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.8 *
  * patch1 and 10.1.9. Note that this is subject to change at    *
  * the discretion of IBM.                                       *
  ****************************************************************
  

Problem conclusion

• The problem was caused by a delay in DNS resolution that
  resulted in a connection timeout. The timeout is increased from
  30 seconds to 120 seconds to accommodate this longer delay and
  the log backups will complete successfully if the SQL connection
  can be established in 120 seconds.
  

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

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels