A fix is available
APAR status
Closed as program error.
Error description
Using the Operations Center, in the "Security Notifications" panel when clicking on one of the notifications, a hyperlink with the message "Cannot retrieve data" appears on the right side and no data is reported. Also the following errors are shown in the server activity log: ANRG0091E The syntax of the following command is not valid: SELECT ANR0162W Supplemental database diagnostic information: -1:22012:-801([IBM][CLI Driver][DB2/AIX64] SQL0801N Division by zero was attempted.SQLSTATE=22012~). ANR0516E SQL processing for statement select avg ( BYTES ) as AVG_BYTES, avg ( DEDUP_PCT ) as AVG_DEDUP_PCT from ( select BYTES , ( (coalesce ( DEDUP_SAVINGS , 0 ) * 1.0 ) /coalesce ( BYTES_PROTECTED , 0 )) *100 as DEDUP_PCT from summary_extended where activity = 'BACKUP' AND ACTIVITY_TYPE = 'SESSION_END' AND ENTITY = 'E-DUMITRACHE' AND START_TIME < ( select max ( START_TIME ) from summary_extended where activity = 'BACKUP' AND ACTIVITY_TYPE = 'SESSION_END' AND ENTITY = 'E-DUMITRACHE' AND INCIDENT_TYPE is not null ) AND START_TIME > (select coalesce ( max ( START_TIME ) , timestamp ( '1970-01-01 00:00:00' ) ) from summary_extended where activity = 'BACKUP' AND ACTIVITY_TYPE = 'SESSION_END' AND ENTITY = 'E-DUMITRACHE' AND INCIDENT_TYPE is not null AND ACKNOWLEDGE = 2 ) ORDER BY START_TIME DESC FETCH FIRST 5 ROWS ONLY ) failed. IBM Spectrum Protect versions affected: Server 8.1.5.000 on supported platforms (note: this feature has been added only from this OC/server version) Initial Impact: Medium Additional Keywords: TSM "Spectrum Protect" ANR0516E ANRG0091E "cannot retrieve data" "security notifications" OC "operations center"
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Spectrum Protect Operations Center users viewing * * security notifications triggered by a backup from a legacy * * storage pool. * **************************************************************** * PROBLEM DESCRIPTION: * * see error description * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
This problem was fixed.
Temporary fix
Comments
APAR Information
APAR number
IT24730
Reported component name
TSM CLIENT
Reported component ID
5698ISMCL
Reported release
81W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-16
Closed date
2018-05-14
Last modified date
2018-05-14
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
R81A PSY
UP
R81L PSY
UP
R81W PSY
UP
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81W"}]
Document Information
Modified date:
27 September 2021