IT15527: IN SPECIFIC TIMING CONDITIONS WITH MULTIPLE DB2READLOG API CALLERS(CDC, ETC), "NO ROOM FOR RETRIEVED LOG" occurs in db2diag.log

https://www.ibm.com/mysupport/s/defect/aCI0z000000TOfW/dt010963?language=en_US

1.  Problem description
In specific timing conditions with multiple db2readlog API
callers (CDC, etc),
DB2 generates dump files with "No room for retrieved log"
warning message in db2diag.log.


2.  Diagnostic information

db2diag.log

FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveStartUse, probe:190                         ...
Show more

****************************************************************

* USERS AFFECTED:                                              *

* ALL                                                          *

****************************************************************

* PROBLEM DESCRIPTION:                                         *

* 1.  Problem description                                      *

* In specific timing conditions with multiple db2readlog API   *

* callers (CDC, etc),                                          *

* DB2 generates dump files with "No room for retrieved log"    *

* warning message in db2diag.log.                              *

*                                                              *

*                                                              *

* 2.  Diagnostic information                                   *

*                                                              *

* db2diag.log                                                  *

*                                                              *

* FUNCTION: DB2 UDB, data protection services,                 *

* sqlpgRetrieveStartUse, probe:190                             *

* DATA #1 :                                      *

* WARNING: No room for retrieved log number XXXXX in           *

* retrieveArray. Index XXXXXXX entryCount 264                  *

*                                                              *

* PID:XXXX TID:XXXXXXXX NODE:000 Title: SQLP_DBCB              *

* Dump File: /db2dump/XXXXX.XXXXX.000.dump.bin                 *

*                                                              *

* PID:XXXX TID:XXXXXXXX NODE:000 Title: SQLP_LFPB              *

* Dump File: /db2dump/XXXXX.XXXXX.000.dump.bin                 *

*                                                              *

* .....                                                        *

*                                                              *

* 3. Symptom                                                   *

* Once this message happens, db2readlog API callers (CDC, etc) *

* may                                                          *

* receive SQL2038N error or are not able to continue           *

* retrieving                                                   *

* log files until database reactivation.                       *

****************************************************************

* RECOMMENDATION:                                              *

* Upgrade to DB2 Version 10.5 Fix Pack 8.                      *

****************************************************************
Show more

First fixed in Version 10.5 Fix Pack 8

1. Reactivate the database.
  db2 deactivate db <dbname>
  db2 activate db <dbname>

2. In case of 'OVERFLOWLOGPATH' is configured for the database,
   set 'OVERFLOWLOGPATH' as the same as full archive log path.

( NOTE : The OVERFLOWLOGPATH value needs to be full path to the
archived log files. )

  For example, if current full archive log path is
'/archive/aaa/db2inst1/aaa/NODE0000/LOGSTREAM0000/C0000001',

  db2 update db cfg for <dbname> using OVERFLOWLOGPATH
/archive/aaa/db2inst1/aaa/NODE0000/LOGSTREAM0000/C0000001

( NOTE : After changing, "NODE0000/LOGSTREAM0000" path will be
added automatically on "OVERFLOWLOGPATH" parameter.
             Even with that, the path which is specified in 'db2
update db cfg' will be referenced. )

Status

Closed

Programming Error - Fix provided (PER)

A fix is available
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows DB2 Version 10.5 Fix Pack 11 for Linux, UNIX, and Windows DB2 Version 10.5 Fix Pack 10 for Linux, UNIX, and Windows
Fixed Version(s) :

Subscribe

By subscribing, you receive periodic emails alerting you to the status of the known issue, along with a link to the fix after it becomes available.

Notify me when a known issue for this product changes
Manage my notifications
- Product
  
  Db2 Linux, Unix and Windows
  
  Software version
  
  10.5
  
  Document number
  
  DT010963
  
  Last modified
  
  2023年8月24日 GMT+8 18:49
- APAR Number
  
  IT15527
  
  Reported component id
  
  DB2FORLUW
  
  Reported component release
  
  A50
  
  Status
  
  Closed
  
  PTF in error
  
  NoPE
  
  HIPER:
  
  NoHIPER
  
  Special attention
  
  NoSpecatt
  
  -Product Specific
  
  Submitted date:
  
  2016年6月01日 GMT+8 11:00
  
  Closed date:
  
  2016年11月23日 GMT+8 10:00
  
  Last modified date:
  
  2023年8月24日 GMT+8 18:49
  
  ------------------------------------------------------------------------------------------
  如果你觉得文章有用，欢迎打赏