|
Problem IC62595
|
Status: Closed |
ECF_FILE_PATH_ACCESS_DENIED ERROR IS LOGGED IN DB2DIAG.LOG WHEN GET_DBSIZE_INFO(?, ?, ?, 0) RUNS SUCCESSFULLY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
ECF_FILE_PATH_ACCESS_DENIED error is logged in db2diag.log
when get_dbsize_info(?, ?, ?, 0) runs successfully.
2009-01-22-15.31.07.315156-300 I1169A1178 LEVEL: Error
(OS)
PID : 1056856 TID : 1029 PROC : db2fmp
(C)
INSTANCE: psustr NODE : 000
EDUID : 1029 EDUNAME: db2fmp (C)
FUNCTION: DB2 Common, OSSe, ossGetDiskInfo, probe:90
MESSAGE : ECF=0x90000017=-1879048169=ECF_FILE_PATH_ACCESS_DENIED
Access was denied to a component of the path
CALLED : OS, -, statvfs
OSERR : EACCES (13) "The file access permissions do not allow
the specified action."
DATA #1 : String, 51 bytes
/home8/psustr/psustr/NODE0000/SQL00001/systoolspace
DATA #2 : unsigned integer, 8 bytes
1
CALLSTCK:
[0] 0x0900000037AD5090 oss_log__FP9OSSLogFacUiN32UlN26iPPc +
0x1B0
[1] 0x0900000037AD5594 ossLogSysRC + 0x74
[2] 0x0900000037AE9F98 ossGetDiskInfo + 0x7D8
[3] 0x0900000033CA1798 snapshot_cntrfs + 0x918
[4] 0x0900000040060D2C sqloInvokeFnArgs + 0xCB8
[5] 0x090000003FAB36A0
@76@sqlerRunRoutine__FP13sqleInvokerCBPi + 0x320
[6] 0x090000003FAB136C sqlerDyload + 0x1A8
[7] 0x090000003FACA154 sqlerFmpListener + 0x144
[8] 0x090000003FAA53F4 sqlerWorkerThreadEntry__FPv + 0x1C4
[9] 0x090000000045343C _pthread_body + 0xDC
This is related to file permission on database directory
/home8/psustr/psustr/NODE0000/SQL00001 when system managed
tablespace SYSTOOLSPACE is used. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* ECF_FILE_PATH_ACCESS_DENIED error is logged in db2diag.log *
* *
* when get_dbsize_info(?, ?, ?, 0) runs successfully. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 FP1 or higher. *
**************************************************************** |
| Local Fix: |
Add execute permission for other to the tablespace directory
SQL00001. This must be done for any databases that were created
prior to v9.7 Fixpack 1 even if the current Fixpack level is
v9.7 Fixapck 1 or higher. Any new databases created on v9.7
Fixpack 1 or higher will already have the proper execute
permission on the tablespace directory. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Execute permission for other was added to database directory.
This eliminates the error
that was logged in the db2diag.log. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.08.2009
23.02.2010
23.03.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
