IBM Support

IC77660: INSTANCE TRAP AFTER LOAD OPERATION FAILS AT VERY EARLY STAGE (USUALLY DUE TO OUT OF SYSTEM RESOURCES)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You may encounter an instance trap after a LOAD operation fails
    (usually due to out of system resources) at a specific place
    very early on (at LOAD startup stage).
    
    The db2diag.log may show the following message indicating out of
    memory condition, or other message indicating out of system
    resources:
    
    2011-07-03-22.08.15.079591+120 I289048634E522     LEVEL: Error
    PID     : 29498                TID  : 47458223191968PROC :
    db2agent (SAMPLE)
    INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-362                APPID:
    *LOCAL.db2inst1.110703200802
    AUTHID  : DB2INST1
    FUNCTION: DB2 UDB, data protection services, sqlpwpen, probe:10
    RETCODE : ZRC=0x8B0F0002=-1961951230=SQLO_NOMEM_DBH
              "No memory available in 'Database Heap'"
              DIA8302C No memory available in the database heap.
    
    The stack of failing LOAD buffer manipulator (db2lbm) looks
    like:
    
    ossDumpStackTrace
    OSSTrapFile::dump
    sqlo_trce
    sqloEDUCodeTrapHandler
    __invoke_dynamic_linker__
    sqluTermLoadEDU
    sqluInitLoadEDU
    sqlulbuf
    sqloCreateEDU
    sqloSpawnEDU
    sqlulInitOneEDU
    sqlulInitNBM
    sqlulCreateQAndEDU
    sqluvload
    call_sqluvload
    
    It may be another LOAD process than db2lbm that fails; the
    common signature is sqluInitLoadEDU() calls sqluTermLoadEDU()
    and we trap inside sqluTermLoadEDU().
    
    DB2 fails (due to out of system resource) early in LOAD
    initialization code before setting up some internal pointers.
    During LOAD termination DB2 frees resources and dereferences the
    not initialzed pointer and traps.
    

Local fix

  • n/a (Proactively avoid hitting out of system resources, would
    avoid hitting this issue.  For example, DB2 system should be
    tuned during initial setup time (taking into consideration the
    expected workload) so that we will not run out of Database Heap
    memory.  Detailed DB2 setup/tuning instructions are beyond the
    scope of this APAR -- please refer to appropriate DB2
    documentation.)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All DB2 LOAD users on Version 9.7 Fixpack 4                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 5.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC77660

  • 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-07-21

  • Closed date

    2011-12-09

  • Last modified date

    2011-12-09

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

    IC77384

  • 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

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2011