DB2 - Problembeschreibung
Problem IT04014 | Status: Geschlossen |
PREFETCHING CAUSES DB MARKED BAD WHEN SYSTEM ERROR OCCURS IN SQLOCSEMV | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
Failure of msgsnd with EAGAIN will cause prefetcher inintialization to fail, resulting in database marked bad. 2013-10-23-19.35.38.562700-240 E12789A534 LEVEL: Error (OS) PID : 37945760 TID : 51917 PROC : db2sysc INSTANCE: jefferya NODE : 000 DB : FOO APPHDL : 0-183 APPID: *LOCAL.jefferya.131023233338 AUTHID : JEFFERYA EDUID : 51917 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, oper system services, sqloCSemV, probe:1 MESSAGE : ZRC=0x8300000B=-2097151989 CALLED : OS, -, unspecified_system_function OSERR : EAGAIN (11) "Resource temporarily unavailable" 2013-10-23-19.35.38.563378-240 I13324A439 LEVEL: Error PID : 37945760 TID : 51917 PROC : db2sysc INSTANCE: jefferya NODE : 000 DB : FOO APPHDL : 0-183 APPID: *LOCAL.jefferya.131023233338 AUTHID : JEFFERYA EDUID : 51917 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, buffer pool services, sqlbpfTriggerPrefetch, probe:1 MESSAGE : ZRC=0x8300000B=-2097151989 2013-10-23-19.35.38.563814-240 I13764A495 LEVEL: Error PID : 37945760 TID : 51917 PROC : db2sysc INSTANCE: jefferya NODE : 000 DB : FOO APPHDL : 0-183 APPID: *LOCAL.jefferya.131023233338 AUTHID : JEFFERYA EDUID : 51917 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, buffer pool services, sqlbpfTriggerPrefetch, probe:1 DATA #1 : String, 65 bytes sqlbpfTriggerPrefetch : bad rc returned from sqlbPFGetFreeRequest 2013-10-23-19.35.38.719140-240 E25922A759 LEVEL: Error PID : 37945760 TID : 51917 PROC : db2sysc INSTANCE: jefferya NODE : 000 DB : FOO APPHDL : 0-183 APPID: *LOCAL.jefferya.131023233338 AUTHID : JEFFERYA EDUID : 51917 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:10 MESSAGE : ADM14005E The following error occurred: "AppErr". First Occurrence Data Capture (FODC) has been invoked in the following mode: "Automatic". Diagnostic information has been recorded in the directory named "/home/jefferya/sqllib/db2dump/FODC_AppErr_2013-10-23-19.35.38.7 07884 _37945760_51917_000/". 2013-10-23-19.35.38.939308-240 E130475A960 LEVEL: Critical PID : 37945760 TID : 51917 PROC : db2sysc INSTANCE: jefferya NODE : 000 DB : FOO APPHDL : 0-183 APPID: *LOCAL.jefferya.131023233338 AUTHID : JEFFERYA EDUID : 51917 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10 MESSAGE : ADM14001C An unexpected and critical error has occurred: "DBMarkedBad". The instance may have been shutdown as a result. "Automatic" FODC (First Occurrence Data Capture) has been invoked and diagnostic information has been recorded in directory "/home/jefferya/sqllib/db2dump/FODC_DBMarkedBad_2013-10-23-19.35 .38.9 37140_0000/". Please look in this directory for detailed evidence about what happened and contact IBM support if necessary to diagnose the problem. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in Version 10.1 Fix Pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.08.2014 13.07.2015 13.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |