SAP Knowledge Base Article - Preview

3309275 - DB2 tried to retrieve logs and ended with No room for retrieved log number <nr> in retrieveArray.

Symptom

Db2diag.log records the following warning
A limitation of retrieved logs is reached
Retrieved logs remain under /db2/<DIR>/log_dir/ and continues to occupy space.
SQL2038N is received.

2023-03-04-05.16.20.627412+060 I5875416908A1502 LEVEL: Warning
PID : 
INSTANCE: 
HOSTNAME: 
EDUID : 
FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveStartUse, probe:190
DATA #1 :
WARNING: No room for retrieved log number XXXXX in retrieveArray. Index 18446744073709551615 entryCount 264
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x0900000010799230 pdLogPrintf + 0x60
[1] 0x0900000013EF8AA8 sqlpgRetrieveStartUse__FP14sqlpMasterDbcbUiUsPUlUlPCcT5 + 0x76C
[2] 0x09000000125DFB80 sqlplfrAddToRetrieveArray__FP14sqlpMasterDbcbP12SQLPLFR_DBCBUiUsPCcP21SQLPLFR_REQ_SCAN_NEXTPUlb + 0x1DC
[3] 0x09000000125D7410 sqlplfrFMOpenLog__FP12SQLPLFR_DBCBUiP21SQLPLFR_REQ_SCAN_NEXTUlPUlPP9SQLP_LECB + 0x6D54
[4] 0x0900000011E3C594 sqlplfrFMReadLog__FP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQLPLFR_SCAN_DATA + 0x310
[5] 0x0900000011E3B868 sqlplfrDoScanNext__FP12SQLPLFR_DBCBP11SQLPLFR_REQ + 0xDF4
[6] 0x090000000FFD9BD4 sqlplfrEdu__FP9sqpLfrEdu + 0x554
[7] 0x090000000FFD9598 RunEDU__9sqpLfrEduFv + 0x34
[8] 0x090000001034DB08 EDUDriver__9sqzEDUObjFv + 0x3EC
[9] 0x090000001034D6E0 sqlzRunEDU__FPcUi + 0x10
[10] 0x0900000010360558 sqloEDUEntry + 0x264
[11] 0x090000000051FE10 _pthread_body + 0xF0
[12] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF

Additional dump.bin can be seen in the db2diag.log

2023-03-04-05.16.20.628012+060 I5875418411A167 LEVEL: Warning
PID:Title: SQLP_DBCB
Dump File:/db2/<SID>/db2dump/XXXXXXXXXXX.dump.bin

 

 


Read more...

Environment

Db2 LUW IBM
Can occur on Db2 LUW version 10.1, 10.5

Product

SAP NetWeaver all versions

Keywords

timing conditions , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.