Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

database crashed unexpected

Sometimes during a normal backup our database (V10.1.0002) goes down and have to be started from clp with crash recovery. The following entries are the first which are written when the error is shown.

2014-04-16-10.30.04.943389+120 E199265E590       LEVEL: Severe
PID : 28736            TID : 140352753231616 PROC : db2wdog 0 [db2q68]
INSTANCE: db2q68           NODE : 000

HOSTNAME: alihrcs2q

EDUID   : 2                EDUNAME: db2wdog 0 [db2q68]

FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20

MESSAGE : ADM0503C  An unexpected internal processing error has occurred. All

      DB2 processes associated with this instance have been shutdown.
      Diagnostic information has been recorded. Contact IBM Support for
      further assistance.

2014-04-16-10.30.05.099303+120 I199856E505       LEVEL: Error
PID : 28754            TID : 140358231553824 PROC : db2vend (PD Vendor Process - 1)
INSTANCE: db2q68           NODE : 000

HOSTNAME: alihrcs2q

FUNCTION: DB2 UDB, oper system services, DB2VEND_main, probe:1040

MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"

      DIA8506C Unexpected end of file was reached.

DATA #1 : String, 63 bytes

Fenced vendor process pipe failure, terminating vendor process.

2014-04-16-10.30.06.913208+120 I203841E491           LEVEL: Severe
PID     : 28901                TID : 140220162938624 PROC : db2fmp (
INSTANCE: db2q68               NODE : 000            DB   : Q68    
APPID   : *LOCAL.db2q68.140416083006
HOSTNAME: alihrcs2q
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:12
RETCODE : ZRC=0xFFFFFB95=-1131
          SQL1131N  A stored procedure process has been terminated abnormally.
          Routine name: "". Specific name: "".

2014-04-16-10.30.07.137180+120 I204333E485           LEVEL: Error
PID     : 28901                TID : 140220162938624 PROC : db2fmp (
INSTANCE: db2q68               NODE : 000            DB   : Q68    
APPID   : *LOCAL.db2q68.140416083006
HOSTNAME: alihrcs2q
FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener, probe:999
MESSAGE : FMP exiting with error. Last agent registered:
DATA #1 : Hexdump, 4 bytes
0x00007F878D008BD4 : 7800 0000                                  x...

Does anybody here has shown sometimes the same error situation?

Regards

Olaf

Former Member
Former Member replied

For your information it was an oom error which kills the most memory consumtion process and this was db2sysc.

Olaf

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question