IBM Support

JR32242: 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:
    None
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 users below v91fp7                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * data inconsistency                                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to DB2 v91fp7 and later fixpacks                     *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR32242

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    910

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-03-04

  • Closed date

    2009-05-04

  • Last modified date

    2010-03-23

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

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

    JR32244

Fix information

Applicable component levels

  • R911 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.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
23 March 2010