IT08131: REMOVED RESOURCE RETENTION JOB HOLDS LOCK ON DB2 TRANSACTIONS.

Refresh Pack 5.2.6 (June 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.7 (August 2015) for Tivoli Storage Productivity Center
IBM Spectrum Control V5.2.8 (December 2015)
IBM Spectrum Control V5.2.9 (February 2016)
IBM Spectrum Control V5.2.10 (May 2016)
IBM Spectrum Control V5.2.10.1 (July 2016)
IBM Spectrum Control V5.2.11 (August 2016)
IBM Spectrum Control V5.2.12 (November 2016)
IBM Spectrum Control V5.2.13 (March 2017)
IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)
Fix Pack 5.2.7.1 (February 2016) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• DVSThread-80 db2 application, spawned from TPC Removed Resource
  Retention job is unable to complete task resulting in
  Transaction locks, etc.
  
  
  This condition causes Transaction logs to rapidly generated
  resulting in loss of available disk space, as
  task is not able to complete.
  
  i.e.
  db2diag.log
  
  2015-03-20-17.53.28.812000-240 E35862F1125 LEVEL: Warning
  PID : 3532 TID : 10220 PROC : db2syscs.exe
  INSTANCE: DB2 NODE : 000 DB : TPCDB
  APPHDL : 0-20595 APPID: IP_Address.58480.150320215151
  AUTHID : DB2ADMIN HOSTNAME: host_name
  EDUID : 10220 EDUNAME: db2agent (TPCDB) 0
  FUNCTION: DB2 UDB, data management, sqldEscalateLocks, probe:1
  MESSAGE : ADM5501I DB2 is performing lock escalation. The
  affected application
  is named "DVSThread-80", and is associated with the workload
  name
  "SYSDEFAULTUSERWORKLOAD" and application ID
  "IP_Address.58480.150320215151" at member "0". The total number
  of
  locks currently held is "483356", and the target number of locks
  to
  hold is "241678". The current statement being executed is
  "DELETE
  FROM T_PRF_DSVOL WHERE TIME_ID IN
  (2368518,2368546,2368602,2368630,
  2368658,2368686,2368210,2368266,2368238,2368322,2368350,2368378,
  2368406,2368462,2368490)". Reason code: "1"
  
  RECREATE STEPS:  Review db2diag.log for errors similar to the
  above while TPC Device Server Service is running.
  
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   5.2.4
  ________________________________________________________________
  Problem as described by customer:   OS Filesystem losing
  available disk space.
  Initial customer impact (low/med/high): med
  

Local fix

• Engage Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC5.2.x users running Performance Monitors jobs             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Retention job that deletes older performance data is not     *
  * able to complete due to DB2 errors:                          *
  * SQL0964C  The transaction log for the database is full.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available.                        *
  ****************************************************************
  

Problem conclusion

• The issue has been solved by reducing the amount of data purged
  at once.  The fix for this APAR is targeted for the following
  maintenance package:
  
  | refresh pack | 5.2-TIV-TPC-RP0006 - target June 2015
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future refresh packs do not represent a
  formal commitment by IBM. The dates are subject to change
  without notice.
  

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:

Modules/Macros

• DB
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels

• R520 PSY

     UP

• R524 PSY

     UP

• R525 PSY

     UP