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 number
IT36034
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A16
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-02-25
Closed date
2021-03-22
Last modified date
2021-03-22
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A16","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
31 January 2024