DB2 - Problem description
| Problem IT04014 | Status: Closed |
PREFETCHING CAUSES DB MARKED BAD WHEN SYSTEM ERROR OCCURS IN SQLOCSEMV | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
| Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 5 * **************************************************************** | |
| Local Fix: | |
| 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 : | 26.08.2014 13.07.2015 13.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 |
|