APAR status
Closed as program error.
Error description
SQL Log backups do not run after moving the SQL DB from one SLA to another. This occurs because the Windows log protection task is not created as an existing log backup task is detected. agent_sql_log: The last log backup time of database [MYDB] is [2018-12-09 12:52:50]. agent_sql_log: Scheduling log backup task for database [MYDB]. agent_sql_log: Log backup task exists for database [MYDB]. Versions affected: 10.1.X Keywords: TS001690830 SPP ISPP
Local fix
1 - Remove the Windows task for the SQL Log backup 2 - Remove the "settings.json" file from C:\ProgramData\SPP\SqlLogBackup\<policy ID>\<SQL instance name>\<SQL database name>
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Protect Plus level 10.1.1, 10.1.2 and 10.1.3 * **************************************************************** * 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.4. Note that this is subject to change at the * * discretion of IBM * ****************************************************************
Problem conclusion
The problem will be fixed by using the same log backup task by all the SLAs for a particular database.
Temporary fix
1 - Remove the Windows task for the SQL Log backup 2 - Remove the "settings.json" file from C:\ProgramData\SPP\SqlLogBackup\<policy ID>\<SQL instance name>\<SQL database name>
Comments
APAR Information
APAR number
IT27854
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-23
Closed date
2019-04-10
Last modified date
2019-04-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
winagent
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":"A12","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
30 January 2024