Direct links to fixes
8.1.7.000-IBM-SPSRV-Linuxppc64le
8.1.7.000-IBM-SPCMS-WindowsX64
8.1.7.000-IBM-SPCMS-WindowsI32
8.1.7.000-IBM-SPCMS-Linuxx86_64
8.1.7.000-IBM-SPOC-WindowsX64
8.1.7.000-IBM-SPOC-Linuxx86_64
8.1.7.000-IBM-SPOC-Linuxs390x
8.1.7.000-IBM-SPOC-LinuxPPC64le
8.1.7.000-IBM-SPOC-AIX
8.1.7.000-IBM-SPSRV-WindowsX64
8.1.7.000-IBM-SPSRV-Linuxx86_64
8.1.7.000-IBM-SPSRV-Linuxs390x
8.1.7.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 7 (V8.1.7) Downloads
APAR status
Closed as program error.
Error description
You might be exposed to the symptom described with this APAR if you see consistent growth of the database activelog without the used space getting released. After some time you might see in the ACTLOG the following messages and the activelog is reduced. Then the problem with the activelog growing starts again. ANR0171I dbitxn.c(637): Error detected on 0:34, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08003:-99999 ([IBM][CLI Driver] CLI0106E Connection is closed. SQLSTATE=08003). ANR2183W cddeploy.c(686): Transaction 0:14677587 was aborted. Customer/L2 Diagnostics Run the server monitoring perl script servermon.pl attached to the following technote: Perl script to collect Tivoli Storage Manager V6 and newer server monitoring data http://www-01.ibm.com/support/docview.wss?uid=swg21432937 On the output file db2.txt you will see for example: Appl id holding the oldest transaction = 55360 Then have a look into the show.txt and there you can find the application handle. Tsn=0:14677587, Resurrected=False, InFlight=True, Distributed=False, Persistent=True, Addr 0000020C06EE8518 Start ThreadId=0, Timestamp=26.11.2018 20:20:57, Creator=cddeploy.c(359) <=== see creator here Last known in use by ThreadId=0 Participants=1, summaryVote=ReadOnly EndInFlight False, endThreadId 0, tmidx 0, processBatchCount 0, mustAbort False. Participant DB: voteReceived=False, ackReceived=False DB: Txn 0000020C15149AF8, ReadOnly(NO), connP=0000020C4218BFC8, applHandle=55360, openTbls=1: :<==== see application handle here DB: --> OpenP=0000020C3326DCA8 for table=CD.Client.Packages. DB: --> RegSqlId=0x40000013 SELECT for table=CD.Client.Packages, executed(Yes). If the thread holding the oldest transaction is cddeploy.c you are affected by this APAR. Under the APAR condition it has been reported that you can run in num_log_span errors at client backups and that the archivelogs are not included in the db backups, so the archivelogdirectory is also filling up. IBM Spectrum Protect Server Version Affected: Version 8.1.3 and above on all platforms | MDVREGR 8.1.3-TIV_5698MSV | Initial Impact: Medium Additional Keywords: TSM server Spectrum Protect deploy activelog archivelog num_log_span backup db TS001249358
Local fix
On the Spectrum Protect command line turn off the DEPLOYPKGMGR SET DEPLOYPKGMR OFF
Problem summary
**************************************************************** * USERS AFFECTED: * * All IBM Spectrum Protect server users of Client Deployment * * via the Operations Center. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in levels 8.1.7 and 8.1.8. Note that * * this is subject to change at the discretion of IBM. * ****************************************************************
Problem conclusion
This problem was fixed. Affected platforms for reported release: AIX, Linux, and Windows. Platforms fixed: AIX, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IT27063
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
81W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-04
Closed date
2018-12-10
Last modified date
2018-12-10
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":"81W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
10 December 2018