A fix is available
APAR status
Closed as program error.
Error description
Following an upgrade to 7.1.3 or above the automatic pruning of the activity log and summary table may not take place. The pruning should take place at around midnight - There are no messages ANR2102I/ANR2103I within the activity log. Altering the summaryretention or actlogretention does not prevent this problem. Customer/L2 Diagnostics: The problem is caused by the presence of the date '1956-09-05-00.00.00.000000' in the summary table. In this case this was for a 'TAPE MOUNT' This problem was introduced in server version 7.1.3.000 with the fix for APAR IT03981 which added checks to see if there were records in the activity summary log that were old enough to be pruned, but it did not take into account the possibility that some of the records might be logged with the'1956-09-05-00.00.00.000000' date. You can check if these dates exist using the following command:- db2 "select start_time from tsmdb1.activity_summary order by start_time fetch first row only" START_TIME -------------------------- 1956-09-05-00.00.00.000000 IBM Spectrum Protect Versions Affected: Server 7.1.3 and above on all supported platforms | MDVREGR 7.1.3.0-TIV_5698MSV | Initial Impact: Low Additional Keywords: TSM Tivoli Storage Manager IT03981
Local fix
Delete the entries from the summary table:- db2 connect to tsmdb1 db2 "delete from tsmdb1.activity_summary where start_time='1956-09-05-00.00.00.000000'" db2 terminate
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager server users. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in level 7.1.8. Note that this is * * subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms: AIX, HP-UX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT17294
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-09-30
Closed date
2016-10-18
Last modified date
2016-10-18
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
TSM SERVER
Fixed component ID
5698ISMSV
Applicable component levels
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.3","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
18 October 2016