Commands to check for read only Linux file system

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 ':'

 Read More

Linux multipath command

DB2 and Linux IO testing tools

Display Linux CPU information