|
Problem IT41639
|
Status: Closed |
EXCESSIVE DB2DIAG ENTRY FROM SQLPGRETRIEVELOOKUP
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
The below diag entry is being printed excessively when there are
multiple retrieve requests for the same log file.
PID Â Â : 1111 Â Â Â Â Â Â Â Â TID : 111111111111112 PROC :
db2sysc 0
INSTANCE: myinst1 Â Â Â Â Â Â Â NODE : 000 Â Â Â Â Â Â DB Â : MYDB
HOSTNAME: myhost1
EDUID Â : 61 Â Â Â Â Â Â Â Â Â EDUNAME: db2lfr.0 (MYDB) 0
FUNCTION: DB2 UDB, data protection services,
sqlpgRetrieveLookup, probe:500
DATA #1 :
Log 12345 on log stream 0 is in the array but is still being
retrieved.
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
 [0] 0x000072C24BAE8699 pdLogPrintf + 0x79
 [1] 0x000072C253E902B5
_Z19sqlpgRetrieveLookupP14sqlpMasterDbcbjmtPm + 0x3A5
 [2] 0x000072C25401F356
_Z16sqlplfrFMOpenLogP12SQLPLFR_DBCBjP21SQLPLFR_REQ_SCAN_NEXTPmPP
9SQLP_LECB + 0x3DF6
 [3] 0x000072C2540051D6
_Z16sqlplfrFMReadLogP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQ
LPLFR_SCAN_DATA + 0x3E6
 [4] 0x000072C25400A896
_Z17sqlplfrDoScanNextP12SQLPLFR_DBCBP11SQLPLFR_REQ + 0x426
 [5] 0x000072C25400F2D8 _Z10sqlplfrEduP9sqpLfrEdu + 0x848
 [6] 0x000072C2541A1B57 _ZN9sqpLfrEdu6RunEDUEv + 0x27
 [7] 0x000072C255ABE734 _ZN9sqzEDUObj9EDUDriverEv + 0x1A4
 [8] 0x000072C253D60599 sqloEDUEntry + 0x2A9
 [9] 0x000072C25A8C3EA5 /lib64/libpthread.so.0 + 0x7EA5
 [10] 0x000072C2481F29FD clone + 0x6D |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 11.5.8. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 11.5.8. *
**************************************************************** |
| Comment |
Fixed in 11.5.8, diag entry will no longer be shown at warning
level. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2022
30.07.2022
08.09.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
