APAR status
Closed as program error.
Error description
Using IBM Spectrum Protect Plus, when log backups are enabled in a SLA for Microsoft SQL databases, the first backup run will attempt to configure a local SQL Server host schedule to initiate log backups at defined times. That log schedule enabling can fail for databases that already were protected with log backups before with a different SLA. The job log will display the following messages : SUMMARY,<timestamp>,CTGGA2398,Starting job for policy <SLAName> (ID:<SLAId>). id -> <JobId>. IBM Spectrum Protect Plus version 10.1.8-4083. ... DETAIL,<timestamp>,CTGGA1952,Enabling log backup of databases on instance <InstanceName> INFO,<timestamp>,CTGGA3149,[<DBServerHost>] [<timestamp>] Starting enablelogbackup command. ... DETAIL,<timestamp>,CTGGE1000,[<DBServerHost>] Connecting to [\\<vSnapHost>\vpool1_fs123] with username <vSnapUser>. Attempt 1 of 3. DETAIL,<timestamp>,CTGGE1023,[<DBServerHost>] Scheduling log backup task for database [<DBName>]. WARN,<timestamp>,CTGGE1024,[<DBServerHost>] Log backup task already exists for database [<DBName>] in SLA policy [<SLAName>]. ... INFO,<timestamp>,CTGGA3150,[<DBServerHost>] [<timestamp>] Ending enablelogbackup command. WARN,<timestamp>,CTGGA1951,[<DBServerHost>] Enable log backup status was reported as partial: null ERROR,<timestamp>,CTGGA2296,Enable log backup failed for database <DBName>:Log backup exists for the database in SLA policy [<SLAName>] IBM Spectrum Protect Plus Versions Affected: IBM Spectrum Protect Plus 10.1.x Additional Keywords: SPP, SPPLUS, TS005975615
Local fix
Before protecting Microsoft SQL database with log backups with a new SLA, first perform a backup with the original SLA with log backup disabled. That will trigger a removal of the original log backup schedule and prevent a conflict with the new SLA log enabling activity.
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Protect Plus level 10.1.7 and 10.1.8 * **************************************************************** * PROBLEM DESCRIPTION: * * see ERROR Description * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in IBM Spectrum Protect Plus level * * 10.1.8 ifix2 and 10.1.9. Note that this is subject to change * * at the discretion of IBM * ****************************************************************
Problem conclusion
Provided a user option to configure SQL log backup with a new SLA, when the prior SLA is disabled.
Temporary fix
Comments
APAR Information
APAR number
IT37811
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A18
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-07-29
Closed date
2021-08-27
Last modified date
2021-08-27
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A18","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
31 January 2024