IBM Support

SQL1326N The file or directory cannot be accessed

Troubleshooting


Problem

Error code "SQL1326N" on database directory when running DB2 utilities: db2 autoconfigure apply none SQL1326N The file or directory "/home/db2inst1/db2inst1" cannot beaccessed.

Symptom

In db2diag.log, the following error message could be seen:
2010-04-26-12.21.31.193710-300 I2173042A1713 LEVEL: Error (OS)
PID : 1007844 TID : 1 PROC : db2fmp (5187) 0
INSTANCE: db2inst1 NODE : 000
EDUID : 1 EDUNAME: db2fmp (5187) 0
FUNCTION: DB2 Common, OSSe, ossErrorIOAnalysis, probe:100
CALLED : OS, -, open
OSERR : EACCES (13) "The file access permissions do not allow the specified action."
DATA #1 : String, 149 bytes
A total of 2 analysis will be performed :
- User info
- Path access permission

Target file = /home/db2inst1/db2inst1/NODE0000/sqldbdir/sqldbdir
DATA #2 : String, 192 bytes
Real user ID of current process = 40801
Effective user ID of current process = 40801
Real group ID of current process = 40800
Effective group ID of current process = 40800
DATA #3 : String, 283 bytes
Information of each subdirectory leading up to the first inaccessible one is shown in the format below :
<UID>:<GID>:<permissions> (subdirectories)

591:500:2755 (home)
39215:500:2755 (db2inst1)
39215:500:2774 (db2inst1)

Cannot descend any further than the above subdirectory.
CALLSTCK:
[0] 0x09000000061CF314 pdOSSeLoggingCallback + 0x34
[1] 0x090000000198B424 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1C4
[2] 0x090000000198B900 ossLogSysRC + 0xA0
[3] 0x09000000019AB08C ossErrorIOAnalysis__FCPC21OSSErrorAnalysisParam + 0xC4C
[4] 0x09000000019AD108 ossErrorAnalysis@AF12_1 + 0x48
[5] 0x0900000006115384 sqloSystemErrorHandler + 0x3DC
[6] 0x0900000006126D84 sqloSystemErrorHandler@glue1EA + 0x1AC
[7] 0x090000000695D2B0 sqloopenp + 0x640
[8] 0x09000000069A4DBC sqlegopn__FPcP12SQLO_FHANDLEc + 0x98
[9] 0x09000000069A5368 sqledogd__FP8SQLE_BWAcT2 + 0x330

The above error indicates "db2fmp" process has trouble to access directory /home/db2inst1/db2inst1:
591:500:2755 (home)
39215:500:2755 (db2inst1)
39215:500:2774 (db2inst1)

The first column represents the UID for the directory owner; and the second column represents the GID for the directory; the last column represents the permission.

The following information represents the UID for the current process (in this case, it represents db2fmp process:
Real user ID of current process = 40801
Effective user ID of current process = 40801
Real group ID of current process = 40800
Effective group ID of current process = 40800

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"OTHER - Uncategorised","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21429756

Page Feedback