Saturday, May 5, 2012

SQL0970N The system attempted to write to a read-only file. SQLSTATE=5500

I got this message when I removed the earlier installed DB2 and installed V9.5  of DB2 and I wanted to create a WAREHOUS user  ( db2 create database WAREHOUS )

SQL0970N The system attempted to write to a read-only file. SQLSTATE=5500

Turns out that I did not have the write perms on the /tmp folder on my RHEL server where I was installing.

chmod ugo+w /tmp - did it.

Looking at the dbinst1/sqllib/db2diag.log - told something about the permission in that folder.




No comments:

Post a Comment