3756829 - DB6 - Disk Errors (SQL10004C, DIA8402C) - Automatic Reorganisation Failure

Symptom

DB2 database disk I/O errors can cause automatic REORG operations to fail.
Reported errors may include SQL10004C (An I/O error occurred while accessing the database or database directory, SQLSTATE=58031),
DIA8402C (A disk error has occurred), SQLO_DERR (disk error occurred (DOS)), and OSERR EIO (5) entries recorded in the db2diag.log

Environment

Db2 LUW IBM

Product

SAP ERP all versions ; SAP NetWeaver all versions ; SAP Solution Manager all versions

Keywords

SQL10004C, DIA8402C, SQLSTATE 58031, OSERR EIO (5), disk I/O error, OS-level I/O failure, DB2 disk error, database file access failure, REORG failure, automatic REORG failure, db2diag.log error, storage I/O failure, file system I/O error, disk read failure, database corruption due to I/O, DB2 read error, DB2 storage error, OS-level disk failure, DB2 diagnostic error, DB2 database access failure , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.