DB2 - Problem description
Problem IC99984 | Status: Closed |
REDIRECTED RESTORE MAY CAUSE EACCES (13) "PERMISSION DENIED" ERRORS | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
A Redirected Restore may cause EACCES (13) "Permission denied" errors in db2diag.log if the source and target database are located on the same machine. The SET TABLESPACE CONTAINERS statement might attempt to access the old container paths from the source database/instance. In such a case you may observe the following messages in db2diag.log: 2014-02-03-21.05.08.457378+060 E159544A1190 LEVEL: Error (OS) PID : 11928422 TID : 11567 PROC : db2sysc 0 INSTANCE: db2inst4 NODE : 000 DB : SAMPLE APPHDL : 0-46 APPID: *LOCAL.db2inst4.140203200227 AUTHID : DB2INST4 HOSTNAME: localhost EDUID : 11567 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80 MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied" DIA8701C Access denied for resource "", operating system return code was "". CALLED : OS, -, open OSERR : EACCES (13) "Permission denied" DATA #1 : Codepath, 8 bytes 4:11:18:20:24:40 DATA #2 : File name, 38 bytes /db/data1/db2inst3/syscat.cont DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes SQLO_REVISE, SQLO_READWRITE, SQLO_SHAREWRITE, SQLO_FORCE_NON_BUFFERED, SQLO_WRITETHRU DATA #4 : Hex integer, 4 bytes 0x00000180 DATA #5 : signed integer, 4 bytes DATA #6 : Hex integer, 4 bytes 0x08000080 DATA #7 : String, 105 bytes Search for ossError*Analysis probe point after this log entry for further self-diagnosis of this problem. This error message can be ignored and the subsequent restore should be successful. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 5. * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 Version 10.5 Fix Pack 5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.03.2014 13.03.2015 13.03.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.5 |