DB2 - Problem description
Problem IT02081 | Status: Closed |
Error DIA8003C in db2diag.log when applications were forced off in order to pursue an exclusive connection in the Database. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
Error message in db2diag.log instead of report only Information message: 2014-05-21-02.41.12.785000-360 I59232777F594 LEVEL: Error PID : 2104 TID : 3216 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : LOCAL APPHDL : 0-33884 APPID: *LOCAL.DB2.140521084120 AUTHID : DB2ADMIN HOSTNAME: xxxxxxxxxxxxx EDUID : 3216 EDUNAME: db2agent (LOCAL) FUNCTION: DB2 UDB, catalog services, sqlrl_findFn_encap_sysfunc_access, probe:130 RETCODE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED" DIA8003C The interrupt has been received. Looking at event log records the agent 3216 received interrupted with a FORCE: [NODE000 : db2agent : 05/21/2014 02:41:12.787815] ---------------------------------------------------------------- EDUID: 952 Event: SQLE_DIAG_EVENT Sequence No: 000/677895 ID Type: None Diag String: "EvmMgrStat:LocalStop2:LOCAL " The problem only happens in a PureScale environment, all system applications were forced off in order to pursue an exclusive connection in Database. That means which someone requested an exclusive connection to database and it was granted by first forcing all system apps. This action behaves properly, however instead of it receives an error message, it must returns an information note about the forced off to get an exclusive connection to the database. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 in version 10.1 Fix Pack 5. * **************************************************************** | |
Local Fix: | |
Ignore the Error message in db2diag.log. | |
Solution | |
First fixed in version 10.1 Fix Pack 5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.05.2014 27.07.2015 27.07.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.5 |