IT36034: "CTGGA2655 LOG BACKUP SKIPPED ON ALL SERVERS" FOR MICROSOFT SQL DATABASES ON AN AAG

APAR status

• Closed as program error.

Error description

• When IBM Spectrum Protect Plus cannot find Microsoft SQL
  instances on hosts part of an Always-on Availability Group
  (AAG), the job log will report the backup of the database log
  files as skipped for databases active on the affected peer
  hosts.
  
  Having the following example of a 2-node Microsoft SQL servers
  cluster :
  <SQLInstance_1> on host name <HostName_1>
  <SQLInstance_2> on host name <HostName_2>
  and a database <DB_Name> with the active copy on node
  <SQLInstance_2> and part of AAG <AAG_1>.
  
  If for any reason, IBM Spectrum Protect Plus cannot resolve the
  Microsoft SQL Instance that owns the database, the following
  will be seen in the backup job log :
  
  SUMMARY,<timestamp>CTGGA2398,Starting job for policy
                               sql_<SLAName> (ID:<SLA_ID>). id ->
                               <JobID>. IBM Spectrum Protect Plus
                               version 10.1.6-2045.
  ...
     WARN,<timestamp>,CTGGA1995,Server <SQLInstance_2> is part of
                                a AAG/DAG <AAG_1> and is either
                                not reachable or not registered
   DETAIL,<timestamp>,CTGGA2227,Cluster host <SQLInstance_1> is
                                resolved to application server
                                <HostName_1>
   DETAIL,<timestamp>,CTGGA2227,Cluster host <SQLInstance_2> is
                                resolved to application server
                                <HostName_2>
  ...
    ERROR,<timestamp>,CTGGA2092,Failed to find the application
                                instance for database <DB_Name>
  ...
   DETAIL,<timestamp>,CTGGA3145,[<HostName_2>]
           .. vSnap SMB target IP address [<vSnapIPAddress>] is
              used for share connection.
           .. Windows Task Scheduler will be used to setup the
              log backup.
           .. Scheduling backup tasks.
           .. The last log backup time of database [<DB_Name>] is
              [<timestamp> (Romance Standard Time)].
           .. Scheduling log backup task for database [<DB_Name>]
           .. Connecting to [\\<vSnapIPAddress>\vpool<x>_fs<abc>]
              with username vsnapuser. Attempt 1 of 3.
  ...
    ERROR,<timestamp>,CTGGA2655,Log backup skipped on all servers
                                for database <AAG_1>-><DB_Name>.
  ...
   DETAIL,<timestamp>,CTGGA2402,<AAG_1> ==> <DB_Name> (Server:
                                <HostName_2>  Transfer Size:
                                <zz> MB)
  
  If a previous log backup was successful when the database was
  active on another SQL node that could be resolved, the
  subsequent log backups will be successful even if CTGGA2655 is
  still seen.
  This is because the message CTGGA2655 only means IBM Spectrum
  Protect Plus could not get the log backup status from one of
  the SQL cluster nodes because of the resolving problem.
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Initial Impact: Medium
  
  Additional Keywords: SPP, SPPLUS, TS004619335, AAG, DNS,
                       resolution, peer, cluster, replication
  

Local fix

• Register the affected Microsoft SQL hosts with an IP address
  resolvable by the IBM Spectrum Protect Plus host.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus levels 10.1.5, 10.1.6, and 10.1.7. *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fixing level when available. This problem is       *
  * currently projected to be fixed in IBM Spectrum Protect Plus *
  * level 10.1.8. Note that this is subject to change at the     *
  * discretion of IBM.                                           *
  *                                                              *
  ****************************************************************
  

Problem conclusion

• The intermittent enable log backup failure has been fixed by
  reporting all peer node addresses during inventory.
  

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