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

pagwu · #1 (**permalink**) 10-07-07, 17:57

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.

Thanks

stolze · #2 (**permalink**) 10-08-07, 09:52

Check who has access to "/pap/data/db01/" (including the parent directories). The DB2 instance owner must be allowed to write to those directories.

Code:

$ db2 "? sql1326"


SQL1326N The file or directory "<name>" cannot be accessed.

Explanation:

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech