IT26925: DB2 TRANSACTION LOG FULL ERRORS OCCUR DUE TO DS8L NIVOLUMECREATEDEVENT WITH POOL -1

APAR status

• Closed as program error.

Error description

• DB2 transaction log full errors occur due to DS8L
  NIVolumeCreatedEvent with pool -1
  
  db2diag.log
  RETCODE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE
            "Log File has reached its saturation point"
            DIA8309C Log file was full.
  
  
  The essni miniprobe fails because the pool_id value of -1 was
  not properly handled.
  com.ibm.tpc.ep.base.EPHdlrRunException:
  com.ibm.tpc.ep.base.EPHdlrRunException: ESSNI API returned no
  NIExtentPool instances for ESS for extent pool number -1
          at
  com.ibm.tpc.ep.ds.task.EP_DS_Task_Helper.retrieveRequestedExtent
  Pool(EP_DS_Task_Helper.java:220)
          at
  com.ibm.tpc.ep.ds.EP_DS_CLI_MiniProbe.buildEPLSSMiniProbe(EP_DS_
  CLI_MiniProbe.java:182)
          at
  com.ibm.tpc.ep.ds.EP_DS_CLI_MiniProbe.buildEPMiniProbe(EP_DS_CLI
  _MiniProbe.java:151)
          at
  com.ibm.tpc.ep.ds.EP_DS_CLI_MiniProbe.run(EP_DS_CLI_MiniProbe.ja
  va:113)
          at
  com.ibm.tpc.ep.base.EPLauncher$SubJobThread.run(EPLauncher.java:
  176)
  Caused by: com.ibm.tpc.ep.base.EPHdlrRunException: ESSNI API
  returned no NIExtentPool instances for ESS for extent pool
  number -1
          at
  com.ibm.tpc.ep.ds.task.EP_DS_Task_Helper.retrieveRequestedExtent
  Pool(EP_DS_Task_Helper.java:215)
          ... 4 more
  
  The failed miniprobe results in DSVolumeCreateEventHandler
  problems while creating DS8K volumes.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Control users monitoring DS8000 storage         *
  * subsystems                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A failed miniprobe of a DS8000 device may result in          *
  * DSVolumeCreateEventHandler problems while creating           *
  * DS8K volumes.                                                *
  *                                                              *
  * Subsequent DB2 transaction log full errors occur due to      *
  * DS8LNIVolumeCreatedEvent with pool -1                        *
  *                                                              *
  * For example:                                                 *
  * db2diag.log                                                  *
  * RETCODE : ZRC=0x85100009=-2062548983=SQLP_NOSPACE            *
  *           "Log File has reached its saturation point"        *
  *           DIA8309C Log file was full.                        *
  *                                                              *
  *                                                              *
  * The ESSNI miniprobe fails because the pool_id value of -1    *
  * was                                                          *
  * not properly handled.                                        *
  * This has been fixed.                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available                         *
  ****************************************************************
  Prevent deleting and recreating volume tables during DS8K event
  post processing.
  

Problem conclusion

• The fix for this APAR is targeted for the following release:
  
  IBM Spectrum Control 5.3.2  |  5.3.2-IBM-SC
  
  ( release target Feb 2019 )
  
  http://www.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future releases 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:

Fix information

• Fixed component name

  TPC ADVANCED

• Fixed component ID

  5608TPCA0

Applicable component levels