Fixes are available
APAR status
Closed as program error.
Error description
When running a query involving one or more SORT operators, the instance may trap with the following entry and stack in db2diag.log: 2020-01-29-11.12.03.452674-300 E522463E3232 LEVEL: Severe (OS) PID : 4129 TID : 47244791244544 PROC : db2sysc 0 INSTANCE: XXXXXXXX NODE : 000 DB : XXXX APPHDL : 0-37515 APPID: X.X.X.X.47484.200129155118 AUTHID : XXXXXXXX HOSTNAME: XXXXXXXX EDUID : 13248 EDUNAME: db2agnts (XXXX) 0 FUNCTION: DB2 UDB, SQO Latch Tracing, SQLO_SLATCH_CAS64::getConflictComplex, probe:210 MESSAGE : ZRC=0x870F00FB=-2029059845=SQLO_SLATCH_ERROR_HELDX_WITH_SHARED_H OLDERS "shared latch found with both exclusive and shared holders. Latch likely corrupt." CALLED : OS, -, unspecified_system_function DATA #1 : String, 13 bytes invalid latch DATA #2 : File name, 16 bytes sqloLatchCAS64.C DATA #3 : Source file line number, 8 bytes 592 DATA #4 : Codepath, 8 bytes 0 DATA #5 : String, 131 bytes 0x00002AD2F8A90030: { held X: 1 reserved for X: 0 shared holders: 48 firstSharIndex: 0xD2F8A firstExclIndex: 0x15 } DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes 0x10000 (SQLO_LATCH_MODE_EXCLUSIVE) DATA #7 : String, 395 bytes { state = 0x00002AD2F8A90030 = { held X: 1 reserved for X: 0 shared holders: 48 firstSharIndex: 0xD2F8A firstExclIndex: 0x15 } starve X mode = true xWaitCount = 52928 requestCount = 0 identity = unknown (3506) } DATA #8 : Pointer, 8 bytes 0x00002ae17c740000 DATA #9 : Hexdump, 16 bytes 0x00002AE17C740000 : 3000 A9F8 D22A 0000 B20D C0CE 0000 0000 0....*.......... CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002AAAB127954D _ZNK17SQLO_SLATCH_CAS6420dumpDiagInfoAndPanicEPKcjmmlmiS1_mi + 0x2AD [1] 0x00002AAAB22EB65D _ZN17SQLO_SLATCH_CAS6418getConflictComplexEm + 0x8ED [2] 0x00002AAAAC37C31B /var/ibmdb2/nypit348/sqllib/lib64/libdb2e.so.1 + 0x129031B [3] 0x00002AAAAC37CC26 _Z13sqlbUnfixPageP11SQLB_FIX_CB + 0x636 [4] 0x00002AAAAF839A32 _Z13sqlsUnfixPageP10SQLS_SLDESP14SQLD_FILE_INFOm + 0xB2 [5] 0x00002AAAAF83D994 _Z8sqlsfshpP8sqeAgentP10SQLS_SLDES + 0xF44 [6] 0x00002AAAAF829D53 _Z7sqlsendP8sqeAgentP10SQLS_SLDESi + 0x53 [7] 0x00002AAAAF82450C _Z8sqlsclosP8sqeAgentPP8SQLD_CCBPc + 0x11C [8] 0x00002AAAAF668206 _Z9sqlrsclosP8sqlrr_cbP9sqlri_tao + 0x386 [9] 0x00002AAAB2341274 _Z8sqlricloP8sqlrr_cbP9sqlri_taoi + 0x554 [10] 0x00002AAAB234930A _Z7sqlritaP8sqlrr_cb + 0x28A [11] 0x00002AAAB2342246 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x196 [12] 0x00002AAAAF479AC3 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x173 [13] 0x00002AAAAF478B41 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x591 [14] 0x00002AAAAE26E77D /var/ibmdb2/nypit348/sqllib/lib64/libdb2e.so.1 + 0x318277D [15] 0x00002AAAAE26D22C _Z21sqleProcessSubRequestP8sqeAgent + 0x2EC [16] 0x00002AAAAE288B72 _ZN8sqeAgent6RunEDUEv + 0x4C2 [17] 0x00002AAAAFAC3A47 _ZN9sqzEDUObj9EDUDriverEv + 0xF7 [18] 0x00002AAAAF26F4E3 sqloEDUEntry + 0x303 [19] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1 [20] 0x00002AAAB8183C4D clone + 0x6D
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v111m4fp6 or later * ****************************************************************
Problem conclusion
Upgrade to db2_v111m4fp6 or later
Temporary fix
Comments
APAR Information
APAR number
IT32155
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-03-11
Closed date
2021-03-19
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.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2022