Troubleshooting
Problem
When a create database command is issued to create a database, Error message SQL0970N is returned: SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009
Symptom
Message on the screen :
-------------------------------------
$db2 create db database_name
database_name is the name of the database.
SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009
Message in db2diag.log :
--------------------------------------
2010-03-09-11.05.40.065143-360 E2689G612 LEVEL: Warning (OS)
PID : 23709 TID : 3086457392 PROC : db2agent (idle) 0
INSTANCE: db2inst8 NODE : 000
APPHDL : 0-500 APPID: *LOCAL.db2inst8.100309164704
AUTHID : DB2INST8
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:100
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, unspecified_system_function OSERR: EACCES (13)
DATA #1 : File name, 15 bytes
/tmp/SQLDIR.LK0
Log InLog in to view more of this document
Was this topic helpful?
Document Information
More support for:
Db2 for Linux, UNIX and Windows
Software version:
9.7, 9.5, 9.1, 10.1, 10.5, 11.1
Operating system(s):
AIX, HP-UX, Linux, Solaris
Document number:
402043
Modified date:
30 April 2025
UID
swg21423666