DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

25.11.2013
10.11.2014
23.09.2015