IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT26054

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-08-22

  • Closed date

    2019-01-21

  • Last modified date

    2019-01-21

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 May 2020