Direct links to fixes
APAR status
Closed as program error.
Error description
Using server version 7.1.3.000 or higher, "select * from dedupstats" can fail with error: "ANR0102E admsql.c(5794): Error 1202 inserting row in table 'DedupStats.SQL' " if there are duplicate entries for node(s) shown by the output of "query dedupstats f=d". Duplicate entries for node(s) can be generated if "generate dedupstats container_pool_name node_name" is run more than once for same container/node within the same second, such as in an admin schedule. Initial Impact: Low Additional Keywords: SP TSM Spectrum Protect select dedupstats
Local fix
Detect duplicate entries from "query dedupstats f=d" and then run for affected nodes: "delete dedupstats container_pool_name node_name". Then rerun the "select * from dedupstats" command. If duplicate entries are generated by an admin schedule, remove the duplicate "generated dedupstats" commands in the schedule.
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.7. Note that this is * * subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms: AIX, Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT15198
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
71W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-05-10
Closed date
2016-08-04
Last modified date
2016-08-04
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
[{"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":"7.1.3"}]
Document Information
Modified date:
13 February 2021