IBM Support

IC93176: STOPPING A FILE EVENT MONITOR MAY CAUSE DB2 TO MARK DATABASE BAD AND BRING INSTANCE DOWN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The db2diag.log could dump a message as follows:
    
    2013-04-26-19.58.41.422235-300 I823663A547        LEVEL: Error
    PID     : <PID>              TID  : <TID>       PROC : db2sysc 0
    INSTANCE: <INST>                 NODE : 000         DB   : <DB>
    APPHDL  : 0-3929               APPID: *LOCAL.x.x
    AUTHID  : <AUTHID>
    EDUID   : <EDUID>                EDUNAME: db2agent (DB) 0
    FUNCTION: DB2 UDB, database monitor, sqm_evmon_mgr::stop_evmon,
    probe:121
    CALLED  : DB2 UDB, database monitor,
    sqmEvmonWaiter::waitForEvmon
    RETCODE : ZRC=0x83000004=-2097151996
    DATA #1 : String, 10 bytes
    <Event Monitor name>
    
    -2097151996 translates to "Unexpected Operating System error".
    
    The trap file generated after instance crash could have a stack
    similar to the following:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x090000000063CAB0 pthread_kill + 0xB0
    0x0900000009797890 sqloDumpEDU + 0x34
    0x0900000009230AB8 sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2 +
    0xFC
    0x0900000009D011B8
    sqldDumpContext__FP9sqeBsuEduiN42PCcPvT2@glue5A7 + 0x98
    0x0900000009D6EEDC sqlrr_dump_ffdc__FP8sqlrr_cbiT2 + 0x36C
    0x090000000D418010 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai + 0x50
    0x090000000D4180F8 sqlzeDumpFFDC__FP8sqeAgentUiP5sqlcai@glue52F
    + 0x88
    0x090000000D4185F0
    sqlzeMapZrc__FP8sqeAgentUiUlT2P5sqlcaiPC12sqlzeContextb + 0x1A4
    0x090000000D418F48 sqlrrMapZrc__FP8sqlrr_cbUiUli@glue3BD + 0x80
    0x0900000009E069E0 sqlrienv_evm__FP8sqlrr_cbP10sqlz_valueT2 +
    0x114
    0x090000000D024450 sqlrienv__FP8sqlrr_cb + 0x68
    0x090000000D2F2B84 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x28
    0x090000000D4AE874 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x544
    0x090000000D4AE210
    sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x25C
    0x090000000D4ADEBC
    sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0x850
    0x090000000D4AD5FC
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x1C
    0x090000000D2B371C
    .sqljsParse.fdpr.clone.77__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s
    qeAgentb + 0x240
    0x090000000D29BD44 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
    + 0xAA8
    0x090000000D090658
    @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA0
    0x090000000D0902CC
    @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x260
    0x090000000D08FD94 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x1EC
    0x090000000D16E3D8 RunEDU__8sqeAgentFv + 0x298
    0x090000000D163D58 EDUDriver__9sqzEDUObjFv + 0xE4
    0x090000000D16BCFC sqloEDUEntry + 0x260
    </StackTrace>
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 v9.7 FP9.                                     *
    ****************************************************************
    

Problem conclusion

  • Fixed in DB2 v9.7 FP9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93176

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-18

  • Closed date

    2014-06-18

  • Last modified date

    2014-06-18

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

    IC92962

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

    IC95403

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

  • RA10 PSN

       UP

  • RA50 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC93176

Modified date: 18 June 2014