SAP Knowledge Base Article - Preview

2815703 - DB6: database shuts down due to logging service stopping

Symptom

The database shuts down due to error while writing to log files.

db2diag.log:

2019-06-06-06.06.06.317000+330 I91991019F421 LEVEL: Error
PID : 12345 TID : 1234 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
HOSTNAME: ABCDEF
EDUID : 1234 EDUNAME: db2loggw (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlpgWriteNLogPagesInternal, probe:51
MESSAGE : ZRC=0x830000AA=-2097151830
(Note: The return code could also be 
"ZRC=0x8300045D=-2097150883"
"ZRC=0x8610000D=-2045771763")
2019-06-06-06.06.06.325000+330 I91991442F558 LEVEL: Error
PID : 12345 TID : 1234 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
HOSTNAME: ABCDEF
EDUID : 1234 EDUNAME: db2loggw (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlpgWriteNLogPages, probe:61
MESSAGE : Error Writing Log Pages. offset / writeLimit / pagesRemained
DATA #1 : unsigned integer, 8 bytes
7286
DATA #2 : unsigned integer, 8 bytes
1
DATA #3 : unsigned integer, 8 bytes
1
2019-06-06-06.06.06.327000+330 E91992002F486 LEVEL: Severe
PID : 12345 TID : 1234 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
HOSTNAME: ABCDEF
EDUID : 1234 EDUNAME: db2loggw (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqlpgWriteToDisk, probe:1370
MESSAGE : ZRC=0x830000AA=-2097151830
DATA #1 : <preformatted>
Error while writing to log file S0012345.LOG
2019-06-06-06.06.06.347000+330 E91993308F991 LEVEL: Severe
PID : 12345 TID : 1234 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
HOSTNAME: ABCDEF
EDUID : 1234 EDUNAME: db2loggw (ABC) 0
FUNCTION: DB2 UDB, data protection services, SQLP_DBCB::setLogState, probe:5000
DATA #1 : <preformatted>
Database error has been detected. As a result, for precautionary reasons
all logging services have been stopped.
2019-06-06-06.06.06.347000+330 I91994301F599 LEVEL: Error
PID : 12345 TID : 1234 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
APPHDL : 0-000 APPID: ***
AUTHID : SAPABC HOSTNAME: ABCDEF
EDUID : 1234 EDUNAME: db2agent (RSP) 0
FUNCTION: DB2 UDB, data protection services, sqlpWriteToLog, probe:90
MESSAGE : The log state was marked bad by another process, this message is not
an indication of an error with the logger process.
2019-06-06-06.06.06.504000+330 I92000654F410 LEVEL: Severe
PID : 12345 TID : 1234 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
HOSTNAME: ABCDEF
EDUID : 1234 EDUNAME: db2loggw (ABC) 0
FUNCTION: DB2 UDB, data protection services, sqpLoggwEdu::sqlpLoggwMain, probe:4330
MESSAGE : Logging can not continue.
2019-06-06-06.06.06.074000+330 E92020831F605 LEVEL: Severe
PID : 12345 TID : 54321 PROC : db2syscs.exe
INSTANCE: DB2ABC NODE : 000 DB : ABC
APPHDL : 0-000 APPID: ***
AUTHID : SAPABC HOSTNAME: ABCDEF
EDUID : 54321 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, base sys utilities, sqleDoForceDBShutdownFODC, probe:16482
MESSAGE : ADM7518C The database manager has shut down the following database
because a severe error has occurred: "ABC ".


The log writer gets error while trying to write to log page. As the result, the logging service is stopped, and database shuts down.


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

-2097151830, -2097150883, sqlpgWriteNLogPagesInternal, sqlpWriteToLog , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.