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----------->
:
DB2
SQL Error: SQLCODE=-973, SQLSTATE=57011, SQLERRMC=MON_HEAP_SZ,
DRIVER=4.26.14
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
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. |
