DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 can crash with the following on a DPF system:

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
OSERR   : 3473536 "Error 3473536 occurred."
DATA #1 : String, 13 bytes
invalid latch
DATA #2 : File name, 16 bytes
sqloLatchCAS64.C
DATA #3 : Source file line number, 8 bytes
515
DATA #4 : Codepath, 8 bytes
0
DATA #5 : String, 139 bytes
0xFFFFFFFFFFFFFFFF: {
   held X: 1
   reserved for X: 1
   shared holders: 65535
   firstSharIndex: 0x1FFFFF
   firstExclIndex: 0x1FFFFF
}
DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes
0x1 (SQLO_LATCH_MODE_SHARED)
DATA #7 : String, 428 bytes
{
   state         = 0xFFFFFFFFFFFFFFFF
                 = {
                       held X: 1
                       reserved for X: 1
                       shared holders: 65535
                       firstSharIndex: 0x1FFFFF
                       firstExclIndex: 0x1FFFFF
                   }
   starve X mode = true
   xWaitCount    = 0
   requestCount  = 0
   identity      = SQLRAUDITSETTINGS::auditSettingsLatch (770)
}
DATA #8 : Hexdump, 16 bytes
0x0A000600E839FD20 : FFFF FFFF FFFF FFFF 0302 0000 0000 0000
................

Likely you will see two agents trap

agent stack :

0x0900000000510F14 pthread_kill + 0xD4
0x090000001C39A20C sqloDumpEDU + 0x54
0x090000001C0B74BC sqle_panic__Fv + 0x160
0x090000001E36E820
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7 + 0x2CC
0x090000001E36E470
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7@glue339 + 0xA0
0x090000001BC73420 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
0x40
0x090000001CC3206C getConflict__17SQLO_SLATCH_CAS64FCUl + 0xC8
0x090000001CC32144 getConflict__17SQLO_SLATCH_CAS64FCUl@glueFD +
0x74
0x090000001BD10588
sqleLookupAuditSettings__FPCcCP18sqlexAuditSettings + 0x2C8
0x090000001CDB9468
sqlexGetConnectAuditSettings__FP14db2UCinterfaceP18sqlexAuditSet
tings + 0x30
0x090000001CDBA574 sqlexEngAuthenticate__FP14db2UCinterface +
0xE0
0x090000001CDBB744
AppLocalStart__14sqeApplicationFP14db2UCinterface + 0x29C
0x090000001CB4014C sqlelostWrp__FP14db2UCinterface + 0x38
0x090000001CB40200 sqleUCengnInit__FP14db2UCinterfaceUs + 0x64
0x090000001CDC2194 sqleUCagentConnect + 0x2B4
0x090000001CDC3064
sqljsConnectAttach__FP13sqljsDrdaAsCbP14db2UCinterface + 0x104

Waiting on latch type:
(SQLO_LT_SQLRAUDITSETTINGS__auditSettingsLatch) - Address:
(a000600e839fd20), Line: 2842, File: sqle_database.C
Holding Latch type:
(SQLO_LT_sqlr_db__exclusiveDDLMemoryListLatch) - Address:
(a000600e80af9b8), Line: 2833, File: sqle_database.C HoldCount:
1

subagent :

0x0900000000510F14 pthread_kill + 0xD4
0x090000001C39A20C sqloDumpEDU + 0x54
0x090000001C0B74BC sqle_panic__Fv + 0x160
0x090000001E36E820
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7 + 0x2CC
0x090000001E36E470
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7@glue339 + 0xA0
0x090000001BC73420 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
0x40
0x090000001CC3206C getConflict__17SQLO_SLATCH_CAS64FCUl + 0xC8
0x090000001CD38224
getConflict__17SQLO_SLATCH_CAS64FCUl@glueFD@clone1 + 0x74
0x090000001D78269C sqlrr_appl_init__FP8sqeAgentP5sqlca + 0xE78
0x090000001D77FC98
InitEngineComponents__14sqeApplicationFcP8sqeAgentP8SQLE_BWAP5sq
lcaP22SQLESRSU_STATUS_VECTORT1 + 0x9B8
0x090000001CAC1C3C
AppStartUsing__14sqeApplicationFP8SQLE_BWAP8sqeAgentcT3P5sqlcaPc
+ 0x62C
0x090000001C2D761C
sqleSubAgentStartUsing__FP8sqeAgentP16SQLE_CLIENT_INFO + 0x3E8
0x090000001BE0AB90
AppSecondaryStartUsing__14sqeApplicationFP8sqeAgentP16SQLE_CLIEN
T_INFOP5sqlca + 0x590
0x090000001BF4BD0C initSubAgent__8sqeAgentFv + 0x678
0x090000001EAA891C sqleProcessSubRequest__FP8sqeAgent + 0x454
0x090000001DC156FC RunEDU__8sqeAgentFv + 0xF0
0x090000001CAA39F8 EDUDriver__9sqzEDUObjFv + 0x100
0x090000001CAA38B4 sqlzRunEDU__FPcUi + 0x24
0x090000001CAB0E4C sqloEDUEntry + 0x264

Waiting on latch type:
(SQLO_LT_SQLRAUDITSETTINGS__auditSettingsLatch) - Address:
(a000600e839fd20), Line: 2234, File: sqlrr.C


The signature of this APAR is the latch in
SQLO_LT_SQLRAUDITSETTINGS__auditSettingsLatch)

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* See SYSROUTE APARs to see where this APAR is addressed       *
****************************************************************

Activate database explicitly

not known / see Local fix

forerunner  : 
follow-up : IT18614 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

08.11.2016
08.05.2017
08.05.2017