IBM Support

IC76623: ABEND WHEN DUMPING INDEX INFORMATION WHEN DB2_MEMORY_PROTECT ENABLED ON AIX WITH STORAGE KEY SUPPORT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The DB2_MEMORY_PROTECT registry variable is enabled, and DB2 is
    running on AIX with storage key support, which is one of the
    pre-conditions for DB2_MEMORY_PROTECT to take effect (please
    refer to Information Center for more detail). At the same time,
    an index corruption problem is detected, and DB2 is going to
    dump extended diagnostic information about the damaged index.
    When these conditions are met, the DB2 instance may abend while
    writing the extended diagnostic information. The trap file will
    be similar to:
    
    EDU name     : db2lrid
    Signal #11
    
    sqltData
    memcpy
    _gtraceVar
    sqltData
    sqlt_logerr_dump
    sqldDumpDKEY
    sqldDumpDKEY
    sqliDumpICB
    

Local fix

  • Disable DB2_MEMORY_PROTECT.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * See APAR description                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See APAR description                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Problem first fixed in DB2 UDB 9.7 FixPack 5.                *
    ****************************************************************
    

Problem conclusion

  • See APAR description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76623

  • 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

    2011-05-25

  • Closed date

    2011-12-12

  • Last modified date

    2011-12-12

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76623

Modified date: 12 December 2011