IBM Support

DB2: Create Database command returns error :SQL0970N

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
  

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Database","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;9.1;10.1;10.5;11.1","Edition":"Enterprise Server;Express;Personal;Personal Developer\u0027s;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

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

Manage My Notification Subscriptions