Unnecessary warning messages with below functions that should be
handle as information (info) and not as warning:
In db2diag.log there are warnings messages below without any
error messages in the subsequent events:
======================================================
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx LEVEL:
Warning
PID : 18754 TID : 140087979403008 PROC :
db2sysc 0
INSTANCE: xxx NODE : 000 DB : xxxx
APPHDL : 0-3057 APPID:
142.150.183.125.50938.150211120
AUTHID : xxx HOSTNAME: xxxxx
EDUID : 2906 EDUNAME: db2agntcol (WHP) 0
FUNCTION: DB2 UDB, CDE Runtime Joins,
JoinSpillInfo::configSpillScheme,
probe:3474
DATA #1 : String, 181 bytes
BuildMem: Reserved build mem: numThreads: 8 numBuildThreads: 8
maxConcBuilds: 8 Engaged agents: 2 maxBuildMemBytes: 98023552
17
totalResTempMem: 784191488 tempKeyArrayBytes: 784188416
DATA #2 : Function name in Library, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address
is NULL
DATA #3 : File name, 17 bytes
JoinSpillInfo.cpp
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx LEVEL:
Warning
PID : 18754 TID : 140123924588288 PROC :
db2sysc 0
INSTANCE: xxx NODE : 000 DB : xxx
APPHDL : 0-3057 APPID:
142.150.183.125.50938.150211120
AUTHID : xxxxx HOSTNAME: xxxxxxxx
EDUID : 2837 EDUNAME: db2agntcol (WHP) 0
FUNCTION: DB2 UDB, CDE Aggregation,
GroupByControlBlock::throttleConcurrentMergeThreads, probe:3379
DATA #1 : String, 156 bytes
Thread 7 unable to reserve extra memory for global HTs.
need 56714596
got 31967344
claim 11789964
HT 11789964
EM HT 0
inUse 693098384Page 21 of 26
surplus 31967344
DATA #2 : Function name in Library, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address
is NULL
DATA #3 : File name, 23 bytes
GroupByControlBlock.cpp
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx LEVEL: Warning
PID : 18754 TID : 140122888595200 PROC :
db2sysc
INSTANCE: xxxxxx NODE : 000 DB :xxxxx
APPHDL : 0-3057 APPID:
142.150.183.125.50938.150211120
AUTHID : xxxxxx HOSTNAME: xxxxxxxxx
EDUID : 2899 EDUNAME: db2agntcol (WHP) 0
FUNCTION: DB2 UDB, CDE Aggregation,
GroupByControlBlock::throttleConcurrentMergeThreads, probe:3379
DATA #1 : String, 156 bytes
Thread 1 unable to reserve extra memory for global HTs.
need 73946064
got 20373648
claim 11789964
HT 11789964
EM HT 0
inUse 704692080
surplus 20373648
DATA #2 : Function name in Library, 0 bytesPage 15 of 17
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason:
Address
is NULL
DATA #3 : File name, 23 bytes
GroupByControlBlock.cpp |
