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.
In addition to above, user might observe different symptoms
being consequence of the same problem:
2015-09-10-11.15.26.388472+120 E2425139A438 LEVEL: Error
(OS)
PID : 14614780 TID : 9320 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 9320 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services, sqloCSemV, probe:1
MESSAGE : ZRC=0x8300000B=-2097151989
CALLED : OS, -, unspecified_system_function
OSERR : EAGAIN (11) "Resource temporarily unavailable"
2015-09-10-11.15.26.388874+120 I2425578A356 LEVEL: Error
PID : 14614780 TID : 9320 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 9320 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbServiceDirectReadRequest, probe:0
DATA #1 : String, 15 bytes
Semaphore Error
2015-09-10-11.15.26.388991+120 I2425935A350 LEVEL: Error
PID : 14614780 TID : 9320 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 9320 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbServiceDirectReadRequest, probe:2
MESSAGE : ZRC=0x8300000B=-2097151989
2015-09-10-11.15.26.389112+120 I2426286A457 LEVEL: Error
PID : 14614780 TID : 9320 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 9320 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services,
sqlbServiceDirectReadRequest, probe:2
DATA #1 : String, 115 bytes
Obj={pool:0;obj:2;type:3} State=x27
Prefetcher sqlbServiceDirectReadRequest: Latch Error: BRINGING
THE SYSTEM DOWN |
