Fixes are available
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
The following db2diag.log message indicates this issue: 2017-05-11-11.39.34.195951+120 I647545A1192 LEVEL: Error PID : 6553686 TID : 68140 PROC : db2sysc 0 INSTANCE: DB2INST1?NODE : 000 DB : MYDB1 APPHDL : 0-116 APPID: X.X.X.X.0000 AUTHID : DB2INST1?HOSTNAME: MYHOST1 EDUID : 68140 EDUNAME: db2agnts (MYDB1) 0 FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord, probe:504 MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER * DETECTED" DIA8003C The interrupt has been received. DATA #1 : Codepath, 8 bytes 8 DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes 0x80040003 DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1720 bytes SQLS_MBUFS: Address:a0002096bc1d0f8, Size:x6b8, Size:1720 x0688 pValues a0002096bc77b58 x0690 recptr a0002096bc771a0 x06AC records 1 x0698 recordBuffer a0002096bc771a0 x06A0 iNumBufferedRecords 0 x06A8 mergeFlags x00000002 - SQLS_CALLED_FETCH_NEXT_TEMP_REC x06B0 sortNum 0 x06B4 bufferedFetchRC -2147221501 2017-05-11-11.40.17.518767+120 I650353A3241 LEVEL: Severe PID : 6553686 TID : 68397 PROC : db2sysc 0 INSTANCE: DB2INST1?NODE : 000 DB : MYDB1 APPHDL : 0-34142 APPID:X.X.X.X.0000 AUTHID : DB2INST1??HOSTNAME: MYHOST1 EDUID : 68397 EDUNAME: db2agnts (MYDB1) 0 FUNCTION: DB2 UDB, sort/list services, sqlsSanityCheckPageAlreadyUnfixed, probe:4095 MESSAGE : ZRC=0x82130001=-2112684031=SQLS_NONSEVERE_PE "Sort List Services programming error." DIA8532C An internal processing error has occurred. DATA #1 : String, 83 bytes Sort Error. Failed sanity check before unfixing page, bpdPtr is null, aborting sort DATA #2 : Fix control block, PD_TYPE_SQLB_FIX_CB, 208 bytes accessMethod: SQLB_POOL_RELATIVE fixMode: 2 SQLBOLD buffptr: 0x0000000000000000 bpdPtr: 0x0000000000000000 pageLsnOnXLatch: 0000000000000000 dmDebugHdl: 0 objectPageNum: 2 empDiskPageNum: 4294967295 unfixFlags: 2000008 SQLB_UFIX_PURGE_MODE dirtyState: SQLBCLEAN fixInfoFlags: 0 regEDUid: 0 Pagekey: {pool:3;obj:2;type:128} PPNum:2 Obj: {pool:3;obj:2;type:128} Parent={3;2} lifeLSN: 0511114017040371 tid: 0 0 0 extentAnchor: 0 initEmpPages: 0 poolPage0: 0 poolflags: 0x 1111 objectState: 0x 80027 lastSMP: 0 pageSize: 16384 extentSize: 2 bufferPoolID: 1 partialHash: 2147614723 objDescAttributes: 0 objDescEHLState: 0x0000000000000000 bufferPool: 0x0a0002000d1f1a40 pdef: 0x0a0002000eae1e20 glob: 0x0000000117e95080 DATA #3 : Dumped object of size 3760 bytes at offset 0, 43 bytes /db2/P20/db2dump/6553686.68397.000.dump.bin CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000000FD5807C sqlsmergerec__FP8sqeAgentP10SQLS_SLDESP10SQLS_MBUFSUl + 0x19A8 [1] 0x090000000FD3DA00 sqlsfetc__FP8sqeAgentP8SQLD_CCBiP10SQLD_DPREDPP10SQLD_VALUEP8SQL Z_RIDPc@OL@23903 + 0x434 [2] 0x09000000126DDDBC sqlsfetc__FP8sqeAgentP8SQLD_CCBiP10SQLD_DPREDPP10SQLD_VALUEP8SQL Z_RIDPc + 0xA4 [3] 0x0900000012C6BEF4 sqlriFetch__FP8sqlrr_cbP9sqlri_taol + 0x138 [4] 0x0900000012C6BFC4 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x1C [5] 0x0900000012C6C01C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x74 [6] 0x09000000115B7318 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x5300 [7] 0x090000001153EA78 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xDA0 [8] 0x090000001153F41C @82@sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x230 [9] 0x09000000137ED784 RunEDU__8sqeAgentFv + 0x31EF4 [10] 0x09000000137749F0 RunEDU__8sqeAgentFv + 0x124 [11] 0x09000000124B3B9C EDUDriver__9sqzEDUObjFv + 0x134 [12] 0x0900000013766B80 sqloEDUEntry + 0x390 [13] 0x090000000053FE10 _pthread_body + 0xF0 [14] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF This is timing issue between two agents. Since this happens when a temp object is accessed the impact should be low and the query retried.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All users. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 M3 FP3. * ****************************************************************
Problem conclusion
See Problem Description above.
Temporary fix
Comments
APAR Information
APAR number
IT21261
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-06-30
Closed date
2018-03-16
Last modified date
2022-03-29
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
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022