DB2 - Problem description
Problem IC88994 | Status: Closed |
CHANGING sqm___delete_sqlmon_stmt DB2DIAG.LOG ERROR TO INFORMATIONAL | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
Error messages may be seen periodically like below: 2012-11-29-11.11.01.937611-300 E73957A6628 LEVEL: Error PID : 1000000 TID : 53000 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : Sample APPHDL : 0-36608 APPID: 10.11.71.32.45186.121129154421 AUTHID : DB2INST1 EDUID : 53000 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, database monitor, sqm___delete_sqlmon_stmt, probe:502 DATA #1 : String, 37 bytes stmt_entry already on the free list. DATA #2 : Pointer, 8 bytes 0x07800000034d7c80 DATA #3 : Hexdump, 992 bytes ******************************** It is being logged because we have identified a scenario where the next statement being attempted to be added to the free list of statements is already there on this free list. This will reduce the severity of the message to an informational instead of error. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to fix pack 3 to avoid this issue. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
Fixed in fix pack 3. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.12.2012 01.10.2013 01.10.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.3 | |
10.1.0.3 |