Hello friends,

i installed ibm db2 udb v8.2 on a red hat enterprise linux v4.1, after this when i tryed to restore the db it showing that the file has only read permission..... but i given all permission to them with "" chmod "" command. the message is as follows;

""" MSG: SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009 """

can any one plz post your view on this......

Typically, all the directories and sub-directories an instance should be owned by the instance owner (not just read/write authority).

hello marcus,

you are wright, can plz..... some more explanation about this

This usually happens when you copy the DB2 installation file with other user than root. With root id, you should run the following 2 commands


chown root filename.tar
chgrp root filename.tar


If you instal it from the CD with root id, you shouldn't have any problems.

Or combine this into a single command: