DB2 - Problem description
Problem IC73472 | Status: Closed |
MISLEADING "MESSAGE QUEUE FULL" ERROR MESSAGES IN DB2DIAG.LOG | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
In V9.5 Fixpak 7 on Windows platforms, there may be misleading error messages reported in the db2diag.log e.g. 2010-12-17-13.27.42.859000+060 I25918F726 LEVEL: Error PID : 15240 TID : 11144 PROC : db2bp.exe INSTANCE: db2inst1 NODE : 000 EDUID : 11144 FUNCTION: DB2 UDB, oper system services, sqlowque, probe:35 MESSAGE : Message queue full. QueCb. DATA #1 : Hexdump, 76 bytes 0x0000000004560254 : 0200 0000 F401 0000 0000 0000 C000 0000 ................ 0x0000000004560264 : 0100 0000 C9FF 0700 7518 0000 7451 0100 ........u...tQ.. 0x0000000004560274 : 0000 0000 0000 0000 4643 5230 4F33 3331 ........XXX0O331 0x0000000004560284 : 3639 3136 4100 0000 0000 0000 0000 0000 6916A........... 0x0000000004560294 : 0000 0000 0000 0000 0000 0000 ............ 2010-12-17-13.27.42.874000+060 I26646F404 LEVEL: Error PID : 15240 TID : 11144 PROC : db2bp.exe INSTANCE: db2inst1 NODE : 000 EDUID : 11144 FUNCTION: DB2 UDB, oper system services, sqlowque, probe:36 MESSAGE : Message queue full. Message. DATA #1 : Hexdump, 16 bytes 0x00000001401E8810 : 4400 0000 0000 0000 0000 0000 0100 0000 D............... This can for instance be triggered by the CLP execution of a statement that returns a lot of data to the db2.exe frontend process. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 for Windows users * **************************************************************** * PROBLEM DESCRIPTION: * * Misleading error messages in the db2diag.log. * * These messages do not indicate a problem with DB2. * * The Message queue full situation is handled gracefully * * internally. * * * * The fix for this apar will remove these messages. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V9.5 FixPack 8 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Solution | |
This problem has first been fixed in V9.5 FixPack 8 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.12.2010 29.07.2011 29.07.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.8 |