DB2 - Problembeschreibung
Problem IT07435 | Status: Geschlossen |
UNNECESSARY WARNING MESSAGES WITH THROTTLECONCURRENTMERGETHREADS AND THROTTLECONCURRENTMERGETHREADS FUNCTIONS IN BLU ENVIRONMENT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fix Pack 7 * **************************************************************** | |
Local-Fix: | |
The warning message can be ignored. | |
Lösung | |
First Fixed in DB2 10.5 Fix Pack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.03.2015 09.05.2017 09.05.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |