IT09401: STORAGE SUBSYSTEM DELETION MAY CAUSE FULL DB2 TRANSACTION LOG ERROR.

Tivoli Storage Productivity Center 5.2.7 (select fixes from group)
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)

APAR status

• Closed as program error.

Error description

• When attempting to delete a storage subsystem from  TPC
  with large amounts of performance data , (i.e. Table
  T_RES_CHUNK),
  The operation may fail and db2 transaction errors can be
  seen in the logs :
  
  TPC Web GUI Errors:
  
  BPCUI0203E
  The selected resources were not removed
  
  HWN021503E
  A device server operation cannot be completed.
  Check the logs files and try again.
  
  db2diag.log
  i.e.
  
  2015-06-09-16.58.45.134000-300 E1132464111F610 LEVEL: Error
  PID : 5480 TID : 3656 PROC : db2syscs.exe
  INSTANCE: DB2 NODE : 000 DB : TPCDB
  APPHDL : 0-928 APPID: 204.130.33.32.57529.150607205841
  AUTHID : DB2ADMIN HOSTNAME: <hostname>
  EDUID : 3656 EDUNAME: db2agent (TPCDB) 0
  FUNCTION: DB2 UDB, data protection services, sqlpgResSpace,
  probe:6666
  MESSAGE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
  "Log File has reached its saturation point"
  DIA8309C Log file was full.
  
  2015-06-09-16.58.45.134000-300 E137589F1065         LEVEL:
  Warning
  PID     : 7448                 TID : 11896          PROC :
  db2syscs.exe
  INSTANCE: DB2                  NODE : 000           DB   : TPCDB
  APPHDL  : 0-60                 APPID:
  204.130.33.32.59360.150609202000
  AUTHID  : DB2ADMIN             HOSTNAME: <hostname>
  EDUID   : 11896                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-76", and is associated
  with the
  workload name   "SYSDEFAULTUSERWORKLOAD" and application ID
    "204.130.33.32.59360.150609202000"  at member "0". The
  total number  to hold is "4429472". The current statement being
  executed is "delete  from T_RES_CHUNK where LOGICAL_DISK_ID in
  (select SVID
  from  T_RES_STORAGE_VOLUME where SUBSYSTEM_ID = ?)". Reason
  code: "1"
  
  RECREATE STEPS:
  Attempt to delete storage subsystem (array) from TPC Web Gui.,
  

Local fix

• Contact Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.2.x users monitoring storage systems and doing         *
  * deletions                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available.                        *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is targeted for the following maintenance
  package:
  
  | refresh pack | 5.2-TIV-TPC-RP0007 - target August 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

• DISK
  

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels