Checking for read only on the Linux file system is required when investigating certain DB2 problems especially disk errors
For example, I saw an error :
--from db2diag.log SQL1042C An unexpected system error occurred. SQLSTATE=58004 . --from linux logs Dec 19 08:02:05 server1 kernel: Buffer I/O error on device dm-18, logical block 1562696 Dec 19 08:02:05 server1 kernel: lost page write due to I/O error on dm-18 Dec 19 08:02:05 server1 kernel: SCSI error : <0 0 2 0> return code = 0x20000 Dec 19 08:02:05 server1 kernel: end_request: I/O error, dev sdc, sector 12503752
Some root cause analysis highlighted a disk error causing a Linux mountpoint to become a read only.
Commands to check for read only Linux file system
grep ‘ro’ /proc/mounts --miss remote mounts grep ' ro ' /proc/mounts | grep -v ':'