DB2 - Problem description
Problem IC73208 | Status: Closed |
DB2 BACKGROUND EDUS MIGHT BE SHUT DOWN UNEXPECTEDLY DURING NODE FAILURE RECOVERY | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
The WLM statistics daemon background EDU might get interrupted by node failure recovery and shut down rather than handling the interrupt and continuing execution. When the problem occurs, you will see db2diag.log messages like below: 2010-09-21-04.22.53.383850-240 E187460E358 LEVEL: Info PID : 31072 TID : 47720668588352PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 EDUID : 18 EDUNAME: db2pdbc 1 FUNCTION: DB2 UDB, base sys utilities, sqleExecuteNodeRecovery, probe:1 DATA #1 : String, 34 bytes Starting node recovery for node 20 2010-09-21-04.22.53.384160-240 I187819E590 LEVEL: Warning PID : 31072 TID : 47720509204800PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : SAMPLE APPHDL : 1-87 APPID: *N1.DB2.100921080237 AUTHID : db2inst1 EDUID : 92 EDUNAME: db2wlmd (SAMPLE) 1 FUNCTION: DB2 UDB, WLM, sqlrwWlmStatsCollector::main, probe:20 RETCODE : ZRC=0x800F0003=-2146500605=SQLO_INTRP "Interrupt. User Cancel." DIA8003C The interrupt has been received. DATA #1 : String, 34 bytes WLM Stats Collector Shutting Down. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See above Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 8 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in Version 9.5 Fix Pack 8 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.12.2010 30.06.2011 30.06.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 |