Results 1 to 2 of 2

Thread: restore problem

  1. #1
    Join Date
    Feb 2002
    Location
    Hamilton
    Posts
    150

    Unanswered: restore problem

    I am having difficulties with a restore command.

    I have an offline full backup from a AIX 5.1 server running db2 v8 FP2 and want to restore that to another server same platform.

    I am not sure if I have to do a redirect restore but this is what I get when I try the following command:

    $ db2 restore db pldb from /home/symd1 taken at 20030828131625 to /tmp into pldb1
    SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009

    Now the path /tmp is not the location of the original database on the original server, I am just testing stuff out here but is it important to have the same location for the database on the new server?

    thanks

    mark

  2. #2
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    Try Redirected Restore.

    Hi,

    Please check if you have the necessary permission for writing to that filesystem. Unix systems are very particular about permissions. If the permissions are okay then you need to do a redirected restore. That should solve your issues.

    Also please check the value of the DB2_LDAP_ENABLE parameter preferably set that to NO before you do a restore as we had some problems doing a redirected restore when the above parmater was set to Yes.

    Hope this helps

    Nitin.

Posting Permissions

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