IT27063: ACTIVELOGS MAY FILL UP AND ANR0171I, ANR2183W AND ANR0162W MAY BE SEEN IN THE ACTLOG.

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 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