Symptom
- Db2 backup operation failed with disk error.
- db2diag.log (under /db2/<SID>/db2dump)
Example:
2025-09-03-10.18.49.370468+330 I802574876E1455 LEVEL: Error
PID : 13632 TID : 140305105938176 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
HOSTNAME: abcde
EDUID : 8304 EDUNAME: db2pfchr (abc) 0
FUNCTION: DB2 UDB, oper system services, sqloReadVLow, probe:100
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
DIA8402C A disk error has occurred.
DATA #1 : Codepath, 8 bytes
7:9:25
DATA #2 : String, 17 bytes
preadv() failed !
2025-09-03-10.18.59.599576+330 I802577884E678 LEVEL: Error
PID : 13632 TID : 140417051911936 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-16361 APPID: *LOCAL.db2abc.250909153107
AUTHID : DB2abc HOSTNAME: abcde
EDUID : 9639 EDUNAME: db2bm.9611.4 (abc) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbServiceDirectReadVRequest, probe:6903
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
DIA8402C A disk error has occurred.
DATA #1 : String, 31 bytes
Error in sqlbServiceDirectReadV
DATA #2 : unsigned integer, 4 bytes
2
2025-09-03-10.18.59.607749+330 I802578563E632 LEVEL: Severe
PID : 13632 TID : 140417051911936 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-16361 APPID: *LOCAL.db2abc.250909153107
AUTHID : DB2abc HOSTNAME: abcde
EDUID : 9639 EDUNAME: db2bm.9611.4 (abc) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbpfParallelDirectReadV, probe:7121
MESSAGE : ZRC=0x860F0003=-2045837309=SQLO_DERR "disk error occurred (DOS)"
DIA8402C A disk error has occurred.
DATA #1 : String, 26 bytes
Error during direct Read V
2025-09-03-10.18.59.682298+330 I802602032E958 LEVEL: Error
PID : 13632 TID : 140303663097600 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : abc
APPHDL : 0-16361 APPID: *LOCAL.db2abc.250909153107
AUTHID : DB2abc HOSTNAME: abcde
EDUID : 9640 EDUNAME: db2bm.9611.0 (abc) 0
FUNCTION: DB2 UDB, database utilities, sqlubReadDMS, probe:368
MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist"
DIA8506C Unexpected end of file was reached.
DATA #1 : String, 20 bytes
Object access error:
DATA #2 : Pool ID, PD_TYPE_POOL_ID, 2 bytes
26
Read more...
Environment
- SAP on IBM Db2 for Linux, Unix and Windows
Product
Keywords
Backup failure, disk error, DOS, preadv(), DIA8402C, DIA8506C, object access error, unexpected end of file, sqlbServiceDirectReadV , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem
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.
SAP Knowledge Base Article - Preview