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
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.
SAP Knowledge Base Article - Preview