Direct links to fixes
APAR status
Closed as program error.
Error description
Issuing a select statement against the EVENTS table may produce the following error: ANR0102E admsql.c(5794): Error 1202 inserting row in table "EVENTS.SQL". When a select statement is issued against the EVENTS table, the output from the QUERY EVENT command is inserted into the EVENTS.SQL table. If the QUERY EVENT command displays duplicate records it will result in the ANR0102E error seen above. | MDVREGR 7.1.6.0 | IBM Spectrum Protect Versions Affected: 7.1.6.0 server on all platforms Initial Impact: Medium Additional Keywords: TSM
Local fix
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 levels 7.1.7. 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
IT16269
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71L
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-07-22
Closed date
2016-08-08
Last modified date
2016-08-15
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:
15 August 2016