Direct links to fixes
8.1.2.000-IBM-SPSRV-AIX
8.1.2.000-IBM-SPSRV-Linuxppc64le
8.1.2.000-IBM-SPCMS-Linuxx86_64
8.1.2.000-IBM-SPCMS-WindowsI32
8.1.2.000-IBM-SPSRV-Linuxs390x
8.1.2.000-IBM-SPCMS-WindowsX64
8.1.2.000-IBM-SPSRV-Linuxx86_64
8.1.2.000-IBM-SPSRV-WindowsX64
8.1.2.000-IBM-SPOC-AIX
8.1.2.000-IBM-SPOC-LinuxPPC64le
8.1.2.000-IBM-SPOC-Linuxs390x
8.1.2.000-IBM-SPOC-Linuxx86_64
8.1.2.000-IBM-SPOC-WindowsX64
7.1.8.000-TIV-TSMSRV-AIX
7.1.8.000-TIV-TSMSRV-HP-UX
7.1.8.000-TIV-TSMSRV-Linuxppc64
7.1.8.000-TIV-TSMSRV-Linuxs390x
7.1.8.000-TIV-TSMSRV-Linuxx86_64
7.1.8.000-TIV-TSMSRV-SolarisSPARC
7.1.8.000-TIV-TSMSRV-WIN
7.1.8.000-TIV-TSMOC-AIX
7.1.8.000-TIV-TSMOC-Linuxx64
7.1.8.000-TIV-TSMOC-Windows
7.1.8.000-TIV-TSMOC-LinuxPPC64
7.1.8.000-TIV-TSMOC-LinuxPPC64le
7.1.8.000-TIV-TSMOC-LinuxS390
IBM Spectrum Protect Server V8.1 Fix Pack 2 (V8.1.2) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 8 (7.1.8.000) Downloads
APAR status
Closed as program error.
Error description
A hub or spoke server can report in the activity log: ANR1960I Status monitor finished collecting data at xx:xx:xx and will sleep for 5 minutes. ANR0102E monstats.c(3102): Error 1202 inserting row in table "TSMMon.Status" each time the status monitor runs. Server trace (dbconn dbitxn monitor monitor_detail sql ) will show a message like: xx:xx:xx.xxx [x][dbieval.c][690][DbiEvalSQLOutcomeX]:SQLSTATE 23505, SQLCODE -803, SQLMsg=[IBM][CLI Driver][DB2/NT64] SQL0803N At least one value caused by a DELETE statement in the INSERT statement, the UPDATE statement, or the foreign key update is invalid because the primary key, unique constraint, or the unique index specified by "1" prevents the table "TSMDB1.TSMMON_STATUS" from duplicating values In the index key. Tivoli Storage Manager and IBM Spectrum Protect versions affected: Server 7.1.7.x and higher, and 8.1.x and higher on all supported platform Initial Impact: Low Additional Keywords: TSM IBM Spectrum Protect OC hub spoke | MDVREGR 7.1.7.0-TIV_5698MSV |
Local fix
Error message can be ignored, as it has no impact on operations.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Tivoli Storage Manager server and Spectrum Protect * * 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.8 and 8.1.2. 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
IT20584
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
2017-05-14
Closed date
2017-06-19
Last modified date
2017-06-19
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
Document Information
Modified date:
01 September 2023