IBM Support

IT27923: DPF PACKAGE CACHE REBIND DAEMON (DB2PKGRB) MAY HANG IN A PENDINGREMOTE REQUEST STATE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Application status snippet at the catalog members:
    
    Application status                        = Pending remote
    request
    Status change time                        = 01/12/2019
    07:29:35.204377
    Application code page                     = 819
    Application country/region code           = 0
    DUOW correlation token                    = *N1.DB2.190112123239
    Application name                          = db2pkgrb
    Application idle time                     = 2 hours 59 minutes
    45 seconds
    Snapshot timestamp                        = 01/12/2019
    10:28:06.276192
    Coordinator member number                 = 1
    Current member number                     = 1
    Coordinator agent process or thread ID    = 1040
    
    with the application at other members not showing an entry for
    this application.
    
    On member 1 - We could see latch -
    
    Database Member 1 -- Active -- Up 0 days 04:32:25 -- Date
    2019-01-12-11.55.48.262151
    
    Latches:
    Address           Holder    Waiter    Filename            LOC
    LatchType           HoldCount
    0x00007FFEE2867DE8 1040      0         Unknown             7754
    SQLO_LT_sqlra_sql_context_mcb__pdirptr_latch 1
    
    
    and stack for 1040
    0x00007FFFEFF1069B sqloDumpDiagInfoHandler + 0x020b
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF79CD7E0 address: 0x00007FFFF79CD7E0 ; dladdress:
    0x00007FFFF79BE000 ; offset in lib: 0x000000000000F7E0 ;
                   (/lib64/libpthread.so.0)
    0x00007FFFE77A529A semtimedop + 0x000a
                   (/lib64/libc.so.6)
    0x00007FFFEFDB5DEF sqloWaitEDUWaitPost + 0x03bf
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE7A3B1B _ZN11sqkfChannel13WaitRecvReadyEii + 0x075b
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE7A4A02
    _ZN11sqkfChannel13ReceiveBufferEPP10sqkfBufferi + 0x01c2
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE778F93
    _ZN18sqkdBdsBufferTable13dequeueBufferEPP10sqkfBufferP8SQLKD_CB
    + 0x1273
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE7775CE
    _ZN18sqkdBdsBufferTable12getNextReplyEP8SQLKD_CB + 0x004e
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE7773C9
    _ZN18sqkdBdsBufferTable13getNextBufferEPP10sqkfBufferP8SQLKD_CB
    + 0x01a9
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE76772E address: 0x00007FFFEE76772E ; dladdress:
    0x00007FFFE8C4B000 ; offset in lib: 0x0000000005B1C72E ;
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE76957F address: 0x00007FFFEE76957F ; dladdress:
    0x00007FFFE8C4B000 ; offset in lib: 0x0000000005B1E57F ;
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFEE765464
    _Z17sqlkdReceiveReplyP23SQLKD_RQST_REPLY_FORMAT + 0x07b4
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF0592583
    _Z11sqlrkrpc_nlP8sqlrr_cbiiiPKsP15SQLR_RPCMESSAGEP13SQLO_MEM_POO
    LP18SQLR_RPC_REPLY_HDRPbPlmP19SQLR_BDSREPLY_STATE + 0x1da3
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF07F53C6
    _Z27sqlra_broadcast_request_catP8sqlrr_cbP20SQLR_RPC_APM_REQUEST
    Pb + 0x0916
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF07F4759
    _Z23sqlra_broadcast_requestP8sqlrr_cbP20SQLR_RPC_APM_REQUESTPb +
    0x03d9
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF0871C51
    _Z14sqlra_drop_pkgP8sqlrr_cbPhsS1_sS1_S1_iibPb + 0x0391
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF086D6E9
    _Z18sqlra_recreate_pkgP8sqlrr_cbiicP15sqlra_func_pathh + 0x21a9
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF07F4007
    _Z16sqlra_rebind_pkgP8sqlrr_cbPhsS1_sS1_iicP15sqlra_func_pathb +
    0x0277
                   (/var/ibmdb2/nypxt440/sqllib/lib64/libdb2e.so.1)
    0x00007FFFF088106E
    _Z37sqlraFindInvalidPackagesAndRebindThemP8sqlrr_cb + 0x07ce
    

Local fix

  • Restart the instance.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * 250                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.6                                          *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT27923

  • 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

    2019-01-29

  • Closed date

    2021-03-22

  • Last modified date

    2021-03-22

  • 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

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

Document Information

Modified date:
23 March 2021