Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007

    Unanswered: How can I resolve a "SQL1326N: The file or directory cannot be accessed" restore prob

    Hi all,

    I am having problem completing this restore operation.

    "db2 restore database AAMI01 from /pap/data/backups taken at 20071002130554 to /pap/data/db01 into AAMI01 NEWLOGPATH /pap/data/new/log WITH 2 BUFFERS BUFFER 1024"

    SQL1326N The file or directory "/pap/data/db01/" cannot be accessed.

    The file, directory and path all exist. I created them. I just can't understand why I can't tell restore where I want to put down the database.

    If I remove the " to /pap/data/db01", restore will try to put the DB in a directory that I want to avoid. I want to restore to "/pap/data/db01" specifically.

    Can someone tell me what I am doing wrong here? Or what I need to do? My ID have all the permission that I need to write to the path.


  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    Check who has access to "/pap/data/db01/" (including the parent directories). The DB2 instance owner must be allowed to write to those directories.

    $ db2 "? sql1326"
    SQL1326N The file or directory "<name>" cannot be accessed.
    The file or directory "<name>" cannot be accessed because either
    the file permissions are incorrect, the file path is incorrect,
    or there is insufficient space in the directory or path.
    User Response:
    Verify that any path or filename specified in the command is
    valid, you have the proper permissions to access the path or
    filename, and there is sufficient space to contain the file.
    Correct the problem and resubmit the command.  If the problem
    persists, contact your System Administrator.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2012

    Resolve the issue SQL1326N

    Provide the premission 775 to your database directory - "/pap" recursively (all its sub directory and files). It will work.

Posting Permissions

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