IT26054: -901 ERROR WITH TEXT "WITH HOLD BUT USAGE LOCK ARGUMENT NULL" REPORTED BY SQLRLC_REQUEST_ULOCK() AS CALLED BY SQLRLGETREPLMQTREF

Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows

APAR status

• Closed as fixed if next.

Error description

• SELECT referencing SYSCAT.TABLES of replication-maintained MQT
  might hang/crash with SQL0901N
  
  Stack:
  
  0x090000000055AF14 pthread_kill + 0xD4
  
  0x0900000008AEDB7C sqloDumpEDU + 0x9C
  
  0x0900000009711550 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
  0x150
  
  0x090000000AA1702C sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x90C
  
  0x0900000008C4AB38 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x158
  
  0x0900000008C4A61C sqlzeSqlCode__FP8sqeAgentUiUlT2P5sqlcaiUsPc +
  0x27C
  
  0x0900000008C4710C sqlrrSqlCode + 0x18C
  
  0x090000000B146A78
  sqlrlc_request_ulock__FP8sqlrr_cbP19sqlrlc_entry_commonP20sqlrlc
  _anchor_commonPbUiN25PUiP14SQLP_LOCK_INFOT9T8 + 0x1D8
  
  0x090000000B145FE4
  sqlrlc_find_request_usage_lock__FP8sqlrr_cbP10sqlrlc_keyUiN23PP1
  9sqlrlc_entry_commonPUiP14SQLP_LOCK_INFOT8 + 0x664
  
  0x090000000B140E20
  sqlrlc_systables_fetch__FP8sqlrr_cbPUcUsT2T3UiN26P13SQLO_MEM_POO
  LP14SQLP_LOCK_INFOP21sqlrlc_systables_info + 0x9E0
  
  0x090000000DB83ACC
  sqlrlGetReplMQTRefreshTimestamp__FP8sqlrr_cbPbPUc + 0x20C
  
  0x0900000009C99ECC
  sqlra_check_mqt_replication_latency__FP8sqlrr_cbPCUcPb + 0x3AC
  
  0x0900000009C9517C
  sqlra_find_var_var__FP8sqlrr_cbP17sqlra_cached_stmtPP16sqlra_cac
  hed_envP14sqlra_cmpl_envUiiT615sqlra_fill_modePiT6N29P14SQLP_
  
  LOCK_INFOT13_PP16sqlra_cached_varN49bT20_PUiT22_ + 0x4D9C
  
  0x0900000009C9C8E8
  sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
  T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_
  
  P14SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x848
  
  0x090000000AD59194 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xBF4
  
  0x090000000A4B6E94
  IPRA.$sqlrr_process_open_request__FP8sqlrr_cbPbPUlP15db2UCCursor
  InfoT2 + 0x3594
  
  0x090000000A4AF388
  sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x4A8
  
  0x090000000F8A1BC0
  sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0
  
  0x090000000F8405F8
  sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
  interface + 0x298
  
  0x090000000F843650
  sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
  0x2250
  
  0x090000000F80FACC
  IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEAC
  
  0x090000000F818594
  sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
  
  0x090000000F80DB70
  IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0
  
  0x090000000F80AFB4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
  0x334
  
  0x0900000008C14DA0 RunEDU__8sqeAgentFv + 0xB60
  
  0x0900000008BF78A0 EDUDriver__9sqzEDUObjFv + 0x2E0
  
  0x0900000008AE7814 sqloEDUEntry + 0x374
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 11.1fp5 or later                              *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• RB10 PSN

     UP