home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 FixList