IBM Support

IT19853: SIGNAL 11 TRAP AT SQLRA_GET_VAR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When some memory constraints happened on the system, one may see
    
    SQLO_NOMEM_APPSHRH errors from the sqlra_load_var function in
    the
    db2diag.log, followed by a trap immediately following in
    sqlra_get_var() with signal
    11.
    
    Sample db2diag.log reported by the trapping EDU:
    
    2017-02-24-15.04.24.490958+000 I59687656E679         LEVEL:
    Error
    PID     : 13912                TID : 140699005609728 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    BLUDB
    APPHDL  : 0-306                APPID:
    *LOCAL.db2inst1.170224143310
    AUTHID  : DB2INST1             HOSTNAME:
    hostname.net
    EDUID   : 104                  EDUNAME: db2agent (BLUDB) 0
    FUNCTION: DB2 UDB, access plan manager,
    sqlra_sqlW_get_dynamic_section, probe:900
    RETCODE : ZRC=0x8B0F0014=-1961951212=SQLO_NOMEM_APPSHRH
              "No memory available in 'Applications Shared Heap'"
              DIA8300C A memory heap error has occurred.
    
    2017-02-24-15.04.24.491694+000 I59688336E1100        LEVEL:
    Error
    PID     : 13912                TID : 140699005609728 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    BLUDB
    APPHDL  : 0-306                APPID:
    *LOCAL.db2inst1.170224143310
    AUTHID  : DB2INST1             HOSTNAME:
    hostname.net
    EDUID   : 104                  EDUNAME: db2agent (BLUDB) 0
    FUNCTION: DB2 UDB, access plan manager, sqlra_load_var,
    probe:200
    MESSAGE : ZRC=0x8B0F0014=-1961951212=SQLO_NOMEM_APPSHRH
              "No memory available in 'Applications Shared Heap'"
              DIA8300C A memory heap error has occurred.
    DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -973   sqlerrml: 18
    sqlerrmc: application shared
    sqlerrp : SQLRA115
    sqlerrd : (1) 0x8B0F0014      (2) 0x00000014      (3) 0x00000000
               (4) 0x0000002A      (5) 0x00000000      (6)
    0x00000000
    sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
               (7)      (8)      (9)      (10)        (11)
    sqlstate:
    
    stack of the trap would look like
    
    
    0      ossDumpStackTraceInternal
    1      ossDumpStackTraceV98
    2      OSSTrapFile::dumpEx
    3      sqlo_trce
    4      sqloEDUCodeTrapHandler
    5      _IO_ftrylockfile
    6      sqlra_get_var
    7      sqlrr_prepare
    8      sqljs_ddm_prpsqlstt
    9      sqljsParseRdbAccessed
    10      sqljsParse
    11      sqljsSqlam
    12      sqljsDrdaAsInnerDriver
    13      sqljsDrdaAsDriver
    14      sqeAgent::RunEDU
    15      sqzEDUObj::EDUDriver
    16      sqloEDUEntry
    17      start_thread
    18      clone
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * N/A                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 11.1 Mod 2 Fix Pack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT19853

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-23

  • Closed date

    2017-06-27

  • Last modified date

    2017-06-27

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020