SAP Knowledge Base Article - Preview

3240227 - DB6: "db2diag -A" returns read-only error

Symptom

The database goes down. You notice following symptom:

  1. "db2diag -A" returns following error:

    db2diag: The file is part of a read-only file system.

    As the result, db2diag.log file has not been updated for some time.

  2. Connection to database takes a long time (1-2 minutes) until it returns SQL1036C error.

    db2 connect to <SID>
    SQL1036C  An I/O error occurred while accessing the database.  SQLSTATE=58030


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

db2diag -A, db2diag.log, read-only, SQL1036C , 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.