3450655 - DB6: Database crashes due to SQLP_LCON "Conditional Conflict"

Database crashes due to SQLP_LCON "Conditional Conflict" error.

The database log:

2024-03-15-22.41.33.996442+000 I246698487A623       LEVEL: Severe
PID     : 12456789             TID : 378972         PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000           DB   : abc
APPHDL  : 0-61071              APPID: *LOCAL.db2abc.240316035637
UOWID   : 1                    ACTID: 1              
AUTHID  : DB2abc               HOSTNAME: abc001
EDUID   : 378972               EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, global services, sqlzeMapZrc, probe:45
MESSAGE : ZRC=0x80100079=-2146434951=SQLP_LCON "Conditional Conflict"
          DIA8132C Conditional lock error occurred, lock name was "".

<snipped>

2024-03-15-22.45.12.320714+000 I247269962A606       LEVEL: Error
PID     : 12456789             TID : 378972         PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000           DB   : abc
APPHDL  : 0-61071              APPID: *LOCAL.db2abc.240316035637
UOWID   : 1                    ACTID: 1              
AUTHID  : DB2abc               HOSTNAME: abc001
EDUID   : 378972               EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_event_execid, probe:1645
DATA #1 : String, 36 bytes
error from sqlra_invalid_hard_execid
DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
0x80100079

2024-03-15-22.45.12.321131+000 E247270569A1705      LEVEL: Info (Origin)
PID     : 12456789             TID : 378972         PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000           DB   : abc
APPHDL  : 0-61071              APPID: *LOCAL.db2abc.240316035637
UOWID   : 1                    ACTID: 1              
AUTHID  : DB2abc               HOSTNAME: abc001
EDUID   : 378972               EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x80100079=-2146434951=SQLP_LCON "Conditional Conflict"
          DIA8132C Conditional lock error occurred, lock name was "".
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -902   sqlerrml: 3
 sqlerrmc: 121
 sqlerrp : SQLRA205
 sqlerrd : (1) 0x80100079      (2) 0x00000079      (3) 0x00000000
           (4) 0x00000000      (5) 0x00000000      (6) 0x00000000
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)    
           (7)      (8)      (9)      (10)        (11)     
 sqlstate:      
DATA #8 : Hex integer, 4 bytes
0x04000040
DATA #9 : String with size, 137 bytes
flush package cache dynamic for executable id x'000000010000000000000000EECED96900000000000220240315222049222244' using hard invalidation
DATA #10: String, 142 bytes
Compiler error stack for rc = -2146434951:
sqlnn_cmpl[300]
sqlnp_main[250]
sqlnp_parser[510]
sqlnp_smactn[180]
sqlnq_flush_pkg_cache_dyn[800]

<snipped>

2024-03-15-22.45.12.323912+000 I247275343A1890      LEVEL: Info
PID     : 12456789             TID : 378972         PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000           DB   : abc
APPHDL  : 0-61071              APPID: *LOCAL.db2abc.240316035637
AUTHID  : DB2abc               HOSTNAME: abc001
EDUID   : 378972               EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::ForceDBShutdown, probe:17205
MESSAGE : Regular agent EDU doing ForceDBShutdown.  Force DB shutdown agent ID 
          is:
DATA #1 : APPHDL, PD_TYPE_SQLZ_APPHDL, 4 bytes
0-61071
DATA #2 : sqeApplication_acbInfo, PD_TYPE_sqeApplication_acbInfo, 4 bytes
x0

• SAP on IBM Db2 for Linux, UNIX, and Windows
• IBM Db2 11.5

Conditional Conflict, Conditional lock error, sqlra_invalid_hard_execid, flush package cache dynamic , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem