IBM Support

IT38584: IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the instance runs out of mon heap, it is possible for SQL
    statements to fail with SQL0973N.  When this occurs an
    application may issue SQL which fails with SQL0973N.   For
    example, a java program may receive the following:
    
    [9/28/21 12:44:05:611 EDT] 00005d0c LoggerScripta I
    error----------->
     :
     <JDBCMessage type="java.lang.String" description="String">DB2
    SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=MON_HEAP_SZ,
    DRIVER=4.26.14</JDBCMessage>
     <message type="java.lang.String" description="String">Not
    enough storage is available in the "MON_HEAP_SZ" heap or stack
    to process the statement.. SQLCODE=-973, SQLSTATE=57011,
    DRIVER=4.26.14</message>
    
    
    The db2diag.log may report probes such as the following the time
    the SQL statement fails:
    
    2021-09-28-12.44.05.541221-240 I2196297E641          LEVEL:
    Severe
    PID     : 56728                TID : 140621700392704 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    MYDB1
    APPHDL  : 0-17696              APPID:
    X.X.X.X.0000.210928164418
    AUTHID  : DB2INST1             HOSTNAME: MYHOST1
    EDUID   : 2982                 EDUNAME: db2agent (MYDB1) 0
    FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo_field,
    probe:40
    RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH
              "No memory available in 'Database Monitor Heap'"
              DIA8300C A memory heap error has occurred.
    
    2021-09-28-12.44.05.541477-240 I2196939E635          LEVEL:
    Severe
    PID     : 56728                TID : 140621700392704 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    MYDB1
    APPHDL  : 0-17696              APPID:
    X.X.X.X.0000.210928164418
    AUTHID  : DB2INST1             HOSTNAME: MYHOST1
    EDUID   : 2982                 EDUNAME: db2agent (MYDB1) 0
    FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo,
    probe:15
    RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH
              "No memory available in 'Database Monitor Heap'"
              DIA8300C A memory heap error has occurred.
    
    2021-09-28-12.44.05.541773-240 I2197575E641          LEVEL:
    Severe
    PID     : 56728                TID : 140621700392704 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    MYDB1
    APPHDL  : 0-17696              APPID:
    X.X.X.X.0000.210928164418
    AUTHID  : DB2INST1             HOSTNAME: MYHOST1
    EDUID   : 2982                 EDUNAME: db2agent (MYDB1) 0
    FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo_field,
    probe:40
    RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH
              "No memory available in 'Database Monitor Heap'"
              DIA8300C A memory heap error has occurred.
    
    2021-09-28-12.44.05.542011-240 I2198217E635          LEVEL:
    Severe
    PID     : 56728                TID : 140621700392704 PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000            DB   :
    MYDB1
    APPHDL  : 0-17696              APPID:
    X.X.X.X.0000.210928164418
    AUTHID  : DB2INST1             HOSTNAME: MYHOST1
    EDUID   : 2982                 EDUNAME: db2agent (MYDB1) 0
    FUNCTION: DB2 UDB, base sys utilities, sqle_add_setinfo,
    probe:15
    RETCODE : ZRC=0x8B0F000B=-1961951221=SQLO_NOMEM_MONH
              "No memory available in 'Database Monitor Heap'"
              DIA8300C A memory heap error has occurred.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.1.4.7                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.1.4.7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT38584

  • 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

    2021-10-04

  • Closed date

    2022-04-17

  • Last modified date

    2022-04-17

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

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

    IT39184

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"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:
04 May 2022