IBM Support

JR32244: DB2 crash may occur when both a nickname and a DB2 table attempt the same transaction, and the access to nickname fails.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • DB2 crashes with call stack similar to below:
    
    -------Frame------ ------Function + Offset------
    0x090000000042B5BC pthread_kill + 0x88
    0x0900000029892DA8 sqloDumpEDU + 0x24
    0x09000000299EB018 sqloDumpEDU@glue21D + 0x74
    0x090000002A9CB0F0
    sqlzeMapZrc__FP8sqeAgentUiUlT2P5sqlcaiPC12sqlzeContext + 0x4AC
    0x090000002A604D10
    sqlrl_dgtt_rcv__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP13SQLR_RPC_DGTTP
    17SQLR_RPCRPLY_DGTT + 0x1B8
    0x090000002A5FAD18
    sqlrl_rpc_dms_router__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_RPC
    MESSAGE + 0xD44
    0x090000002B0EF8EC sqlrr_rpc_router__FP8sqlrr_cb + 0x3E8
    0x090000002B0E340C
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xEEC
    0x090000002B0DF6FC sqleSubRequestRouter__FP8sqeAgentPUiT2 +0x7E0
    0x090000002B0DB9F4 sqleProcessSubRequest__FP8sqeAgent + 0x120
    0x090000002AAC4878 RunEDU__8sqeAgentFv + 0x330
    0x090000002AB23EA0 EDUDriver__9sqzEDUObjFv + 0x78
    0x090000002AB221D8 sqloEDUEntry + 0x3A0
    ------------------------------------
    
    DB2 crash may occur when both a nickname and a DB2 table are
    involved in one transaction, and the access to nickname fails
    due to any reason.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    *                                                              *
    * *                                                            *
    * * all                                                        *
    * *                                                            *
    * ************************************************************ *
    * ALL                                                          *
    *                                                              *
    * *************************************************************
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * PROBLEM SUMMARY:                                             *
    *                                                              *
    * DB2 crashes with call stack similar to below:                *
    *                                                              *
    * -------Frame------ ------Function + Offset------             *
    * 0x090000000042B5BC pthread_kill + 0x88                       *
    * 0x0900000029892DA8 sqloDumpEDU + 0x24                        *
    * 0x09000000299EB018 sqloDumpEDU@glue21D + 0x74                *
    * 0x090000002A9CB0F0                                           *
    * sqlzeMapZrc__FP8sqeAgentUiUlT2P5sqlcaiPC12sqlzeContext +     *
    * 0x4AC                                                        *
    * 0x090000002A604D10                                           *
    * sqlrl_dgtt_rcv__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP13SQLR_RPC_DGT
    * 17SQLR_RPCRPLY_DGTT + 0x1B8                                  *
    * 0x090000002A5FAD18                                           *
    * sqlrl_rpc_dms_router__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_R
    * MESSAGE + 0xD44                                              *
    * 0x090000002B0EF8EC sqlrr_rpc_router__FP8sqlrr_cb + 0x3E8     *
    * 0x090000002B0E340C                                           *
    * sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xEEC    *
    * 0x090000002B0DF6FC sqleSubRequestRouter__FP8sqeAgentPUiT2    *
    * +0x7E0                                                       *
    * 0x090000002B0DB9F4 sqleProcessSubRequest__FP8sqeAgent +      *
    * 0x120                                                        *
    * 0x090000002AAC4878 RunEDU__8sqeAgentFv + 0x330               *
    * 0x090000002AB23EA0 EDUDriver__9sqzEDUObjFv + 0x78            *
    * 0x090000002AB221D8 sqloEDUEntry + 0x3A0                      *
    * ------------------------------------                         *
    *                                                              *
    * DB2 crash may occur when both a nickname and a DB2 table are *
    * involved in one transaction, and the access to nickname      *
    * fails due to any reason.                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to latest fixpack                                    *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR32244

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-04

  • Closed date

    2009-06-14

  • Last modified date

    2010-03-19

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

    JR32242

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

Fix information

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 March 2010