Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18

    Unanswered: regarding SQL0970N

    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......

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Typically, all the directories and sub-directories an instance should be owned by the instance owner (not just read/write authority).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jul 2007
    Location
    Bangalore
    Posts
    18
    hello marcus,

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

  4. #4
    Join Date
    Oct 2004
    Posts
    268
    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.

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Or combine this into a single command:
    Code:
    $ chown <user>.<group> <file>
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •