I am getting insufficient memory errors every month or so and db2 keeps crashing my server which can only be fixed via restart. I'm not really well versed on db2 so I was hoping someone could help me with the proper configurations that I need to take to increase the memory so that my db2 stops crashing. Any help is appreciated in advance! Thank you !
I am running db2 DB2 v11.5.0.1077 on Windows Server 2022
I got this while running the following command and it seemed my memory was insufficient:
C:\Windows\system32>db2 get dbm cfg | findstr /i memory
Global instance memory (% or 4KB) (INSTANCE_MEMORY) = AUTOMATIC(4194304)
Member instance memory (% or 4KB) = GLOBAL
I was trying to fix this issue by increasing the memory but I get the following errors:
C:\Windows\system32>db2 update dbm cfg using INSTANCE_MEMORY 8388608
SQL5130N The value specified for the configuration parameter
"instance_memory" is not in the valid range of "0" to "4194304".
Just for reference some additional information:
C:\Windows\system32>db2pd -dbptnmem
Database Member 0 -- Active -- Up 5 days 05:15:23 -- Date 2024-07-18-15.19.25.073000
Database Member Memory Controller Statistics
Controller Automatic: Y
Controller License Limit: Y
Controller Limit Enforced: Y
Memory Limit: 16777216 KB
Current usage: 9265152 KB
HWM usage: 10443072 KB
Cached memory: 1306944 KB
Individual Memory Consumers:
Name Mem Used (KB) HWM Used (KB) Cached (KB)
========================================================
APPL-DCC 161024 161024 154560
APPL-RM 161472 161472 151104
APPL-GC 161024 161024 152832
APPL-JTS 161280 161280 149824
APPL-LQE 161152 161152 151680
DBMS-DB2 225728 225728 27776
FMP_RESOURCES 22528 22528 0
PRIVATE 4462208 4462208 145664
DB-LQE 685568 685568 68608
DB-JTS 1106816 1106816 110016
DB-GC 602304 602304 59968
DB-RM 718336 718336 71296
DB-DCC 635712 635712 63616
2024-07-12-09.25.40.194000+540 E26302156134F958 LEVEL: Severe
PID : 4288 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-8382 APPID: 10.x.xx.72.64154.240712002540
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 3912 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-09.25.40.194000+540 E26302166647F876 LEVEL: Severe
PID : 4288 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-8382 APPID: 10.x.xx.72.64154.240712002540
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 3912 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-09.25.40.194000+540 I26302167525F592 LEVEL: Severe
PID : 4288 TID : 3912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-8382 APPID: 10.x.xx.72.64154.240712002540
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 3912 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-10.26.05.621000+540 E26302202880F958 LEVEL: Severe
PID : 4288 TID : 9096 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-8226 APPID: 10.x.xx.72.65060.240712012605
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9096 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-10.26.05.621000+540 E26302213393F876 LEVEL: Severe
PID : 4288 TID : 9096 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-8226 APPID: 10.x.xx.72.65060.240712012605
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9096 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-10.26.05.621000+540 I26302214271F592 LEVEL: Severe
PID : 4288 TID : 9096 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-8226 APPID: 10.x.xx.72.65060.240712012605
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9096 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-11.26.31.017000+540 E26302263566F958 LEVEL: Severe
PID : 4288 TID : 8124 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9027 APPID: 10.x.xx.72.49625.240712022630
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 8124 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-11.26.31.033000+540 E26302274079F876 LEVEL: Severe
PID : 4288 TID : 8124 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9027 APPID: 10.x.xx.72.49625.240712022630
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 8124 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-11.26.31.033000+540 I26302274957F592 LEVEL: Severe
PID : 4288 TID : 8124 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9027 APPID: 10.x.xx.72.49625.240712022630
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 8124 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-12.26.56.319000+540 E26302351376F958 LEVEL: Severe
PID : 4288 TID : 1828 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9502 APPID: 10.x.xx.72.50603.240712032656
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1828 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-12.26.56.335000+540 E26302361889F876 LEVEL: Severe
PID : 4288 TID : 1828 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9502 APPID: 10.x.xx.72.50603.240712032656
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1828 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-12.26.56.335000+540 I26302362767F592 LEVEL: Severe
PID : 4288 TID : 1828 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9502 APPID: 10.x.xx.72.50603.240712032656
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1828 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-13.27.21.637000+540 E26302426439F958 LEVEL: Severe
PID : 4288 TID : 9244 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9911 APPID: 10.x.xx.72.51518.240712042721
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9244 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-13.27.21.637000+540 E26302436952F876 LEVEL: Severe
PID : 4288 TID : 9244 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9911 APPID: 10.x.xx.72.51518.240712042721
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9244 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-13.27.21.637000+540 I26302437830F592 LEVEL: Severe
PID : 4288 TID : 9244 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9911 APPID: 10.x.xx.72.51518.240712042721
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9244 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-14.27.46.704000+540 E26302502593F958 LEVEL: Severe
PID : 4288 TID : 4304 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10280 APPID: 10.x.xx.72.52473.240712052746
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 4304 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-14.27.46.704000+540 E26302513106F876 LEVEL: Severe
PID : 4288 TID : 4304 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10280 APPID: 10.x.xx.72.52473.240712052746
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 4304 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-14.27.46.704000+540 I26302513984F592 LEVEL: Severe
PID : 4288 TID : 4304 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10280 APPID: 10.x.xx.72.52473.240712052746
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 4304 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-15.28.11.960000+540 E26302606831F958 LEVEL: Severe
PID : 4288 TID : 7624 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10495 APPID: 10.x.xx.72.53430.240712062811
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7624 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-15.28.11.975000+540 E26302617344F876 LEVEL: Severe
PID : 4288 TID : 7624 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10495 APPID: 10.x.xx.72.53430.240712062811
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7624 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-15.28.11.975000+540 I26302618222F592 LEVEL: Severe
PID : 4288 TID : 7624 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10495 APPID: 10.x.xx.72.53430.240712062811
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7624 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-16.28.37.152000+540 E26303228850F958 LEVEL: Severe
PID : 4288 TID : 7204 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9784 APPID: 10.x.xx.72.54344.240712072837
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7204 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-16.28.37.167000+540 E26303239363F876 LEVEL: Severe
PID : 4288 TID : 7204 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9784 APPID: 10.x.xx.72.54344.240712072837
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7204 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-16.28.37.167000+540 I26303240241F592 LEVEL: Severe
PID : 4288 TID : 7204 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-9784 APPID: 10.x.xx.72.54344.240712072837
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7204 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-16.44.12.075000+540 I26304639123F639 LEVEL: Severe
PID : 4288 TID : 7204 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : LQE
APPHDL : 0-10891 APPID: *LOCAL.DB2.240712074429
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7204 EDUNAME: db2agent (LQE) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:92
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
2024-07-12-16.44.12.106000+540 I26304640545F637 LEVEL: Severe
PID : 4288 TID : 7204 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : RM
APPHDL : 0-11257 APPID: *LOCAL.DB2.240712074430
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 7204 EDUNAME: db2agent (RM) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:92
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
2024-07-12-16.49.12.357000+540 I26305113204F639 LEVEL: Severe
PID : 4288 TID : 1716 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JTS
APPHDL : 0-11199 APPID: *LOCAL.DB2.240712074928
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1716 EDUNAME: db2agent (JTS) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:92
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
2024-07-12-17.29.02.391000+540 E26305299110F958 LEVEL: Severe
PID : 4288 TID : 10232 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10002 APPID: 10.x.xx.72.55296.240712082902
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 10232 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10073
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 287 bytes
Failed to allocate the database shared memory set.
The configured DATABASE_MEMORY plus smaller overflow may have
exceeded INSTANCE_MEMORY or the maximum shared memory on the system.
Attempting to start up with only the system buffer pools.
Database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
994757836
2024-07-12-17.29.02.407000+540 E26305309623F876 LEVEL: Severe
PID : 4288 TID : 10232 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10002 APPID: 10.x.xx.72.55296.240712082902
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 10232 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10093
MESSAGE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
DATA #1 : String, 205 bytes
Failed to allocate the minimum possible database shared memory set.
There are insufficient system resources to allocate the database shared memory set.
Minimum database shared memory set size is (bytes):
DATA #2 : unsigned integer, 8 bytes
532152320
2024-07-12-17.29.02.407000+540 I26305310501F592 LEVEL: Severe
PID : 4288 TID : 10232 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DW
APPHDL : 0-10002 APPID: 10.x.xx.72.55296.240712082902
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 10232 EDUNAME: db2agent (DW) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10105
RETCODE : ZRC=0x850F00C5=-2062614331=SQLO_NO_INS_MEM
"Insufficient instance_memory to allocate new memory"
2024-07-12-17.44.12.314000+540 I26306493678F499 LEVEL: Severe
PID : 4288 TID : 9172 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : JTS
APPHDL : 0-11575 APPID: *LOCAL.DB2.240712084423
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 9172 EDUNAME: db2agent (JTS) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCallDL, probe:20
RETCODE : ZRC=0x00000000=0=HA_ZRC_OK "Unknown"
2024-07-12-17.44.12.330000+540 I26306516811F639 LEVEL: Severe
PID : 4288 TID : 1540 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DCC
APPHDL : 0-11548 APPID: *LOCAL.DB2.240712084424
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1540 EDUNAME: db2agent (DCC) 0
FUNCTION: DB2 UDB, base sys utilities, sqeApplication::AppStartUsing, probe:92
RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
"No memory available in 'Application Heap'"
DIA8301C No memory available in the application heap.
2024-07-12-17.44.12.361000+540 I26306527496F499 LEVEL: Severe
PID : 4288 TID : 1540 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : LQE
APPHDL : 0-11547 APPID: *LOCAL.DB2.240712084425
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1540 EDUNAME: db2agent (LQE) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCallDL, probe:20
RETCODE : ZRC=0x00000000=0=HA_ZRC_OK "Unknown"
2024-07-12-17.44.20.643000+540 I26306603314F627 LEVEL: Severe
PID : 4288 TID : 1072 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : GC
APPHDL : 0-11314 APPID: 10.x.xx.72.54936.240712080640
AUTHID : DB2ADMIN HOSTNAME: moo-ant-elm-db01
EDUID : 1072 EDUNAME: db2agent (GC) 0
FUNCTION: DB2 UDB, routine_infrastructure, sqlerCallDL, probe:190
RETCODE : ZRC=0x8B0F000C=-1961951220=SQLO_NOMEM_STMTH
"No memory available in 'Statement Heap'"
DIA8319C No memory available in the statement heap.