IT43056: ACTIVITY LOG PRUNING CAN RUN SLOWLY

8.1.18.000-IBM-SPSRV-WindowsX64
8.1.18.000-IBM-SPSRV-Linuxx86_64
8.1.18.000-IBM-SPSRV-Linuxs390x
8.1.18.000-IBM-SPSRV-Linuxppc64le
8.1.18.000-IBM-SPSRV-AIX

APAR status

• Closed as program error.

Error description

• Activity log pruning can be seen to run slowly.
  
  Symptoms would include
  
  - The fact that the server issues
  
   ANR2102I Activity log pruning started: removing entries
  
  but never seems to issue corresponding
  
   ANR2103I Activity log pruning completed: number of records
  xxxxx removed.
  
  - SHOW THREADS shows AdmLogDeletionThread running for long
  periods of time or never terminating at
  
  all.
  
  
  - QUERY STATUS shows "Activity Log Number of Records" is
  high, and doesn't seem to decrease, or decreases
  
  very slowly.
  
  Also the instrumentation for AdmLogDeletionThread highlights
  further symptoms.
  
  For example:
  
  Thread 49 AdmLogDeletionThread parent=47
  2022-11-16T13:12:32.312-->2022-11-16T13:34:07.336
  Operation       Count  Tottime  Avgtime  Mintime  Maxtime
  InstTput  Total KB
  ---------------------------------------------------------------
  -------------
  DB2 Fetch Prep      4    0.008    0,002    0.000    0.006
  DB2 Fetch Exec      4    0.000    0,000    0.000    0.000
  DB2 Delet Exec     16    0.016    0,001    0.000    0.015
  DB2 Updat Exec      2    0.001    0,001    0.000    0.001
  DB2 Fetch           4    0.000    0,000    0.000    0.000
  DB2 Commit          1    0.001    0,002    0.001    0.001
  DB2 Reg Prep        1    0.000    0,000    0.000    0.000
  DB2 Reg Exec        2 1294.993  647,497  304.667  990.325
  DB2 Reg Fetch       1    0.000    0,000    0.000    0.000
  Unknown                  0.000
  ---------------------------------------------------------------
  -------------
  Total                 1295.023
  
  Specifically, the high values of the DB2 Reg Exec row and a low
  value of 16 for the DB2  Delet Exec
  row.
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect server versions 8.1.x on all supported
  platforms
  
  Additional Keywords:
  TS010779824 TSM pruning actlog
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.18. 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